ClickHouse Database Objects
In this course we will learn about the core database objects found within ClickHouse, such as tables, views, materialised views, functions and dictionaries.
Introduction
In this lesson we will introduce the various database objects found within a ClickHouse data warehouse and describe the lifecycle for managing them.
Materialised Views
In this lesson we will introduce materialised views, and demonstrate how they are more powerful than materialsied views as implemented by other databases.
Functions
In this lesson we will learn about the various ways of creating and integrating with user defined functions.
Indexes
In this lesson we will learn about database indexes and how ClickHouse makes use of them to speed up query performance.