Getting Started With ClickHouse (2023 Edition)

Name: Getting Started With ClickHouse (2023 Edition)
Price: 9 USD
Availability: InStock

4h 38m 56s

English

Paid

November 5, 2024

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 Getting Started With ClickHouse (2023 Edition)

Join premium to watch

Go to premium

#	Title	Duration
1	Course Introduction	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