Altinity Training for ClickHouse™

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 Altinity Quickstart for ClickHouse (formerly ClickHouse Bootcamp) webinar as a pre-requisite.

Altinity Quickstart for ClickHouse!
Build Your First App

NOW AVAILABLE ON DEMAND

Recommended pre-requisite for those new to SQL.

Watch Now

Knowledge is Power

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

Earn an Altinity Certified ClickHouse Developer certification.

Curriculum Info

Training Schedule

Developer Academy Training Curriculum

Session 1

ClickHouse introduction
Organization of databases
Creating and modifying tables
Data loading methods
Deleting and changing data
Labs: Basic navigation, schema creation

Session 2

Deep dive into analytic queries
Optimizing schema for performance
Labs: Practice with SQL SELECTs, creating an index, optimizing compression

Session 3

Use of arrays in ClickHouse
Handling JSON data
Materialized views
Integration with Kafka
Lab: Using arrays to track events, extracting JSON data into table columns, creating a materialized view

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

Altinity ClickHouse Training Schedule

Altinity Developer Academy for ClickHouse Training:

(formerly ClickHouse 101 Training)

May 9th, 11th, 16th, 18th

11 am – 1 pm ET each day

The lab exercises are a real plus. Nice to have a running clickhouse server setup where we can try things out immediately.

101 Training Attendee

ClickHouse User

The presenters are very knowledgeable. I really appreciate their thoughtfulness in answering questions.