ClickHouse Foundation
- Buy now
- Learn more
- Discussions
Brochure - ClickHouse Mastery Program

ClickHouse Mastery Bundle_DurgaAnalytics.pdf
ClickHouse Mastery Bundle - Detailed_DurgaAnalytics.pdf
Module 1 — ClickHouse Fundamentals (Chapters 1–20)

Module 1 — ClickHouse Fundamentals.pdf
01_CLICKHOUSE-FUNDAMENTALS.mp4
1 Introduction to ClickHouse.m4a
2 OLTP vs OLAP systems.m4a
3 Columnar databases explained.m4a
4 ClickHouse architecture overview.m4a
5 Installing ClickHouse.m4a
6 ClickHouse server and client tools.m4a
7 ClickHouse data types.m4a
8 Creating databases and tables.m4a
9 Column storage fundamentals.m4a
10 Basic SQL queries.m4a
11 Filtering and sorting data.m4a
12 Aggregation basics.m4a
13 Query execution basics.m4a
14 Compression fundamentals.m4a
15 Partitioning concepts.m4a
16 Query performance basics.m4a
17 ClickHouse system tables.m4a
18 Understanding data parts.m4a
19 First analytics workload.m4a
20 Fundamentals review.m4a
Module 2 — ClickHouse Architecture (Chapters 21–40)

Module 2 — ClickHouse Architecture.pdf
02_CLICKHOUSE-ARCHITECTURE.mp4
21 Storage architecture.m4a
22 MergeTree engine overview.m4a
23 Data parts and merges.m4a
24 Primary key vs sorting key.m4a
25 Partition key design.m4a
26 Background merge processes.m4a
27 Compression algorithms.m4a
28 Data skipping indexes.m4a
29 Query execution pipeline.m4a
30 Parallel query processing.m4a
31 Query memory management.m4a
32 Disk IO optimization.m4a
33 Storage internals.m4a
34 Replication architecture overview.m4a
35 Distributed query execution.m4a
36 Cluster topology basics.m4a
37 Network considerations.m4a
38 Query planner basics.m4a
39 Architecture optimization.m4a
40 Architecture best practices.m4a

ClickHouse Foundation

Master ClickHouse for ultra-fast OLAP, real-time analytics, and distributed data warehousing. Learn from basics to cluster administration and advanced query optimization with 350+ lessons and labs.