Powered by

A Comprehensive Developer Course on ClickHouse®

Learn how companies like Vercel or Canva query billions of rows in milliseconds. From fundamentals to production-ready skills.

EclipseCourse video preview

The Course

We've been offering large-scale ClickHouse-based solutions since 2019. And we've learned a lot along the way. That's why we're sharing over three hours of videos that explain how you can work with ClickHouse, from the basics to more advanced topics.

Module 1

Foundation

Chapter 01

Setup & Prerequisites

Reading materialsUp next
Setup & Prerequisites

Chapter 02

Understanding Columnar Databases

Reading materials
Understanding Columnar Databases

Chapter 03

Intro to ClickHouse Internals

Reading materials
Intro to ClickHouse Internals

Chapter 04

Your First ClickHouse Table

Video lesson Reading materials
Your First ClickHouse Table

Chapter 05

Schema Design Principles

Video lesson Reading materials
Schema Design Principles

Chapter 06

Schema Definition

Video lesson Reading materials
Schema Definition

Chapter 07

Data Types Rules

Video lesson Reading materials
Data Types Rules

Chapter 08

Numeric Types

Video lesson Reading materials
Numeric Types

Chapter 09

Strings

Video lesson Reading materials
Strings

Chapter 10

Date and Time

Video lesson Reading materials
Date and Time

Chapter 11

Enum

Reading materials
Enum

Chapter 12

IPv4, IPv6

Reading materials
IPv4, IPv6

Chapter 13

Boolean

Reading materials
Boolean

Chapter 14

Nullable Columns

Video lesson Reading materials
Nullable Columns

Chapter 15

Special Data Types

Reading materials
Special Data Types

Chapter 16

Codecs

Video lesson Reading materials
Codecs

Chapter 17

Why Data Locality is Important

Video lesson Reading materials
Why Data Locality is Important

Chapter 18

Why Schema Evolution is Hard

Video lesson Reading materials
Why Schema Evolution is Hard

Chapter 19

Intro to Engines

Video lesson Reading materials
Intro to Engines

Chapter 20

Engine Families

Video lesson Reading materials
Engine Families

Chapter 21

MergeTree

Video lesson Reading materials
MergeTree

Chapter 22

ReplacingMergeTree

Video lesson Reading materials
ReplacingMergeTree

Chapter 23

AggregatingMergeTree

Video lesson Reading materials
AggregatingMergeTree

Chapter 24

SummingMergeTree

Reading materials
SummingMergeTree

Chapter 25

SummingMergeTree vs AggregatingMergeTree

Video lesson Reading materials
SummingMergeTree vs AggregatingMergeTree

Chapter 26

Engine Settings

Video lesson Reading materials
Engine Settings

Chapter 27

ClickHouse Engines Cheat Sheet

Reading materials
ClickHouse Engines Cheat Sheet

Module 2

Ingestion

Chapter 28

Intro to ingestion

Video lesson Reading materials
Intro to ingestion

Chapter 29

Scaling Ingestion Problems

Video lesson Reading materials
Scaling Ingestion Problems

Chapter 30

The ingestion proxy pattern

Video lesson Reading materials
The ingestion proxy pattern

Chapter 31

Types of Ingestion

Video lesson Reading materials
Types of Ingestion

Chapter 32

HTTP Streaming

Video lesson Reading materials
HTTP Streaming

Chapter 33

Kafka Streaming

Video lesson Reading materials
Kafka Streaming

Chapter 34

Cloud Storage

Video lesson Reading materials
Cloud Storage

Chapter 35

Backfilling

Video lesson Reading materials
Backfilling

Chapter 36

Snapshots

Reading materials
Snapshots

Chapter 37

APPEND vs REPLACE Mode

Reading materials
APPEND vs REPLACE Mode

Chapter 38

What's a Materialized View

Video lesson Reading materials
What's a Materialized View

Chapter 39

Your First Materialized View

Video lesson Reading materials
Your First Materialized View

Chapter 40

How Matviews Work

Video lesson Reading materials
How Matviews Work

Chapter 41

When to Use Matviews

Video lesson Reading materials
When to Use Matviews

Chapter 42

Optimizing a Project with Materialized Views

Video lesson Reading materials
Optimizing a Project with Materialized Views

Chapter 43

Projections vs Matviews

Video lesson Reading materials
Projections vs Matviews

Chapter 44

Matviews Expert Advice

Video lesson Reading materials
Matviews Expert Advice

Chapter 45

Guide for Query Optimization

Reading materials
Guide for Query Optimization

Chapter 46

Sorting Key and Index Granularity

Reading materials
Sorting Key and Index Granularity

Chapter 47

EXPLAIN

Reading materials
EXPLAIN

Chapter 48

Data Skipping Indices

Reading materials
Data Skipping Indices

Chapter 49

Denormalizing Data

Reading materials
Denormalizing Data

Chapter 50

PREWHERE

Reading materials
PREWHERE

Chapter 51

Optimize JOINs: When and Algorithms

Reading materials
Optimize JOINs: When and Algorithms

Chapter 52

Dictionaries

Reading materials
Dictionaries

Chapter 53

Why Schema Evolution is Hard

Video lesson Reading materials
Why Schema Evolution is Hard

Chapter 54

