Real-Time Analytics with ClickHouse — From Zero to Production
30
People
2
Days
About Course
Day 1 — Foundations, Ingestion & Analytics
Goal: Participants understand ClickHouse fundamentals and can ingest, model, and analyze data effectively.
Foundations & Core Concepts
Foundations & Core Concepts
- Introduction to ClickHouse
- Real-Time Analytics Use Cases
- ClickHouse Architecture Deep Dive (Storage, MergeTree, Parts, Merges, etc.)
Ingestion, Modeling & Querying
- Ingesting Data into ClickHouse (Batch & Streaming)
- Data Modeling for Analytics in ClickHouse
- Analyzing Data with ClickHouse (SQL for Analytics)
- Joining & Enriching Data in ClickHouse
- Mutations: Updating & Deleting Data Safely
Performance & Optimization
- Query Acceleration Techniques (Views, Materialized Views, etc.)
Day 2 — Distributed Systems, Scaling & Production Ops
Goal: Participants learn how to deploy, scale, and operate ClickHouse in production.
Distributed Systems & Scaling
- Sharding and Replication in ClickHouse
Operations & Production Readiness
- Managing Data in ClickHouse
- Configuring ClickHouse
- Deploying ClickHouse Cluster
- Operating & Maintaining ClickHouse
Instructor
Kan Ouivirach
Data Product Developer and Technical Enabler
Who this course is for ?
This workshop is designed for professionals who work with data and analytics systems, including:
- Data Analysts - Who want faster queries, fresher data, and a better understanding of how modern analytical databases work.
- Data Engineers - Who build data pipelines and want to ingest, model, and optimize analytical data in ClickHouse.
- Data Platform Engineers - Who design and operate data infrastructure and need to deploy, scale, and tune ClickHouse clusters.
- Operations / SRE / DevOps Engineers - Who are responsible for running data systems in production and want to learn how to monitor, maintain, and troubleshoot ClickHouse.
