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

Download this course as PDF or EPUB

Read it offline, on your Kindle, or print it. Join my free newsletter and you get this course plus every other book and course I published.

Download PDFDownload EPUB
~~~

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.

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