Topic
Sql
Learn Sql as a connected topic across chapters, concepts, simulations, and interview reasoning.
10 Concepts21 Articles7h 54m
Overview
Learn Sql as a connected topic across chapters, concepts, simulations, and interview reasoning.
How this topic helps
System Design
Databases
Distributed Systems
Nosql
Learning Path in this Topic
Series that contain articles from Sql. Select a path to filter the article list.
Articles
21 matched articles
Article 1SQL Partitioning: Range, Hash, List, and Composite Strategies ExplainedTLDR: SQL partitioning divides one logical table into smaller physical child tables, all accessed through the parent table name. The query optimizer skips irrelevant child tables entirely — a process 25 min
Article 2ACID Properties Explained: How SQL Databases Guarantee Atomicity, Consistency, Isolation, and DurabilityTLDR: ACID is four orthogonal guarantees that every SQL transaction must provide. Atomicity says all-or-nothing: PostgreSQL implements it via WAL rollback; MySQL InnoDB via undo logs. Consistency says38 min
Article 3Partitioning Approaches in SQL and NoSQL: Horizontal, Vertical, Range, Hash, and List PartitioningTLDR: Partitioning splits one logical table into smaller physical pieces. The database skips irrelevant pieces entirely — turning a 30-second full-table scan into a sub-second single-partition read. S12 min
Article 4Sharding Approaches in SQL and NoSQL: Range, Hash, and Directory-Based Strategies ComparedTLDR: Sharding splits your database across multiple physical nodes so no single machine carries all the data or absorbs all the writes. The strategy you choose — range, hash, consistent hashing, or di29 minArticle 5Database Anomalies: How SQL and NoSQL Handle Dirty Reads, Phantom Reads, and Write SkewTLDR: Database anomalies are the predictable side-effects of concurrent transactions — dirty reads, phantom reads, write skew, and lost updates. SQL databases use MVCC and isolation levels to prevent 31 min
Article 6Isolation Levels in Databases: Read Committed, Repeatable Read, Snapshot, and Serializable ExplainedTLDR: Isolation levels control which concurrency anomalies a transaction can see. Read Committed (PostgreSQL and Oracle's default) prevents dirty reads but still silently allows non-repeatable reads, 28 minPage 1 of 4