Become a ClickHouse PRO with this course which covers all the important topics in ClickHouse
Course Description
Welcome to the ClickHouse course. 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 upcoming ClickHouse certifications. The instructor is an experience ClickHouse professional and has authored a book on ClickHouse and conducted multiple live training sessions in ClickHouse. Some of the highlights of this course are
- All lectures have been designed from the ground up to make the topics easy to understand
- Simple and easy to understand examples in each and every topic
- Precise and informative video lectures
- Every important topic has a questionnaire after the video lecture, to revise and test your understanding
- Covers a wide range of topics in ClickHouse starting from basic to advanced level
The course will be updated periodically and enroll now to get lifelong access to this course!
Course Contents
Course Introduction
Course Intro
Introduction to ClickHouse
Installing ClickHouse
ClickHouse in Docker
Connecting to a ClickHouse Server
DBeaver
Conclusion
ClickHouse SQL
Introduction
Operators
ClickHouse Data Types
Numeric
String
Date and DateTime
Arrays and Tuples
Nested
Enumerated and LowCardinality
Data Query Language
Data Definition Language
Data Manipulation Language
Joins and Unions
Views in ClickHouse
SQL Functions in ClickHouse
Introduction
Data Type Conversion
Date and DateTime Functions
String Functions
Array Functions
JSON Functions
Aggregate Functions
Combinators
User Defined Functions
Window Functions
MergeTree Table Engines
Introduction
Understanding the MergeTree Table Engine
ReplacingMergeTree
SummingMergeTree
AggregatingMergeTree
CollapsingMergeTree
VersionedCollapsingMergeTree
Data Skipping Index
Log Engines
Introduction
TinyLog
Log
StripeLog
Special Table Engines
Introduction
File Table Engine
Merge Table Engine
Set Table Engine
Memory Table Engine
Buffer Table Engine
GenerateRandom Table Engine
URL Table Engine
Multi-Node ClickHouse Setup
Data Replication
Sharding
ClickHouse Integrations
Introduction
MySQL
PostgreSQL
MongoDB
Apache Kafka
Configuring and Administering a ClickHouse Server
Introduction
Configuring the ClickHouse Server
Role Based Access Control
User Management
Roles
Settings Profile
Quotas
ClickHouse Backups
System Tables
clickhouse-copier
clickhouse-local
clickhouse-benchmark
Conclusion
Conclusion
Discount Coupon
Get 30% off using the following coupon
60AA9945936FE1199B52
Valid until 2023-05-18