Foundations Docker & Setup SQL Basics MergeTree Engine ORDER BY & Primary Keys

Foundations

Foundations

Get it running, write your first queries, and understand how a MergeTree table stores what you write.

Get it running, write your first queries, and understand how a MergeTree table stores what you write.

Sections

2.1
Docker & SetupRunning ClickHouse locally
2.2
SQL BasicsCREATE, INSERT, SELECT — the ClickHouse dialect
2.3
MergeTree EngineThe columnar storage engine
2.4
ORDER BY & Primary KeysThe sparse index

Why ClickHouse

OLAP vs OLTP, history, when not to use it

Docker & Setup

Running ClickHouse locally