Relational databases are the backbone of most web applications. This unit covers the
fundamentals of SQL, database design (normalization), indexing strategies, and ACID
transactions. You will learn how to design efficient schemas and write performant queries.
Unit Learning Outcomes
Design normalized relational schemas (up to 3NF/BCNF).
Write complex SQL queries using joins, aggregations, and subqueries.
Implement indexes to optimise query performance.
Manage database transactions with ACID guarantees.
Understand and apply isolation levels appropriately.