This module explores the fundamental concepts and operations of relational algebra and the theoretical foundation of relational databases. Students will first learn the core elements of relational algebra, such as relations, tuples, and operations. The module then delves into basic operations (selection and projection) and advanced operations techniques (joins and division). The module also covers composite and aggregation operations and touches on query optimization techniques. By the end, students will have a strong theoretical understanding to work with relational databases effectively.

This module introduces SQL (Structured Query Language), the industry-standard language for managing relational databases. Students will first learn the role of SQL and its categories, then dive deeper into Data Definition Language (DDL) for creating/modifying schemas and finally practice Data Manipulation Language (DML) to query and modify data using the Chinook database.

This module builds on foundational SQL skills, introducing advanced querying techniques for complex data retrieval and analysis. Students will learn subqueries (correlated and non-correlated), multi-table joins (INNER, OUTER, CROSS, SELF), aggregations with GROUP BY and HAVING, and set operations (UNION, INTERSECT, EXCEPT). The module also covers derived tables, common table expressions (CTEs), views, indexing, and database access control.

This module contains the summative course assessment that has been designed to evaluate your understanding of the course material and assess your ability to apply the knowledge you have acquired throughout the course.