$499

ClickHouse Foundation

Course
46 Lessons

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.

Buy now

Brochure - ClickHouse Mastery Program

ClickHouse Mastery Bundle_DurgaAnalytics.pdf

Preview

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