From sql-reference, database-design-reference, nosql-reference — and now backed by the numbered course, whose notes 04 (indexes), 07 (the optimiser), 08 (isolation) and 09 (MVCC) cover exactly what this round asks about.

Files

  1. SQL, Modelling & Internals — indexes, transactions, isolation, query plans, normalisation, SQL vs NoSQL

Why this round matters more than people expect

The database is where most real performance problems live and where most real data-loss bugs originate. In a backend interview, the database questions are where they find out whether you’ve operated a system or only queried one.

The tell: whether you reach for EXPLAIN before you reach for an opinion.

↑ Back to Databases