Tutorial · 41 chapters
DBMS
Database Management Systems from the ground up: ER modeling, the relational model, normalization, transactions, concurrency control, indexing and recovery.
Mission log
01Introduction to DBMS02File System vs DBMS03DBMS Architecture04Three-Schema Architecture & Data Independence05Data Models06Database Languages (DDL, DML, DCL, TCL)07ER Model08Types of Attributes09Relationships, Cardinality & Participation10Weak Entities11Generalization, Specialization & Aggregation12Converting ER Diagrams to Tables13Relational Model14Keys in DBMS15Integrity Constraints16Relational Algebra17Relational Calculus18Functional Dependencies19Attribute Closure & Candidate Keys20Canonical Cover21Normalization & Anomalies221NF, 2NF & 3NF23BCNF244NF & 5NF25Lossless Join & Dependency Preservation26Transactions & ACID Properties27Transaction States28Schedules & Serializability29Conflict & View Serializability30Recoverable & Cascadeless Schedules31Lock-Based Concurrency Control (2PL)32Timestamp Ordering Protocol33Deadlocks in DBMS34Recovery & Logging35File Organization36Indexing in DBMS37B-Tree & B+ Tree38Hashing in DBMS39Query Processing & Optimization40NoSQL Databases41Distributed Databases & CAP Theorem
