Free course

ClickHouse Course

Learn ClickHouse for analytical workloads: columnar storage, MergeTree design, ordering keys, batch ingestion, materialized views, operations, and recovery.

5 modules · 20 lessons · No signup

Prerequisites: SQL, Shell Commands and Docker

~~~

Your progress

of lessons completed.

Course completed.

What you'll learn

Design, load, query, secure, monitor, and recover a ClickHouse event pipeline using measured analytical access patterns.

Take this course offline

Subscribe to my newsletter to get every free book and course in PDF and EPUB format.

Get the downloads

Course contents

  1. Analytical foundations

    OLAP workloads, columnar execution, local setup, Cloud, clients, SQL, and data types.

    1. ✓ Choose an analytical database
    2. ✓ Run ClickHouse locally
    3. ✓ Understand columnar storage
    4. ✓ Check your understanding: analytical foundations

  2. Schema and MergeTree

    Types, MergeTree parts, ORDER BY, primary indexes, partitions, skipping, and denormalized models.

    1. ✓ Create a MergeTree table
    2. ✓ Choose the ordering key
    3. ✓ Partition and model deliberately
    4. ✓ Check your understanding: schema and mergetree

  3. Ingestion and data flow

    Batch inserts, asynchronous inserts, retries, deduplication, imports, and event-pipeline design.

    1. ✓ Insert in batches
    2. ✓ Use asynchronous inserts carefully
    3. ✓ Design an idempotent event pipeline
    4. ✓ Check your understanding: ingestion and data flow

  4. Queries and acceleration

    Aggregations, query plans, system tables, projections, materialized views, and measured optimization.

    1. ✓ Write analytical queries
    2. ✓ Inspect query work
    3. ✓ Add a materialized view
    4. ✓ Check your understanding: queries and acceleration

  5. Security and operations

    Users, network controls, parts, merges, retention, replication, backups, monitoring, and recovery.

    1. ✓ Secure ClickHouse access
    2. ✓ Operate parts, retention, and replication
    3. ✓ Back up, monitor, and restore
    4. ✓ Check your understanding: security and operations