3 — Internal Architecture Deep Dive
Purpose
[stub: internal-architecture-deep-dive]
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.
2 — SQL Coding Interview
Covers a SQL coding interview practice set spanning easy through hard window-function and recursive SQL problems.
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.