Skip to main content
@shmVirus

Database Systems

Relational models, SQL, normalisation, transactions, indexing, and an introduction to NoSQL — storing and querying structured data reliably.

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 →
  1. 01
    The Relational ModelTables, primary and foreign keys, and the mathematical foundations of relational data.
  2. 02
    SQL FundamentalsSELECT, INSERT, UPDATE, DELETE, joins, aggregations, and subqueries.
  3. 03
    Schema Design and NormalisationFunctional dependencies, normal forms, and translating real-world entities into clean schemas.
  4. 04
    Transactions and IndexingACID properties, isolation levels, B-tree indexes, and how a query engine uses them.