ClickHouse Academy

Become a ClickHouse expert with our free official ClickHouse training

Popular free courses

Learn the basics of ClickHouse with our online courses.

Get up and running quickly with ClickHouse! In this course, you will learn how to create a new service, an understanding of how primary keys work in ClickHouse, how to define a table, how to insert data, and how to run queries on your tables.

Data ingestion

20 minutes

In this course, you will learn techniques for getting data into your ClickHouse service, including how to insert a CSV/TSV file, how to insert data from another database, and how to use the various table functions and table engines for ingesting data.

Materialized views

25 minutes

Creating views is an important step in optimizing your OLAP applications. In this course, you will learn how to define materialized views, including views that use the SummingMergeTree and AggregatingMergeTree table engines.

Learning paths

Become a subject matter expert through our recommended series of courses that will best help you build knowledge progressively.

ClickHouse Developer Learning Path

2 hours

Become a ClickHouse Developer expert, from getting started to a deep dive into the architecture of ClickHouse to advanced topics like deduplication, materialized views, and projections.

ClickHouse Cloud Onboarding

1.5 hours

Start your journey to becoming a ClickHouse Cloud expert by learning how to get started in the Cloud, the architecture of ClickHouse, how to create tables, and how to ingest data.

Professional certification

Let the world know you’re a ClickHouse subject matter expect! We’re working on building the first official ClickHouse certification program, and we will share the news on social media when the exams are ready for beta testers.

Upcoming live events

Join our community and attend our events to learn more about ClickHouse! Our team is always happy to support and answer any questions you may have about ClickHouse development. You can alsoaccess our list of older events hosted by us.