CLICKHOUSE TRAINING

Knowledge is Power

Whether you are a beginner or an experienced user, Altinity’s ClickHouse training turns your team into ClickHouse experts. You do not need to have a working knowledge of ClickHouse, but any relational database (e.g., MySQL) experience is recommended. If you are new to relational databases, we do recommend our Data Warehouse Basics course as a pre-requisite which is offered free the week prior.

Overview

A complete introduction to ClickHouse for developers. Students learn about ClickHouse architecture as well as practical steps to build high-performance analytic applications. Upon completion students will be able to:

  • Design tables and load data into them, including CSV and JSON
  • Issue a wide range of analytic queries and improve their performance- Use features like compression, materialized views, and indexes effectively
  • Understand how to integrate ClickHouse with Kafka
  • Design schema and issue queries on ClickHouse clusters.

Students are assumed to be familiar with SQL basics but do not need to have used ClickHouse previously. Sessions include in-class lab exercises on a live ClickHouse to cement understanding using standard ClickHouse clients.

Duration

8 hours (Four 2-hour sessions over two weeks)

Cost

$500 USD

Certification

Walk away with an Altinity Certified ClickHouse Developer certification.

Data Warehouse Basics:

Multiple Dates Available

Recommended pre-requisite for those new to SQL.

101 Series Training:

Curriculum Info

September 14th, 16th, 21st and 23rd

10 am – 12 pm PT each day


November 9th, 11th, 16th and 18th

10 am – 12 pm ET each day

ClickHouse 101 Training Curriculum

Session 1

  • ClickHouse introduction
  • Creating and modifying tables
  • Data loading methods
  • Compression and partitioning
  • Labs: Basic navigation, schema creation, optimizing compression

Session 2

  • Organization of databases
  • Deep dive on analytic queries
  • Materialized views and indexes
  • Labs: Practice with SQL SELECTs, materialized view creation

Session 3

  • ClickHouse installation
  • Integration with Kafka
  • Use of arrays in ClickHouse
  • Handling JSON data
  • Lab: Using arrays to track events, extracting JSON data into table columns

Session 4

  • Introduction to clusters: replication and sharding
  • Creating schema and loading data in clusters
  • Distributed query processing
  • ClickHouse user management
  • Lab: Create, populate, and query clustered tables

Not seeing what your team requires for training? Contact us and we’ll see how we can help.