Getting Started With ClickHouse (2023 Edition)
4h 38m 56s
English
Paid
Course description
Learn ClickHouse, the fastest and the most powerful database that can handle Petabytes of data with ease! 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
- 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 a 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!
Watch Online
Watch Online Getting Started With ClickHouse (2023 Edition)
0:00
/ #1: Course Introduction
All Course Lessons (77)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Course Introduction Demo | 04:27 | |
| 2 | Introduction to ClickHouse | 04:37 | |
| 3 | Installing ClickHouse | 06:26 | |
| 4 | ClickHouse in a Docker environment | 03:12 | |
| 5 | Connecting to a ClickHouse Server | 03:41 | |
| 6 | DBeaver | 03:05 | |
| 7 | Loading an Example dataset (Optional) | 02:53 | |
| 8 | Conclusion | 01:03 | |
| 9 | Introduction | 02:40 | |
| 10 | Operators | 02:18 | |
| 11 | ClickHouse Data Types | 01:17 | |
| 12 | Numeric Data Types | 03:08 | |
| 13 | String Data Types | 02:42 | |
| 14 | Date and Datetime | 02:01 | |
| 15 | Arrays and Tuples | 02:17 | |
| 16 | Nested Data Type | 02:01 | |
| 17 | Data Types for Low Cardinal Data | 03:31 | |
| 18 | Geo Data Types | 03:00 | |
| 19 | Map Data Type | 02:19 | |
| 20 | Data Query Language | 03:07 | |
| 21 | Data Manipulation Language | 04:30 | |
| 22 | Data Definition Language - Part 1 | 03:10 | |
| 23 | Data Definition Language - Part 2 | 03:22 | |
| 24 | Joins and Unions | 05:17 | |
| 25 | Views in ClickHouse | 03:18 | |
| 26 | Exercise - Data Types | 04:41 | |
| 27 | Introduction | 01:38 | |
| 28 | Data Type Conversion | 03:51 | |
| 29 | Date and DateTime Functions | 06:51 | |
| 30 | String Functions | 09:10 | |
| 31 | Array Functions | 05:57 | |
| 32 | JSON Functions | 02:41 | |
| 33 | Aggregate Functions | 03:32 | |
| 34 | Combinators for Aggregate Functions | 03:30 | |
| 35 | User Defined Functions | 01:40 | |
| 36 | Window Functions | 04:38 | |
| 37 | Introduction | 01:04 | |
| 38 | MergeTree Engine - Introduction | 06:50 | |
| 39 | More on MergeTree Engine | 05:47 | |
| 40 | Operations on MergeTree Table Partitions | 06:56 | |
| 41 | ReplacingMergeTree | 05:57 | |
| 42 | SummingMergeTree | 04:06 | |
| 43 | AggregatingMergeTree | 09:12 | |
| 44 | CollapsingMergeTree | 09:19 | |
| 45 | VersionedCollapsingMergeTree | 03:38 | |
| 46 | Data Skipping Index | 11:12 | |
| 47 | Introduction | 00:56 | |
| 48 | TinyLog Table Engine | 02:07 | |
| 49 | Log Table Engine | 01:46 | |
| 50 | StripeLog Table Engine | 01:37 | |
| 51 | Introduction | 00:42 | |
| 52 | File Table Engine | 01:43 | |
| 53 | Merge Table Engine | 01:57 | |
| 54 | Set Table Engine | 01:31 | |
| 55 | Memory Table Engine | 01:48 | |
| 56 | Buffer Table Engine | 03:32 | |
| 57 | GenerateRandom Table Engine | 01:27 | |
| 58 | URL Table Engine | 02:13 | |
| 59 | Data Replication using ReplicatedMergeTree Engines | 07:07 | |
| 60 | Data Sharding with Distributed Table Engine | 06:18 | |
| 61 | Introduction | 00:45 | |
| 62 | MySQL | 02:32 | |
| 63 | PostgreSQL | 02:36 | |
| 64 | MongoDB | 02:17 | |
| 65 | Apache Kafka | 05:54 | |
| 66 | Configuring the ClickHouse Server | 02:08 | |
| 67 | Role Based Access Control | 01:18 | |
| 68 | User Management | 03:33 | |
| 69 | Roles | 03:00 | |
| 70 | Settings Profile | 03:00 | |
| 71 | Quotas | 02:24 | |
| 72 | ClickHouse Backups | 04:35 | |
| 73 | System Tables | 06:22 | |
| 74 | clickhouse-copier | 06:47 | |
| 75 | clickhouse-local | 01:30 | |
| 76 | clickhouse-benchmark | 02:02 | |
| 77 | Congratulations | 01:57 |
Unlock unlimited learning
Get instant access to all 76 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Database Mastery: SQL to Prisma
Sources: jsmastery.pro, Adrian Hajdin
Master key technologies with a practical approach! You will gain applied knowledge, clear explanations, and all the necessary tools to confidently master...
16 minutes 3 seconds
Build an app with ASPNET Core and Angular from scratch
Sources: udemy
Have you learnt the basics of ASP.NET Core and Angular? Not sure where to go next? This course should be able to help with that. In this course we start from nothing and incr...
29 hours 51 minutes 36 seconds
Fundamentals of Networking Engineering
Sources: udemy
We are entering an era in software engineering where we rely on libraries and frameworks to do most of our work. While this is useful and save tremendous dev ho
18 hours 6 minutes 23 seconds
Apache Kafka Series - Learn Apache Kafka for Beginners v3
Sources: udemy
Welcome to the Apache Kafka Series! Join a community of 20,000+ students learning Kafka. Apache Kafka has become the leading distributed data streaming enterprise big data tech...
8 hours 20 minutes 45 seconds
Full-Stack Fundamentals 3 - Auth
Sources: Mckay Wrigley (takeoff)
In the previous project, we created a working application - Prompt Manager, mastering the key principles of full-stack development using Next.js, Supabase...
1 hour 9 minutes 21 seconds