EncartaLabs

ClickHouse

( Duration: 2 Days )

This ClickHouse training course provides skills about ClickHouse architecture as well as practical steps to build high-performance analytic applications.

By attending ClickHouse workshop, delegates will learn 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.

Knowledge of:

  • Data Warehouse
  • SQL

The ClickHouse class is ideal for:

  • Developers

COURSE AGENDA

Day 1

  • ClickHouse introduction
  • Creating and modifying tables
  • Data loading methods
  • Compression and partitioning
  • Organization of databases
  • Deep dive on analytic queries
  • Materialized views and indexes

Day 2

  • ClickHouse installation
  • Integration with Kafka
  • Use of arrays in ClickHouse
  • Handling JSON data
  • Introduction to clusters: replication and sharding
  • Creating schema and loading data in clusters
  • Distributed query processing
  • ClickHouse user management

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top