Overview

How data is structured, stored and moved inside a business. Covers modelling structured data, relational databases and OLAP systems, writing SQL to retrieve and manipulate that data, and planning ETL flows to make it analytics-ready.

Topics covered

• Relational data modelling
• SQL for querying and manipulation
• OLAP and analytical data stores
• ETL design and data quality

Key assignments

• [Assignment 1, fill in with what you actually built]
• [Assignment 2, tool used, outcome, your contribution]

Takeaways

[What stuck with you. What you'd apply elsewhere. Fill in once you've wrapped the paper.]