In this course, you'll learn how to:
- define a simple view and a materialized view in ClickHouse
- create a materialized view that keeps a running total of numeric columns
- how to aggregate columns using the AggregatingMergeTree table engine
- work through examples that follow the recommended usage of materialized views, including using the TO clause and populating a view without losing data
This course also includes hands-on lab exercises.