Course Outline

Introduction

  • ClickHouse vs MySQL vs Oracle
  • Overview of ClickHouse features and architecture

Understanding Column-Oriented Databases

Getting Started

  • Setting up the environment
  • Installing ClickHouse
  • Connecting to the database

Managing Users and Roles

  • Role-Based Access Control (RBAC)
  • XML vs SQL configuration
  • Users, roles, and privileges

Working with the ClickHouse Database

  • SQL syntax, functions, and operators
  • Creating and modifying tables
  • Loading data
  • Creating a schema
  • Running analytic queries
  • Using views, indexes, and arrays

Administering the ClickHouse Database

  • Replication and sharding
  • Resource utilization
  • Backing up and restoring data
  • Optimizing performance

Integrating ClickHouse with External Systems

  • ODBC and JDBC
  • HDFS, Amazon S3, and EmbeddedRocksDB
  • MySQL, PostgreSQL, SQLite, and Hive
  • MongoDB and RabbitMQ
  • Apache Kafka

Troubleshooting

Summary and Next Steps

Requirements

  • An understanding of relational databases
  • Experience with SQL

Audience

  • Developers
  • IT professionals
  14 Hours
 

Testimonials

Related Courses

SQL in Microsoft Access

  14 hours

Microsoft Access - download the data

  14 hours

VBA For Access & Excel

  21 hours

Access - Data Base Designing

  21 hours

Access Advanced

  21 hours

Access Intermediate

  14 hours

Data Management

  35 hours

MarkLogic Server

  14 hours

SAP ASE for Database Administrators

  28 hours

Pivotal Greenplum for Developers

  21 hours

MongoDB for Administrators

  14 hours

MongoDB for Developers

  14 hours

MongoDB for Advanced Users

  14 hours

Administrating Percona Server for MongoDB

  7 hours