Toronto In-Person Training: Real-time Analytics with ClickHouse

Date: June 5, 2026
Time: 9:00AM EST
Duration: 8 hours
Location: Room Classroom 5F, 5th Floor, 100 University Avenue, Toronto, ON M5J 1V6
Cost: FREE
Format: Instructor-led training with hands-on labs

What you’ll learn: This hands-on training is the fastest way to ramp up on ClickHouse. Topics range from introductory content to a deep dive on interacting with and understanding your data.

By the end of this session: You will have the knowledge necessary to build and optimize a production-level ClickHouse application, including the ability to model tables effectively, insert data, write efficient queries, and optimize queries using the various features of ClickHouse - including materialized views, projections, and secondary indexes. You will also be prepared for the ClickHouse Certified Engineer exam.

There will be both instructor-led training and hands-on labs. The material is presented in modules and will include:

  • Introduction to ClickHouse
  • Deep Dive into ClickHouse Architecture
  • Inserting Data into ClickHouse
  • Modeling Data with ClickHouse
  • Analyzing Data with ClickHouse
  • Joining Data
  • Deleting and Updating Data
  • Query Acceleration Techniques
  • Sharding and Replication
  • Managing Data in ClickHouse

Prerequisites:

  • During the training, you will access your course materials in ClickHouse Academy. It is recommended that you create an account before the event HERE.
  • Familiarity with SQL
  • ClickHouse Cloud account to access the labs
  • You will also need to spin up a Clickhouse Cloud Service. If you have already used up your free trial, please contact us at least one day before the training.

Register your interest. Seats are limited!

Hosted by

Rich Raposa

Rich Raposa

Instructor

Loading form...

Upcoming events