24 Primary key vs sorting key.m4a

24 Primary key vs sorting key.m4a

Preview unavailable

You must log in or sign up to view this lesson.

LoginSign up

ClickHouse Foundation

Buy nowLearn more

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