Database Normalization: 1NF to 5NF
Complete guide to database normalization covering 1NF through 5NF with practical examples, smell tests, and denormalization guidelines.
Databases
Data Modeling: From Concept to Physical Design
Understanding the data modeling process, conceptual/logical/physical models, entities and attributes, and crow-foot notation for ER diagrams.
Enterprise Database Design Patterns
Production-grade patterns for OLTP and reporting systems: transactions, concurrency, dimensional modeling, data pipelines, and schema evolution.