Schema Evolution Primitives

Video lesson Reading materials
Schema Evolution Primitives

Chapter 55

Schema Change Costs

Video lesson Reading materials
Schema Change Costs

Chapter 56

Migration Patterns

Video lesson Reading materials
Migration Patterns

Chapter 57

Developer Expectations

Video lesson Reading materials
Developer Expectations

Chapter 58

Multi-Tenant Migration Example

Video lesson Reading materials
Multi-Tenant Migration Example

Chapter 59

Intro to ClickHouse Clusters

Video lesson Reading materials
Intro to ClickHouse Clusters

Chapter 60

Parts, Partitions, Merges, and Indexes

Video lesson Reading materials
Parts, Partitions, Merges, and Indexes

Chapter 61

Scaling Strategies

Video lesson Reading materials
Scaling Strategies

Chapter 62

Scaling Reads

Video lesson Reading materials
Scaling Reads

Chapter 63

Scaling Ingestion

Video lesson Reading materials
Scaling Ingestion

Chapter 64

Operational Challenges

Video lesson Reading materials
Operational Challenges

Chapter 65

Web Analytics

Reading materials
Web Analytics

Chapter 66

Log Analytics

Reading materials
Log Analytics

Chapter 67

Build Your Own

Reading materials
Build Your Own

Chapter 68

Follow Along

Reading materials
Follow Along

FAQs

Who is this course for?

This course is for engineers and data practitioners who want a curated, opinionated learning experience that takes them from initial concepts to production use. The material is organized into a clear, logical progression, with simple, practical examples and real-world context drawn from operating ClickHouse at petabyte scale. Our course focuses on guided learning, helping you understand not just what to do, but why and how it fits together in practice.

How the course is structured?

The course is structured into 6 modules, each covering a different aspect of ClickHouse.

You start learning the foundation module, which covers the essential knowledge you need to understand ClickHouse's architecture, design efficient schemas, and work with different storage engines. This is essential for any developer working with ClickHouse.

Starting from the ingestion module, you'll learn the importance of managed services and we start introducing Tinybird, which helps on some of the more complex parts like ingestion pipelines, schema management, and API generation.

Module 3 and 4 cover querying, optimization and schema evolution. These modules introduce fundamental features from Tinybird that make developers more productive and efficient. You'll not only master ClickHouse but also learn how to use Tinybird to build production-ready data products.

The end to end use case module covers a set of real-world use cases of using ClickHouse to build a data product, including the different components of the data product, and how to build it with Tinybird. These are not toy projects but real production-ready projects we've built with Tinybird.

Do I need Tinybird for the course?

No, you don't need Tinybird to follow along. We use Tinybird in examples because it helps on some of the more complex parts (like schema management, ingestion pipelines, and API generation), also because we built it and it's a great way to create data products with ClickHouse.

The fundamental concepts you'll learn are universal and apply to any ClickHouse deployment. Whether you're using OSS ClickHouse directly, through Tinybird, or any other platform, the core principles remain the same.

How long does it take to complete the course?

The course is designed to be completed in a few hours, but you can learn at your own pace. Total video content duration is about ~3 hours.

With 40+ video tutorials and 70+ lessons across 6 modules, you can go from zero to production-ready in a single focused session, or spread it out over several days. Each lesson is concise and focused, so you can easily pick up where you left off.

Is this course really free?

Yes, the course is completely free. To share what we've learned over the last 5+ years running Petabyte size clusters, we built this free course on ClickHouse; designed for developers who want to master the basics and build faster, smarter data products.

There are no hidden costs, no credit card required, and no upsells. Our goal is to help the developers community learn ClickHouse, whether you end up using Tinybird or not. We make our living selling tools, not courses.

To start the course, you have to provide your email address and you'll be subscribed to our bi-weekly newsletter. We'll send you updates about the course, new content, and other resources. You can unsubscribe at any time.

What do I need to get started?

No previous knowledge is required. You don't need to install anything or set up a database; you can follow along with the examples using any ClickHouse instance, including Tinybird's free tier if you want to try the examples hands-on. Basic familiarity with SQL is helpful but not required, as we explain concepts from the ground up.

What's the difference between ClickHouse and ClickHouse Inc.?

ClickHouse is an open-source analytical database technology that can be used, modified, and deployed under its applicable open-source license.

ClickHouse, Inc. is the company founded by the original creators of ClickHouse and offers commercial products and services related to the technology.

Tinybird's course focuses on ClickHouse, the open-source technology. It teaches how to work with ClickHouse as a database system, independent of any specific commercial offering. Many companies, including Tinybird, use ClickHouse in production.

Tinybird is not affiliated with, associated with, or sponsored by ClickHouse, Inc. ClickHouse® is a registered trademark of ClickHouse, Inc.

Background Image

About Tinybird

Tinybird is a real-time data platform that makes ClickHouse easy for developers who want to ship data products faster

After 7 years and thousands of petabytes ingested, we've learned what makes ClickHouse work in production and what breaks. This course shares all of it.

Start working with ClickHouse for free

Ready to Master ClickHouse?

Start learning today and build production-ready ClickHouse applications

Tinybird is not affiliated with, associated with, or sponsored by ClickHouse, Inc. ClickHouse® is a registered trademark of ClickHouse, Inc.