Loading…
34+ curated questions with the same answer shape every time: quick recap, deep dive, pitfalls, and follow-ups. Coverage includes sql fundamentals, joins and subqueries, transactions and acid, connection pooling, and more.
Suggested path
Topics follow a teaching order. Each answer ends with a clear Next question control so you can move forward without hunting the list.
SQL database interviews test whether you can reason about query plans and transaction semantics, not just write SELECTs. This module is an elevation arc: it opens with SQL fundamentals (the relational model, the clauses), then joins and subqueries, then transactions and ACID (the most-asked topic — isolation levels, anomalies). Connection pooling, indexes, and query optimization are the performance tier — where senior interviewers probe. The advanced tier covers migrations, window functions, partitioning/sharding, replication, and backup/recovery. It closes with comparisons and scenario-based questions.
Full catalog
Topics are ordered for learning. Within each topic, rows are numbered 1–34 globally so you always know where you are. Collapse topics if you want a lighter view — use Expand all when you need the full list again.
Numbers 1–34 follow the order we recommend — click any row to open the full answer, or use the sticky Next link at the bottom of each page to go Q1 → Q34.
Interviewers rarely ask SQL & Relational Databases in isolation. These are the modules that most often come up in the same loop.