Skip to the chapter
←SQL & DatabasesGGroundworkDBSQL & Databases
SQL & Databases/Intermediate/I1
9 / 25 written chapters
The cover
  1. B1Relational model
  2. B2SELECT fundamentals
  3. B3Joins
  4. B4Aggregations
  5. B5Insert/update/delete
  6. B6Types & constraints
  7. B7Schema design basics
  8. B8Using a DB client
  1. I1Normalization in depth
  2. I2Indexes
  3. I3Transactions
  4. I4Subqueries & CTEs
  5. I5Query performance
  6. I6NoSQL fundamentals
  7. I7ORMs
  8. I8Migrations
  9. I9Backups & replication
  1. A1Database internals
  2. A2Scaling reads
  3. A3Scaling writes
  4. A4Advanced transactions
  5. A5Caching layers
  6. A6Security in depth
  7. A7Time-series & analytical
  8. A8Schema case study

DBI1 · Part 2 · Intermediate

Normalization in depth

Not written yet.
9 of 25

Sketch only

01This chapter will cover

Normalization in depth

  • 1NF/2NF/3NF, when to denormalize on purpose

→Next stop

  1. B8Previous · B8Using a database client
  3. I1you are here
  5. Next · I2IndexesNext chapter

01Meanwhile

  • JavaScript is written, start there
  • R3 · JavaScript & TS covers this in the interview book