ALTINITY TRAINING FOR CLICKHOUSE

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

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.

Altinity Quickstart for ClickHouse!
Build Your First App

NOW AVAILABLE ON DEMAND

Recommended pre-requisite for those new to SQL.

Altinity Developer Academy for ClickHouse:

(formerly ClickHouse 101 Training)

Curriculum Info

May 10th, 12th, 17th and 19th

11 am – 1 pm ET each day


June 21st, 23rd, 28th, 30th

12 pm – 2 pm ET each day

Developer Academy 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

  • Use of arrays in ClickHouse
  • Handling JSON data
  • Integration with Kafka
  • 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.