🏠

ClickHouse Learning Roadmap

Column-oriented OLAP database for real-time analytics at scale.

Estimated time:3–5 weeks

1🌱

Phase 1 — Fundamentals

Column-oriented storage model

Table engines (MergeTree family)

Basic queries & data types

Partitioning & primary key design

2🏗️

Materialized views

ReplacingMergeTree / SummingMergeTree

TTL for data retention

Ingestion patterns (batch inserts)

3📈

Query profiling (EXPLAIN)

Sparse indexing internals

Distributed table engine

4🔐

important

Sharding & replication (ReplicatedMergeTree)

Cluster configuration (ZooKeeper/Keeper)

Monitoring & resource limits

Begin with interview questions to assess your current level.