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

Data Warehouse Basics:
May 11th

10am – 12pm PT

Recommended pre-requisite for those new to SQL.

Learn More
101 Series Training:
May 18th, 20th, 25th and 27th

10 am – 12 pm PT 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
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.
101 Training Attendee
Clickhouse Novice

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

Contact Us

You Build Your Business, We’ll Manage ClickHouse

Analytic applications guide your business.  Altinity is there to ensure your systems are always up and your vision is clear. Our team is an expert at every aspect of developing and operating ClickHouse.  We handle everything from helping restore down systems to answering developer questions.  

Start for Free
Contact Sales