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. Developers 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, and 13 from 9am – 11am EDT

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

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

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 a hands-on approach, ask questions at any time

Forget pre-recorded, high-level overview training. Our live sessions provide a hands-on 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:

  • Installation and configuration
  • Storing data: the MergeTree engine
    • How data is stored
    • How data is modified
    • What happens in background

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

Session 4:

  • Monitoring
    • What to collect: metrics, logs
    • Available monitoring tools
  • Backup
  • Upgrade

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.

Cannot make our current training? 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.