Overview

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 areAll lectures have been designed from the ground up to make the complex topics easy to understand300+ SQL examples demonstrated in the video lecturesPrecise and informative video lectures200 + Quiz questions and countingAssignmentsCovers a wide range of topics in ClickHouse After completing this course, you will be able toInstall and work with ClickHouseQuery the data using ClickHouse SQLUnderstand the internals of the MergeTree family of table engines and variants of this engineKnow the different special engines and Integrations with external data sourcesLearn about Data replication and Sharding in ClickHouseAdminister and manage a ClickHouse serverThis 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 History17-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 engine27-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 chapter01-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 content25-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 ones11-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 engines16-07-2023 - Added an assignment on ClickHouse SQL functions04-07-2023 - Added an assignment on ClickHouse SQL - Part 125-06-2023 - Split the MergeTree table engine video lecture into three parts11-06-2023 - Added quiz on Geo data types, map data type, and data skipping indexes08-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.

Skills

Reviews