An introduction to data warehouses for newcomers to SQL. Students will learn how data warehouses work, how to install ClickHouse, and how to issue standard SQL commands to build reports and dashboards in ClickHouse. This class is a recommended prerequisite for people planning to take ClickHouse 101 who have not previously used SQL databases.

The class includes a short lab on a live ClickHouse server to cement understanding of SQL commands. Students can complete exercises using a web browser.

The class does not assume previous use of ClickHouse or any prior knowledge of SQL.