Almost every application stores data somewhere. This course covers the relational model, SQL from basics to advanced queries, schema design and normalisation, transactions, indexing, and a survey of NoSQL alternatives.
Outcomes
- Write SQL queries including joins, aggregations, and correlated subqueries
- Design a normalised relational schema from a set of requirements
- Explain the role of transactions, isolation levels, and indexing
- Choose between relational and NoSQL models and justify the decision
Outline
Start →- 01 The Relational Model Tables, primary and foreign keys, and the mathematical foundations of relational data.
- 02 SQL Fundamentals SELECT, INSERT, UPDATE, DELETE, joins, aggregations, and subqueries.
- 03 Schema Design and Normalisation Functional dependencies, normal forms, and translating real-world entities into clean schemas.
- 04 Transactions and Indexing ACID properties, isolation levels, B-tree indexes, and how a query engine uses them.