*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