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

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 77 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing

Watch Online Getting Started With ClickHouse (2023 Edition)

0:00
/
#1: Course Introduction

All Course Lessons (77)

#Lesson TitleDurationAccess
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 subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Fundamentals of Networking Engineering

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
Complete ASP.NET MVC 5

Complete ASP.NET MVC 5

Sources: udemy
With over 40,000 happy students and 12,000+ positive reviews, this course is Udemy's most popular course for learning ASP.NET MVC! ASP.NET MVC is a server-side
7 hours 33 minutes 52 seconds
Fundamentals of Backend Communications and Protocols

Fundamentals of Backend Communications and Protocols

Sources: udemy
Backend engineering is an art. During my 18 years career working with and building backend applications, I discovered that certain communication design patterns keep emerging. T...
15 hours 35 minutes 37 seconds
Database Design Book

Database Design Book

Sources: Alexey Makhotkin
The goal of this book is to help you progress from a vague idea of a task (for example: "I need to create a website for managing schedules and records...
PostgreSQL High Performance Tuning Guide

PostgreSQL High Performance Tuning Guide

Sources: udemy
PostgreSQL is one of the most powerful and convenient database management systems. It is actively supported by the community and receives new releases every...
2 hours 41 minutes 14 seconds