Topic overview
Study relational design, normalization, indexes, transactions, isolation, locking, query planning, and storage tradeoffs.
Core concepts
ACID, primary and foreign keys, B-trees, constraints, replication, partitioning, consistency, and schema evolution.
Why it matters
Database choices shape application correctness, reliability, latency, and operational complexity.
Interview relevance
DBMS questions reveal whether you can design data models and reason about performance under real constraints.