NOTE: This course has been updated. Please check out the new learning path HERE.

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.