Learn Clickhouse® - A Fast Open-Source Olap Dbms

Learn ClickHouse® SQL, MergeTree and other table engines, Data replication, Sharding, and basic DBA tasks in ClickHouse®

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)

Requirements
Basic Linux commands
Fundamentals of SQL
Fundamentals of Docker and Docker Compose

Description
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 upcoming 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 History01-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.

Who this course is for:
Database Administrators,Data Engineers,Data analysts and Data scientists planning to work with ClickHouse,Anyone who wants to learn ClickHouse,Developers curious to know about ClickHouse