Catalogue
/
Databases
/
ClickHouse for High-Performance Real-Time Analytics

ClickHouse for High-Performance Real-Time Analytics

A practical three day technical course for participants who are new to ClickHouse and want to build high-performance analytical data systems. The agenda progresses from ClickHouse architecture, SQL, and analytical data modelling through ingestion, MergeTree table engines, materialised views, query optimisation, and operational management. The course focuses on the architectural decisions that have the greatest impact on ingestion throughput, query performance, reliability, and maintainability.

What will you learn?

You will learn how ClickHouse stores and processes analytical data, how to design tables around expected query patterns, and how to ingest large volumes of batch and streaming data efficiently. You will work with MergeTree engines, partitions, sorting keys, materialised views, query analysis, and performance optimisation. You will also learn how to monitor, secure, troubleshoot, and operate ClickHouse environments for production analytics workloads.

  • Design ClickHouse tables and data models for analytical workloads
  • Implement efficient batch, incremental, and streaming ingestion patterns
  • Use MergeTree engines, materialised views, and ClickHouse SQL effectively
  • Analyse and optimise query performance and operate ClickHouse reliably

Requirements:

  • Technical background in software development, data engineering, analytics, databases, or a related field
  • Basic SQL knowledge
  • General understanding of databases and data processing concepts
  • Previous ClickHouse experience is not required

Course Outline*:

*We customize the course outline and content to your specific needs and relevant use cases.

Module 1: ClickHouse architecture and analytical database fundamentals

  • Understanding columnar storage and why it suits analytical workloads
  • Exploring query processing, storage, compression, parallel execution, and background processing
  • Comparing ClickHouse with transactional databases and traditional analytical platforms
  • Understanding databases, tables, parts, granules, and core ClickHouse objects

Module 2: Working with ClickHouse SQL and data types

  • Creating databases, tables, views, and common analytical queries
  • Working with numeric, string, date, array, tuple, map, and low-cardinality data types
  • Using filtering, aggregation, joins, window functions, and analytical expressions
  • Selecting data types that support efficient storage and query processing

Module 3: Analytical data modelling in ClickHouse

  • Designing tables around expected filtering, aggregation, and access patterns
  • Understanding denormalisation and when runtime joins remain appropriate
  • Working with dimensions, reference data, and dictionaries
  • Separating raw event data from transformed and consumption-oriented structures

Module 4: MergeTree storage and table design

  • Understanding MergeTree parts, background merges, sparse indexes, and granules
  • Designing ORDER BY and primary keys around common query patterns
  • Using PARTITION BY for appropriate lifecycle and data management scenarios
  • Understanding how sorting, partitioning, and storage layout affect query performance

Module 5: Batch and high-throughput data ingestion

  • Inserting data through SQL, files, HTTP interfaces, and application clients
  • Understanding why appropriately sized batches are important for ClickHouse
  • Using asynchronous inserts for frequent small write workloads
  • Monitoring ingestion and avoiding excessive creation of small data parts

Module 6: Streaming and continuous ingestion

  • Understanding common real-time ingestion architectures
  • Integrating ClickHouse with Kafka and related streaming platforms
  • Introducing ClickPipes and managed ingestion options in ClickHouse Cloud
  • Selecting ingestion approaches based on throughput, latency, reliability, and operational requirements

Module 7: MergeTree engine variants

  • Understanding the role of the MergeTree engine family
  • Using ReplacingMergeTree for deduplication and latest-state patterns
  • Using SummingMergeTree and AggregatingMergeTree for aggregation-oriented workloads
  • Selecting table engines based on update behaviour, query patterns, and data semantics

Module 8: Materialised views and transformation pipelines

  • Understanding incremental materialised views and insert-time transformations
  • Creating pre-aggregated and transformed target tables
  • Using materialised views to move processing from query time to ingestion time
  • Designing simple transformation pipelines without creating unnecessary write amplification or complexity

Module 9: Query execution and performance analysis

  • Understanding ClickHouse query execution and parallel processing
  • Using EXPLAIN to inspect query plans, indexes, and execution pipelines
  • Analysing read rows, selected granules, memory usage, and execution time
  • Using system.query_log to identify expensive and frequently executed query patterns

Module 10: Query and table optimisation

  • Improving data skipping through appropriate ORDER BY and primary key design
  • Optimising data types, filtering, joins, and aggregation patterns
  • Understanding projections, data skipping indexes, and pre-aggregation options
  • Applying optimisation iteratively by measuring changes rather than tuning blindly

Module 11: Monitoring, security, and troubleshooting

  • Using system tables to inspect queries, parts, merges, metrics, events, and server state
  • Understanding users, roles, privileges, and access control
  • Investigating memory pressure, slow queries, failed inserts, and merge-related issues
  • Monitoring storage growth, resource utilisation, and common operational bottlenecks

Module 12: Production operation and reliability

  • Understanding replication, sharding, and distributed ClickHouse concepts
  • Planning backups, retention, TTL rules, and recovery procedures
  • Managing configuration, limits, workload settings, and environment-specific requirements
  • Building a practical production readiness checklist covering performance, security, monitoring, resilience, and maintainability

Hands-on learning with expert instructors at your location for organizations.

4,347€*
Graph Icon - Education X Webflow Template
Level:
intermediate
Clock Icon - Education X Webflow Template
Duration:
21
Hours (days:
3
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Immersive hands-on experience in a dedicated setting
*Price can range depending on number of participants, change of outline, location etc.

Master new skills guided by experienced instructors from anywhere.

3,012€*
Graph Icon - Education X Webflow Template
Level:
intermediate
Clock Icon - Education X Webflow Template
Duration:
21
Hours (days:
3
)
Camera Icon - Education X Webflow Template
Training customized to your needs
Star Icon - Education X Webflow Template
Reduced training costs
*Price can range depending on number of participants, change of outline, location etc.

Upcoming Sessions

12-14 Jan 2027
Paris
11-13 Feb 2027
Paris
24-26 Feb 2027
Milan
20-22 Apr 2027
Lisbon
27-29 Apr 2027
Munich
5-7 May 2027
Dublin
17-19 Jun 2027
Dublin

Can't find a suitable date? Get in touch and we'll arrange one that works for you.

We use cookies to improve site navigation, analyse how the site is used, and support our marketing. You can accept all cookies, reject non-essential ones, or choose individual categories. Read our Cookie Notice