Data lives somewhere — and most of the time, that “somewhere” is a relational database. This unit equips you to confidently navigate databases and use SQL to store, retrieve, and manage data with accuracy and control. You’ll start with RDBMS fundamentals (tables, keys, relationships) and build strong querying skills with SELECT, filtering, ordering, and early exploration techniques that help you understand what’s in a dataset before you touch it.
As you progress, you’ll level up into the real work of data management and analysis: combining tables with JOINs, summarising at scale with GROUP BY and aggregate functions, and applying advanced patterns like subqueries, CASE logic, set operations, and introductory window functions. To bridge database work with data science workflows, you’ll also integrate SQL directly into Python — connecting to databases, executing queries safely, and loading results straight into Pandas for analysis. By the end, you’ll be able to design clean queries, make controlled schema changes with DDL, update data responsibly with DML, and automate repeatable, end-to-end database-to-analysis pipelines.
Level: Intermediate
Category: LABS