ClickHouse - The Complete Guide (2023 Edition)

Focused View

Vijay Anand Ramakrishnan

4:19:03

413 View

1. Introduction

1.1 code files.zip

1. Prelude.html

2. Course Introduction.mp4

03:14

3. Introduction to ClickHouse.mp4

03:33

4. Installing ClickHouse.mp4

03:41

5. ClickHouse in a Docker environment.mp4

02:56

6. Connecting to a ClickHouse Server.mp4

03:37

7. DBeaver.mp4

03:27

8. Conclusion.mp4

00:20

9. Introduction to ClickHouse.html

2. ClickHouse SQL

1. ClickHouse SQL - Introduction.html

2. Introduction.mp4

02:39

3. ClickHouse SQL.html

4. Operators.mp4

02:17

5. ClickHouse Operators.html

6. ClickHouse Data Types.mp4

01:16

7. Numeric Data Types.mp4

03:06

8. Numeric Data types.html

9. String Data Types.mp4

02:40

10. String Data types.html

11. Date and Datetime.mp4

02:00

12. DateDateTime.html

13. Arrays and Tuples.mp4

02:15

14. Arrays and Tuples.html

15. Nested Data Type.mp4

02:00

16. Nested Data Type.html

17. Data Types for Low Cardinal Data.mp4

03:30

18. Enumerated and LowCardinality data types.html

19. Data Query Language.mp4

03:06

20. DQL.html

21. Data Manipulation Language.mp4

04:29

22. DML.html

23. Data Definition Language - Part 1.mp4

03:09

24. Data Definition Language - Part 2.mp4

03:21

25. DDL.html

26. Joins and Unions.mp4

05:16

27. Joins and Unions.html

28. Views in ClickHouse.mp4

03:17

29. ClickHouse Views.html

3. SQL Functions in ClickHouse

1. ClickHouse SQL Functions - Introduction.html

2. Introduction.mp4

01:37

3. ClickHouse SQL Functions.html

4. Data Type Conversion.mp4

03:49

5. Data type conversion.html

6. Date and DateTime Functions.mp4

06:50

7. Date and DateTime functions.html

8. String Functions.mp4

09:09

9. String Functions.html

10. Array Functions.mp4

05:56

11. Array Functions.html

12. JSON Functions.mp4

02:40

13. JSON Functions.html

14. Aggregate Functions.mp4

03:31

15. Aggregate Functions.html

16. Combinators for Aggregate Functions.mp4

03:29

17. Combinators.html

18. User Defined Functions.mp4

01:39

19. User Defined Functions.html

20. Window Functions.mp4

04:36

21. Window Functions.html

4. MergeTree Table Engines

1. MergeTree Family of Table Engines.html

2. Introduction.mp4

01:03

3. Understanding the MergeTree Table Engine.mp4

19:27

4. MergeTree Engine.html

5. ReplacingMergeTree.mp4

05:56

6. ReplacingMergeTree Engine.html

7. SummingMergeTree.mp4

04:05

8. SummingMergeTree.html

9. AggregatingMergeTree.mp4

09:11

10. AggregatingMergeTree.html

11. CollapsingMergeTree.mp4

09:18

12. CollapsingMergeTree.html

13. VersionedCollapsingMergeTree.mp4

03:37

14. VersionedCollapsingMergeTree.html

15. Data Skipping Index.mp4

11:11

5. Log Engines

1. Log Family Table Engines.html

2. Introduction.mp4

00:54

3. Log Family.html

4. TinyLog Table Engine.mp4

02:06

5. TinyLog Engine.html

6. Log Table Engine.mp4

01:45

7. Log Engine.html

8. StripeLog Table Engine.mp4

01:36

9. StripeLog Engine.html

6. Special Table Engines

1. Special Table Engines in ClickHouse.html

2. Introduction.mp4

00:41

3. File Table Engine.mp4

01:42

4. File Engine.html

5. Merge Table Engine.mp4

01:56

6. Merge Table Engine.html

7. Set Table Engine.mp4

01:30

8. Set Engine.html

9. Memory Table Engine.mp4

01:47

10. Memory Engine.html

11. Buffer Table Engine.mp4

03:31

12. Buffer Engine.html

13. GenerateRandom Table Engine.mp4

01:26

14. GenerateRandom Engine.html

15. URL Table Engine.mp4

02:12

16. URL Engine.html

7. Multi-node ClickHouse setup

1. Multi-node ClickHouse Setup.html

2. Data Replication using ReplicatedMergeTree Engines.mp4

07:06

3. Data Replication in ClickHouse.html

4. Data Sharding with Distributed Table Engine.mp4

06:17

5. Sharding.html

8. ClickHouse Integrations

1. External Data sources.html

2. Introduction.mp4

00:44

3. MySQL.mp4

02:31

4. Integrating with MySQL.html

5. PostgreSQL.mp4

02:34

6. PostgreSQL table engine.html

7. MongoDB.mp4

02:16

8. MongoDB table engine.html

9. Apache Kafka.mp4

05:52

10. Apache Kafka table engine.html

9. Configuring and Administering a ClickHouse Server

1. Configuring and Administering a ClickHouse server.html

2. Configuring the ClickHouse Server.mp4

02:07

3. Role Based Access Control.mp4

01:17

4. User Management.mp4

03:32

5. ClickHouse User Management.html

6. Roles.mp4

02:59

7. ClickHouse User Roles.html

8. Settings Profile.mp4

02:59

9. ClickHouse Settings Profile.html

10. Quotas.mp4

02:23

11. ClickHouse Quotas.html

12. ClickHouse Backups.mp4

04:34

13. Backups in ClickHouse.html

14. System Tables.mp4

06:21

15. System tables.html

16. clickhouse-copier.mp4

06:46

17. clickhouse-copier.html

18. clickhouse-local.mp4

01:29

19. clickhouse-local.html

20. clickhouse-benchmark.mp4

02:01

21. clickhouse-benchmark.html

10. Conclusion

1. Congratulations.mp4

01:56

Description

Master the MergeTree table engines, ClickHouse SQL, Sharding & replication, ClickHouse Database Administration & more!!

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

Who is this for?

Database Administrators

Developers curious to know about ClickHouse

Data analysts and Data scientists planning to work with ClickHouse

Anyone who wants to learn ClickHouse

What You Need to Know?

Basic Linux commands

Fundamentals of SQL

Fundamentals of Docker

More details

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 MergeTree family of table engines and variants of this engine
Know the different special engines and Integrations with external data sources
Learn about the Data replication and Sharding in ClickHouse
Administer and manage a ClickHouse server
This course will provide you with a 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!

Course Update History
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.
Who this course is for:
Database Administrators
Developers curious to know about ClickHouse
Data analysts and Data scientists planning to work with ClickHouse
Anyone who wants to learn ClickHouse

User Reviews

Rating

average 0

Total votes0

Focused display

My name is Vijay Anand and I am working as a database consultant. I have been into multiple roles in the Software industry for the past 11+ years. I have authored a book on ClickHouse titled "Up and Running With ClickHouse".I am into creating online courses on new and promising Database systems in my spare time. I enjoy solving interesting problems with software and I am an Open-Source enthusiast.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.