BeginnerDatabaseSQL FundamentalsWhat is a relational database and how does it organize data?Not practiced yet#1
BeginnerDatabaseSQL FundamentalsWhat's the difference between a primary key, foreign key, unique constraint, and index?Not practiced yet#2
IntermediateDatabaseSQL FundamentalsHow do INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN differ?Not practiced yet#3
IntermediateDatabaseSQL FundamentalsWhat is normalization (1NF, 2NF, 3NF) and when would you denormalize?Not practiced yet#4
IntermediateDatabaseTransactionsWhat are transaction isolation levels and which anomalies do they prevent?Not practiced yet#7
IntermediateDatabaseTransactionsWhat's the difference between optimistic and pessimistic locking?Not practiced yet#8
AdvancedDatabaseTransactionsWhat is MVCC and how does it let readers and writers coexist?Not practiced yet#9
IntermediateDatabaseTransactionsWhat causes deadlocks and how do you prevent and handle them?Not practiced yet#10
IntermediateDatabasePerformanceHow do database indexes work and what are their trade-offs?Not practiced yet#11
IntermediateDatabasePerformanceWhat is the N+1 query problem and how do you fix it?Not practiced yet#13
AdvancedDatabasePerformanceHow do you cache database reads and handle invalidation?Not practiced yet#15