ClickHouse Academy
Level Up Your Skills In ClickHouse and Cloud Data Engineering
Introduction To ClickHouse
A High Level Introduction To The ClickHouse Database
In this course we will introduce ClickHouse for people new to the platform. We will introduce some of it's key concepts and architectural features, and explain how it is different to other transactional and analytical databases.
ClickHouse Database Objects
The Building Blocks Of A ClickHouse Database
In this course we will learn about the core database objects found within ClickHouse, such as tables, views, materialised views, functions and dictionaries.
Querying Data In ClickHouse
Techniques For Querying ClickHouse
In this course we will focus on querying data in ClickHouse. This includes standard queries across one or more tables, but also functions for working with non-relational data (e.g. JSON or XML) and making use of functions.
Ingesting Data Into ClickHouse
Importing Data Into Your ClickHouse Database From External Sources
In this course we will focus on loading data into ClickHouse from sources such as external files which are hosted locally or on cloud storage, from other databases, or from locations such as streaming engines such as Kafka.
Administering and Operating ClickHouse
Running And Operating Your ClickHouse Instance
In this course we will learn various facets about how to operate and run your own ClickHouse instance. This includes considerations such as monitoring, upgrades and backups.
Securing ClickHouse and Role Based Access Control
How To Secure Your ClickHouse Instance And Implement Access Controls For Data
In this course we will learn how to secure your ClickHouse database and the data contained within it. This includes securing your ClickHouse instance and using role based access control to control which users can access which data.
Integrating ClickHouse With Other Tools
Building An End-To-End Data Platform
In this course we will look at other third party tools which are often integrated with ClickHouse, and describe at a high level how they work together.
ClickHouse Performance Optimisations
Optimising The performance Of Your ClickHouse Environment
In this course we will focus on performance optimisations and considerations. This includes optimising both your ClickHouse instance or cluster, together with SQL level techniques for optimising the performance of your queries.
Table Engines In ClickHouse
Ingesting Data Into ClickHouse
In this course we will learn about the different table engines which are available in ClickHouse, and demonstrate how they are used to support our data management and queries.
Using Business Intelligence Tools With ClickHouse
Learn How To Connect And Use Business Intelligence Tools To Analyse Data In ClickHouse
In this course we will learn about various open source and commercial business intelligence, dashboard and reporting tools and explain how they can be used with ClickHouse Cloud.
ClickHouse Internals
Understanding The Internal Abstractions Of ClickHouse
In this course we will learn about some of the key abstractions and concepts within ClickHouse. Though many of these are internal, they are nonetheless useful to know to help us as we build solutions with ClickHouse.
Data Engineering Concepts
Learn The Foundational Building Blocks Of Data Engineering
In this course we will learn about the concept and approaches of Data Engineering. This involves applying the principles of software engineering to the data world in a way that allows us to build simple, maintainable, reliable and testable code.
Streaming Data and Stream Processing
Learn How To Process And Analyse Real Time Streaming Data
In this course we will learn about streaming data and stream processing. This involves working with data that is produced as a continuous stream.
Introduction To Kafka
Learn How To Integrate Kafka With ClickHouse
In this course we will learn about Kafka, the leading engine for working with streaming and real-time data. As ClickHouse is commonly found in real-time analytics scenarios, it is often combined with streaming engines such as Kafka in order to ingest or publish data in a streaming fashion.
The Modern Data Stack
Learn How Modern Data & Analytics Solutions Are Being Delivered Using Cloud Based Platforms
In this course we will learn about the concept of the Modern Data Stack, describing how it is being used to build data platforms that require very low operational overhead.
Introduction to dbt
Learn Analytics Engineering Using dbt Core
In this course we will learn about dbt, the open source tool that is used for data transformations in relational data warehouses. Though dbt is more commonly found against traditional data warehouses, it still potentially serves a useful purpose as part of your ClickHouse deployment.
Data Lakehouse Architecture
Learn About The Data Lakehouse Architecture And How It Can Be Used For Data Management
In this course we will learn about the Data Lakehouse pattern, which combines the best features of the Data Warehouse and Data Lake into one unified data platform.