Module 1: Introduction to DBMS - Final Quiz
The system that stores, manages, and secures all enterprise data
Module 2: Data Models & ER Diagrams - Final Quiz
Entities, attributes, relationships, cardinalities, and converting ER models to tables
Module 3: Relational Model & Keys - Final Quiz
Relations, tuples, attributes, key hierarchies, and relational algebra
Module 4: Normalization & Functional Dependencies - Final Quiz
Eliminating data redundancy and update anomalies to achieve database purity
Module 5: SQL Fundamentals - Final Quiz
The standard declarative language for relational database definition, manipulation, and query
Module 6: SQL Joins, Subqueries & Views - Final Quiz
Combining multi-table relations and structuring complex analytical queries
Module 7: Transactions & ACID Properties - Final Quiz
The bedrock of data integrity, atomicity, consistency, and crash recovery
Module 8: Concurrency Control & Locking - Final Quiz
Schedules, serializability, lock protocols, 2PL, and deadlock handling
Module 9: Indexing & Query Optimization - Final Quiz
Accelerating query retrieval, B+ trees, execution plans, and cost-based optimizers