LESSON 4
Lesson Plan
1
How ClickHouse Works
Glossary, OLTP and OLAP, columns on disk, engines, parts, partitions, merges, index · slides 3–11
2
MergeTree in the lab
Event Table and ORDER BY, Index in EXPLAIN, Batch Inserts, Duplicates, Changes and TTL, Materialized View, Re-insertion · 12–18
3
ClickHouse in the project
Data delivery, metrics, the boundary with PostgreSQL, decision table, cases, common mistakes · slides 19–24; summary and questions · 25–26