Database Management Systems

Start module 1

What is this course

Understand how database systems store, query, and guarantee reliable persistence for structured data. Learn relational theory, design normalized schemas, and master SQL execution and transaction isolation.

Who it is for

  • Software engineers and backend developers building data-driven systems
  • Computer science students preparing for DBMS coursework and exams
  • Data engineers seeking a rigorous understanding of transaction engines

Modules

  1. Introduction to DBMS and the relational model
  2. Entity-relationship (ER) modeling and schema design
  3. Relational algebra and calculus
  4. Structured Query Language (SQL): DDL, DML, and joins
  5. Schema normalization (1NF, 2NF, 3NF, BCNF) and anomalies
  6. Storage engine files, hashing, and B+ tree indexing
  7. Query processing and cost-based query optimization
  8. Transactions, ACID properties, and concurrency control