Learn ClickHouse® - A Fast Open-Source OLAP DBMS

Learn ClickHouse®, the fastest and the most powerful database that can easily handle Petabytes of data! ClickHouse is an Open-Source columnar data store developed by ClickHouse Inc. Some of the highlights of this course are

• All lectures have been designed from the ground up to make the complex topics easy to understand

• 300+ SQL examples demonstrated in the video lectures

• Precise and informative video lectures

• 200 + Quiz questions and counting

• Assignments

• Covers a wide range of topics in ClickHouse

After completing this course, you will be able to

• Install and work with ClickHouse

• Query the data using ClickHouse SQL

• Understand the internals of the MergeTree family of table engines and variants of this engine

• Know the different special engines and Integrations with external data sources

• Learn about Data replication and Sharding in ClickHouse

• Administer and manage a ClickHouse server

This course will provide you with solid practical Skills in ClickHouse and it can be used as learning material for the ClickHouse® certifications. The instructor is an experienced ClickHouse professional and has authored a book on ClickHouse and conducted multiple live training sessions in ClickHouse.

This course will be updated periodically and enroll now to get lifelong access to this course!

Course Update History

• 17-01-2025 -  Added new videos on ClickHouse Quick Start and Why ClickHouse is fast. Replaced the old videos for ClickHouse integration engines with new/updated ones. Added new video on S3 & S3 Queue engine

• 27-11-2024 - Removed the Optional Chapter on SQL functions

• 06-10-2024 - Cleaned up the old videos on Log table engine. Added a new video on choosing the MergeTree table engine.

• 02-10-2024 - Added a new video on ClickHouse on Kubernetes (using Altinity ClickHouse Operator). Updated the video lectures on the first chapter

• 01-07-2024 - Replaced the old video lectures on Special table engines. Added a new video for Dictionaries in ClickHouse. Combined the sections on Log engines and special table engines into a single section.

• 22-06-2024 - Replaced the video lectures on Data replication and Sharding with updated content

• 25-05-2024 - Added a separate section for RBAC. Updated the videos on RBAC and the section on ClickHouse Administration.

• 04-05-2024 - Replaced the old video lectures on the MergeTree engine family with the new ones

• 11-02-2024 -  Added a new section on ClickHouse SQL. Replaced the old videos for ClickHouse data types.

• 14-01-2024 - Added a brand new section on MergeTree table engine basics. Contains ~44 minutes of new course content with 11 Video lectures.

• 12-09-2023 - Brand new videos in Section 1 (Installation, CH in Docker, connecting to CH server, DBeaver, Loading a dataset, and conclusion)

• 03-08-2023 - New course promo video and a new video on Course intro and ClickHouse Intro (Section 1)

• 01-08-2023 - Added an assignment on ClickHouse MergeTree engines

• 16-07-2023 - Added an assignment on ClickHouse SQL functions

• 04-07-2023 - Added an assignment on ClickHouse SQL - Part 1

• 25-06-2023 - Split the MergeTree table engine video lecture into three parts

• 11-06-2023 -  Added quiz on Geo data types, map data type, and data skipping indexes

• 08-05-2023 - Added video lectures on Geo and Map data types. Added an exercise on designing a table.

Disclaimer: All trademarks, logos, and brand names are the property of their respective owners. All company, product, and service names used in this course are for identification purposes only. Use of these names, trademarks, and brands does not imply endorsement. Golden Clover Education and the instructors of this course are not affiliated with ClickHouse Inc.