In this course, you'll learn:

• How to define a projection to store rows or aggregated values of a table for faster querying
• How to define secondary indexes (called skipping indexes) that can cleverly skip granules in your MergeTree tables
• Some best practices and anti-patterns for optimizing ClickHouse

This course also includes hands-on lab exercises.