Altinity Administrator Training for ClickHouse®

Understand how ClickHouse works, not just how to use it 

Our training focuses on the inner workings of ClickHouse, so you can run, troubleshoot, and optimize your data systems yourself. Engineers leave our training with the knowledge and skills to run ClickHouse efficiently and avoid problems in any environment.

Get access to beginner training

Altinity Administrator Training Schedule

June 4, 6, 11, & 13 from 9am – 11am EDT EVENT PASSED and SOLD OUT

Sept 17, 19, 24, & 26 from 11am – 1pm EDT

Dec 3, 5, 10, & 12 from 11am – 1pm EDT

Join hundreds of engineers who have mastered ClickHouse with our training.

10/10 recommend. Some topics I like the most include examples, guidelines, and fine tuning for different setups (small vs very large clusters or OLAP vs OLTP storages).

The only training for ClickHouse administration on the market

While other trainings focus on the basics, the Altinity Administrator Training teaches you not only how to use ClickHouse, but how it works. The result: you can efficiently and successfully run ClickHouse yourself.

Live instruction with an in-depth approach, ask questions at any time

Forget pre-recorded, high-level overview training. Our live sessions provide a detailed and personalized approach. Get instant answers to your questions and stay in touch with the Altinity team with a Slack channel for participants.

Detailed curriculum focused on understanding ClickHouse

Get a deep understanding of ClickHouse. Our training goes beyond the basics. The curriculum is designed to equip you with the expertise needed to own the process fully. We teach you not only how to use ClickHouse, but how it works, so you can not only run your database but optimize and troubleshoot it with confidence. 

Altinity Administrator Training Curriculum

4 sessions, 2 hours each! Plus unlimited time for your questions. Upon completion, we offer an Altinity Certified ClickHouse Administration badge.

Session 1:

  • What is ClickHouse
  • Getting to know ClickHouse
  • Understanding the MergeTree engine
    • How data is stored
    • What happens in the background
    • How to modify data

Session 2:

  • Setting up a cluster
    • Understanding replication
    • Creating tables in a cluster
    • Querying distributed tables
    • Inserting data into a cluster

Session 3:

  • Resource management
    • Disk
    • Memory
    • CPU
    • Network
  • How to debug issues

Session 4:

  • Installation and upgrade
  • Configuration
    • Storage policies
    • User management
  • Monitoring
  • ZooKeeper and Keeper
  • Backup
  • Integrations

Instructor: Tatiana Saltykova

Tatiana has been involved with ClickHouse since 2016 and has observed its growth firsthand. As a seasoned ClickHouse Solutions Engineer, Tatiana has navigated the complexities of operating exceptionally large ClickHouse clusters, ensuring optimal performance and reliability across diverse environments.

Since 2021, she has trained hundreds of developers on ClickHouse. Her extensive background ensures that training participants gain insights grounded in practical expertise and forward-thinking strategies, empowering them to excel in managing and optimizing ClickHouse environments.

Join the registration list (and be first to know when we have new training dates)

Is Altinity Administrator Academy Training really for me?

How is this different from the other trainings for ClickHouse?

We offer the only administrator ClickHouse training on the market. Our training is focused on the detailed knowledge to operate business critical ClickHouse clusters in any environment from on-prem to public cloud.

What if I cannot attend a session?

The session is recorded, so you can access it anytime. By attending the live session, you will be able to get answers to your questions in real time.

Is the training for beginner or more experienced users?

This training is for system admins and DBAs. If you are a beginner, check out our past recorded training sessions below!

Training for ClickHouse (for beginners)

ClickHouse fundamentals: A complete introduction to ClickHouse for developers.

Get on-demand instruction to level up your ClickHouse skills. Upon completion, you 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.