2 — SQL Coding Interview
Purpose
[stub: sql-coding-interview]
Metadata
| Author | Amit Singh |
| Scope | dbms |
Local graph
Related notes
1 — Frequently Asked Interview Questions
Covers the recurring DBMS comparison questions asked in interviews — ACID vs BASE, clustered vs non-clustered indexes, B-tree vs B+-tree, 2PL vs MVCC, OLTP vs OLAP, and normalization vs denormalization.
3 — Internal Architecture Deep Dive
Covers internals deep dives across PostgreSQL, MySQL InnoDB, Oracle, and SQL Server.
4 — Mock Interview Problems
Covers full mock-interview problem sets spanning theory, SQL, database design, performance, and troubleshooting.
Database Management Systems
A book-shaped table of contents for DBMS: relational foundations through SQL mastery, storage internals, transactions, distributed databases, NoSQL, and MAANG interview prep — cross-linking existing system-design/patterns notes instead of duplicating them.