Build a Column Store
Build a columnar OLAP engine like ClickHouse/Parquet: row vs column layout, RLE/dictionary/bit-packing encodings, vectorized execution, predicate pushdown, hash + sort-merge joins, and the storage layer behind Snowflake, BigQuery, and modern data warehouses.
advanced10 lessons4 chapters10 graded exercisesPython
No sign-up needed for lesson 1 · certificate on completion · sign up to save progress
What you’ll have built
Chapter by chapter. Every step is a graded exercise.
- Why Columnar
- Encodings
- Vectorized Execution
- Production
Starts in Python — solve in the language you choose in the editor, same tests either way.
Curriculum
4 chapters, 10 lessons. Each lesson is a short read, one graded exercise, and a quiz.
- 1Row vs Column StorageRead · exercise · quiz
- 2Storage Files & LayoutRead · exercise · quiz
- 3Vectorized ExecutionRead · exercise · quiz
Loading reference solution…