Join Our Webinar On 7th June 2024 - Building Real Time Analytics Solutions With ClickHouse Cloud

Read More

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.

Program:
9 Lessons
Level:
Beginner
Total Time:
1h 15m
Lesson overview:
01

Introduction

In this lesson we will introduce the various database objects found within a ClickHouse data warehouse and describe the lifecycle for managing them.

0h 5m
02

Tables

In this lesson we will learn about ClickHouse tables.

0h 5m
03

Views

In this lesson we will learn about ClickHouse views.

0h 15m
04

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.

0h 15m
05

Functions

In this lesson we will learn about the various ways of creating and integrating with user defined functions.

0h 5m
06

Indexes

In this lesson we will learn about database indexes and how ClickHouse makes use of them to speed up query performance.

0h 5m
07

Dictionaries

In this lesson we will learn about ClickHouse dictionaries.

0h 5m
08

Information Schema

In this lesson we will learn about informations schema.

0h 5m
09

Table Functions

In this lesson we will learn about ClickHouse Table Functions.

0h 15m
Benjamin Wootton
Your Course Curator

Benjamin Wootton

Ensemble Founder

Join our mailing list for regular insights:

We help enterprise organisations deploy advanced data, analytics and AI enabled systems based on modern cloud-native technology.

© 2024 Ensemble. All Rights Reserved.