CF

Getting Started With ClickHouse (2023 Edition)

4h 38m 56s
English
Paid

Getting Started With ClickHouse (2023 Edition) is a 77-lesson 4 hours 38 minutes self-paced course by Udemy. Learn ClickHouse, the fastest and the most powerful database that can handle Petabytes of data with ease!

Course facts

Lessons
77
Duration
4 hours 38 minutes
Level
All levels
Language
English
Updated
Instructor
Udemy
Price
Premium

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!

Who teaches Getting Started With ClickHouse (2023 Edition)? Udemy

Udemy thumbnail

Udemy is the largest open marketplace for online courses on the internet. Founded in 2010 by Eren Bali, Oktay Caglar, and Gagan Biyani and headquartered in San Francisco, the company went public on the Nasdaq in 2021 under the ticker UDMY. The platform hosts well over two hundred thousand courses across software development, IT and cloud, data science, design, business, marketing, and creative skills, taught by tens of thousands of independent instructors. Roughly seventy million learners use it worldwide, and the corporate arm — Udemy Business — supplies a curated subset of that catalog to enterprise customers.

Because Udemy is a marketplace rather than a single editorial publisher, the catalog is uneven by design. The strongest material lives in the long-form, project-based courses authored by working engineers — full-stack JavaScript, React, Node.js, Python data science, AWS, Docker and Kubernetes, mobile development with Flutter and React Native, and cloud certification preparation. The CourseFlix listing under this source is the slice of that catalog that has been mirrored here for offline-friendly viewing, organized by topic and updated as new releases land. Pricing on Udemy itself swings dramatically with the site's near-permanent sales, which is why the platform is best treated as a deep reference catalog: pick instructors with strong reviews and a track record of updating their material rather than buying on the headline price alone.

What lessons are included in Getting Started With ClickHouse (2023 Edition)?

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
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

What courses are similar to Getting Started With ClickHouse (2023 Edition)?

Frequently asked questions

What are the prerequisites for this course?
This course does not list any formal prerequisites, but familiarity with database concepts and basic SQL knowledge would be beneficial. The course covers the installation of ClickHouse and SQL examples, aiding those who have a foundational understanding of databases and SQL.
What kind of projects or exercises will I work on during the course?
The course includes various exercises, such as working with data types, and practicing SQL queries using over 300 examples. You will gain hands-on experience with tasks like installing ClickHouse, using MergeTree table engines, and understanding data replication and sharding.
Is this course suitable for beginners in database management?
While the course is designed to make complex topics easy to understand, it is more suited for those who already have some basic knowledge of databases and SQL. Beginners might need additional resources to comprehend some advanced topics like MergeTree internals and data sharding.
How does the scope of this course compare to other database courses?
This course focuses specifically on ClickHouse, an open-source columnar data store, and covers topics such as data replication, sharding, and the internals of MergeTree engines. It provides practical skills through SQL examples and quizzes, which might not be as extensively covered in general database courses.
What specific tools and platforms are taught in this course?
The course covers installing ClickHouse, using it in a Docker environment, and connecting to a ClickHouse server. Additionally, it includes working with tools like DBeaver for interacting with ClickHouse databases.
What topics are not covered in this course?
The course does not cover ClickHouse's integration with cloud services or elaborate on advanced security configurations. Its focus remains on installation, basic to intermediate ClickHouse SQL, table engines, and data management concepts like replication and sharding.
How can the skills gained in this course benefit my career?
The skills acquired, such as working with ClickHouse SQL, understanding table engines, and managing data replication and sharding, are valuable for roles in data engineering and database administration. These skills are also useful for preparing for upcoming ClickHouse certifications, enhancing career opportunities in data management.