Database Design & Performance
Relational modeling, normalization, ACID, indexes, query performance, replication, sharding, storage engines, and detailed DBMS interview preparation.
12 lessons · about 0.3 hours
Start the first lesson →
Database Design & Performance
Relations, normalization, transactions, indexes, query performance and scaling.
- 01Database Relations & Foreign Keys Model one-to-one, one-to-many and many-to-many data with keys, constraints and deletion rules that protect real business facts.
- 02Normalization & Denormalization Learn 1NF, 2NF, 3NF and BCNF with one concrete order example, then decide when a controlled denormalized read model is worth it.
- 03ACID, Transactions & Locks Make multi-step changes correct with atomic transactions, isolation choices, constraints and short-lived locks.
- 04Indexes, EXPLAIN & Query Plans Design indexes from real filter, join and sort patterns, then prove improvements with query plans and production-like data.
- 05N+1 Queries, Loading & Pagination Prevent hidden query explosions, load relations intentionally, and paginate large changing lists without scanning the past.
- 06Replication, Partitioning & Sharding Scale reads with replicas, split data safely with partitions and shards, and plan for consistency, hot keys and operational recovery.
- 07Storage Engines & Database Operations Understand B-trees, LSM trees, write-ahead logs, connection pools, backups and the signals behind database reliability.
Database Interview Prep
Thirty DBMS interview questions with detailed answers and SQL practice.
- 08DBMS Foundations, Keys & Normalization Detailed interview answers for DBMS advantages, normalization, keys, abstraction and conceptual design. Covers PDF questions 1-5, 12, 14-17 and 19.
- 09SQL Language, Identifiers & Data Types Interview answers for DDL/DML/DCL, generated IDs, UNION, static/dynamic SQL and CHAR/VARCHAR. Covers PDF questions 6, 7, 13, 21 and 22.
- 10Transactions, Indexes & Concurrency Interview answers for triggers, ACID, clustered indexes, deadlock/livelock and RAID. Covers PDF questions 8-11 and 18.
- 11Views, Triggers & Stored Procedures Interview answers for views, materialized views, triggers and stored procedures. Covers PDF questions 20, 24 and 27-30.
- 12SQL Interview Query Drills Correct solutions for duplicates, above-average values and third-highest salary. Covers PDF questions 23, 25 and 26.