System Design & Architecture
Databases & Data Storage (SQL vs NoSQL, Sharding, Replication)
65 lessons in System Design & Architecture
- Choosing Storage for Different Data TypesSlides / Video
- Caching Layers for Data StorageSlides / Video
- Data Consistency Models ExplainedSlides / Video
- Vertical vs Horizontal PartitioningSlides / Video
- Resharding and Consistent HashingSlides / Video
- Shard Key Selection and Hotspot AvoidanceSlides / Video
- Synchronous vs Asynchronous ReplicationSlides / Video
- Database Replication StrategiesSlides / Video
- Database Indexing and Query PerformanceSlides / Video
- Normalization vs DenormalizationSlides / Video
- CAP Theorem ExplainedSlides / Video
- BASE and Eventual ConsistencySlides / Video
- Two-Phase CommitQuiz
- Relational Model and RelationshipsQuiz
- NoSQL Data ModelsQuiz
- ACID TransactionsQuiz
- BASE and Eventual ConsistencyQuiz
- Normalization vs DenormalizationQuiz
- Schema-on-Read vs Schema-on-WriteQuiz
- Indexing and Query PerformanceQuiz
- Choosing a Shard KeyQuiz
- Resharding ChallengesQuiz
- Cross-Shard QueriesQuiz
- Multi-Master ReplicationQuiz
- Synchronous vs Asynchronous ReplicationQuiz
- Replication LagQuiz
- CAP Theorem BasicsQuiz
- Partition Tolerance and FailoverQuiz
- Quorum Reads and WritesQuiz
- Vertical vs Horizontal PartitioningQuiz
- Polyglot PersistenceQuiz
- OLTP vs OLAPQuiz
- Backup and Disaster RecoveryQuiz
- Connection PoolingQuiz
- ACID Properties ExplainedSlides / Video
- SQL vs NoSQL Trade-offsSlides / Video
- NoSQL Database TypesSlides / Video
- Distributed Transactions and 2PCFlashcard
- Leader Election and FailoverFlashcard
- Shard Key Selection and HotspotsFlashcard
- Master-Master ReplicationFlashcard
- Data Warehouses, Lakes, and Object StorageFlashcard
- Polyglot PersistenceFlashcard
- Database Connection PoolingFlashcard
- Quorum-based Reads and WritesFlashcard
- Consistency ModelsFlashcard
- Vertical PartitioningFlashcard
- Sharding StrategiesFlashcard
- Database IndexingFlashcard
- CAP TheoremFlashcard
- BASE PropertiesFlashcard
- SQL vs NoSQL Trade-offsFlashcard
- Resharding and Data RebalancingFlashcard
- Database Replication FundamentalsFlashcard
- Replication Lag and Its ConsequencesFlashcard
- OLTP vs OLAP WorkloadsFlashcard
- Relational (SQL) Database FundamentalsFlashcard
- NoSQL Data Model TypesFlashcard
- PACELC TheoremFlashcard
- Synchronous vs Asynchronous ReplicationFlashcard
- Caching Layer for DatabasesFlashcard
- NoSQL Database FundamentalsFlashcard
- ACID PropertiesFlashcard
- Normalization vs DenormalizationFlashcard
- Relational Database Fundamentals and SchemaSlides / Video