What you'll learn:
- Installing and connecting to a ClickHouse server
- ClickHouse SQL & SQL Functions
- Table Engines and indexing in ClickHouse
- Data Replication and Sharding in ClickHouse
- ClickHouse Database Administration (Basics)
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
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.
