Getting Started With ClickHouse
The course starts by introducing you to ClickHouse, a high-performance columnar database management system.
You’ll learn how to install ClickHouse and connect to a ClickHouse server using tools like DBeaver.
From there, the course dives deep into ClickHouse SQL.
You’ll learn about the different SQL languages like Data Definition Language (DDL), Data Query Language (DQL), and Data Manipulation Language (DML).
The course covers various SQL concepts such as operators, data types (numeric, string, date/time, arrays, tuples, nested, and more), joins, and unions.
One of the key topics covered is the MergeTree table engine, which is the foundation of ClickHouse’s performance.
You’ll understand how MergeTree works, its data directory structure, primary keys, and how to create MergeTree tables with partitions.
The course also explores the different MergeTree engine variants like ReplacingMergeTree, SummingMergeTree, AggregatingMergeTree, and CollapsingMergeTree.
If you’re interested in setting up a multi-node ClickHouse environment, the course has you covered.
You’ll learn about data replication using ReplicatedMergeTree engines and data sharding with the Distributed table engine.
The course also covers ClickHouse integrations with external data sources like MySQL, PostgreSQL, MongoDB, and Apache Kafka.
This is particularly useful if you need to work with data from different sources.
For those interested in administering a ClickHouse server, the course covers configuring the server, role-based access control, user management, roles, settings profiles, and quotas.
You’ll also learn about backups and system tables in ClickHouse.
Additionally, the course introduces you to various ClickHouse utilities like clickhouse-copier, clickhouse-local, and clickhouse-benchmark.
If you have the time, there’s an optional section on SQL functions in ClickHouse.
This covers data type conversion, date and time functions, string functions, array functions, JSON functions, aggregate functions, combinators, user-defined functions, and window functions.
You’ll learn everything from the basics to advanced topics like multi-node setups and integrations.