ClickHouse Training

Example 3-Session Course Structure:

Session 1

Lesson: Basic Installation and Configuration (20 mins)

  • ClickHouse installation for various platforms
  • Client interfaces and drivers
  • Configuration and monitoring

Lesson: ClickHouse Application Design (60-70 mins)

  • Tables and engines
  • Basics of schema design
  • Data import and load
  • ClickHouse SQL
  • Working with Dictionaries

SESSION 2

Lesson: Advanced Topics (90 mins)

  • Working with arrays
  • Approximate computing and sampling
  • Optimizing SQL queries
  • Replacing, Collapsing, Summing and Aggregating merge tree engines
  • Using Materialized views

SESSION 3

Lesson: ClickHouse Cluster (60 mins)

  • Setting up the cluster
  • Distributed tables and distributed query processing
  • Data replication
  • Different topologies and use cases
  • Consistency and monitoring