DBMS7 min read
Database Indexing Concepts
Understand core database indexing concepts including clustered versus non-clustered indexes, index selectivity, and how indexes trade write speed for read sp...
Arjun Mehta
DBMS
Database management concepts: normalization, ACID, indexing, transactions, and query planning.
2 articles
DBMS7 min read
Database Normalization: A Practical Guide
A practical guide to database normalization covering 1NF, 2NF, and 3NF with real examples, plus when denormalization makes sense for performance reasons.
Arjun Mehta