System design
Learning paths
Topics
Roadmaps
Games
Search articles, topics...
⌘K
Library
Topics
SQL
Relational databases and the queries interviews ask about.
Path
System design
Databases
Articles
Level
Foundation
Core
Senior
Staff
Design questions only
Narrow
Reliability
1
Data modelling
2
Sharding
1
Transactions and locking
1
Storage and indexes
2
NoSQL
1
API design
1
11 pages
SQL vs NoSQL
System design · Foundation · 16 min
NoSQL
Data modelling
Sharding
System design · Core · 14 min
Sharding
How a database runs a query
Databases · Foundation · 8 min
Storage and indexes
Indexes
Databases · Core · 9 min
Storage and indexes
Transactions and ACID
Databases · Core · 7 min
Transactions and locking
Normalization
Databases · Foundation · 7 min
Data modelling
Joins
Databases · Foundation · 6 min
SQL interview questions
Databases · Core · 7 min
SQL cheat sheet
Databases · Foundation · 7 min
Offset vs cursor pagination
Articles · Core · 10 min
API design
Zero-downtime migrations
Articles · Senior · 12 min
Reliability