Module 1

Foundations

Database System Concepts

Data vs information, file system limitations, DBMS characteristics, data models, and schema architecture.

Module 2

Design

Database Design

ER model, entities, attributes, relationships, keys, relational model constraints, and normalization from 1NF to 5NF.

Module 3

Querying

Query Languages

SQL command groups, joins, subqueries, views, triggers, plus NoSQL basics with Redis and MongoDB.

Module 4

Control

Transactions and Concurrency

ACID, serializability, recoverability, isolation levels, locking protocols, deadlock handling, and timestamp ordering.