ClickHouse Fundamentals Training in Kuala Lumpur, Malaysia

This course introduces ClickHouse, a high-performance, columnar, open-source database designed for real-time analytics. Participants will learn its architecture, installation, core SQL usage, data modeling, performance tuning, and integration with BI/ETL tools. The course is hands-on, with labs to help participants build and query datasets efficiently using ClickHouse.

Introduction & Basics

• Introduction to ClickHouse

  • Key features, advantages, and use cases

  • Columnar storage vs row-based storage

• Architecture Overview

  • Nodes, clusters, replication, sharding

• Installation & Configuration

  • Single-node setup

  • Basic cluster configuration

• ClickHouse SQL Basics

  • Data types, functions, and operators

  • Creating databases and tables

Data Management & Querying

• Data Ingestion

  • INSERT, batch loading, importing CSV/JSON/Parquet

  • Using external data sources

• Query Execution & Optimization

  • SELECT, filtering, grouping, joins, aggregations

  • Indexes: primary, sparse, and data skipping indexes

  • Projections and materialized views

• Partitioning & Replication

  • Table engines (MergeTree, SummingMergeTree, AggregatingMergeTree, ReplicatedMergeTree)

  • Partitioning strategies

  • High availability with replication

Advanced Features

• Performance Tuning

  • Compression codecs and storage optimization

  • Query profiling and system tables

  • Caching strategies

• Security & Monitoring

  • User management and access control

  • Monitoring with system metrics

Hands-on Exercises

Summary and Conclusion