10 Basic SQL queries.m4a

10 Basic SQL queries.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