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
- 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.
Related
- Database design reference
- System design round — Q7 is “scale the database”
- Java persistence — N+1,
@Transactional, optimistic locking - Distributed transactions — isolation levels in depth
Jump to a subject
Software engineering
Infrastructure & security
Computer science
Hardware & engineering