Relational databases and SQL¶
All topics · Alphabetical index
Concepts¶
- Keys; constraints; referential integrity; functional dependencies
- Normalization; denormalization
- Joins; subqueries; CTEs; recursive queries; SQL window functions
- Composite indexes; covering indexes; partial indexes; expression indexes
- Selectivity; index column order; sargability
- Query planner; statistics; cardinality estimation; EXPLAIN
- Sequential scan; index scan; nested-loop join; hash join; merge join
- N+1 queries; batching; prepared statements; connection pooling
- Partitioning; materialized views; generated columns
- Vacuum; table bloat; index bloat; online migrations; backfills
Further reading¶
Reference links for this topic.