Databases & Data Storage (SQL vs NoSQL, Sharding, Replication)

67 lessons in System Design & Architecture

• Quorum Consistency Overlap CheckCode Quiz
• Quorum Consistency in Replicated SystemsQuiz
• 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
• Replication LagQuiz
• CAP Theorem BasicsQuiz
• Partition Tolerance and FailoverQuiz
• Quorum Reads and WritesQuiz
• Connection PoolingQuiz
• Backup and Disaster RecoveryQuiz
• 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
• Polyglot PersistenceQuiz
• Two-Phase CommitQuiz
• Vertical vs Horizontal PartitioningQuiz
• OLTP vs OLAPQuiz
• ACID Properties ExplainedSlides / Video
• SQL vs NoSQL Trade-offsSlides / Video
• NoSQL Database TypesSlides / Video
• Consistency ModelsFlashcard
• Data Warehouses, Lakes, and Object StorageFlashcard
• NoSQL Database FundamentalsFlashcard
• ACID PropertiesFlashcard
• Normalization vs DenormalizationFlashcard
• Resharding and Data RebalancingFlashcard
• Database Replication FundamentalsFlashcard
• Replication Lag and Its ConsequencesFlashcard
• Distributed Transactions and 2PCFlashcard
• OLTP vs OLAP WorkloadsFlashcard
• Relational (SQL) Database FundamentalsFlashcard
• NoSQL Data Model TypesFlashcard
• PACELC TheoremFlashcard
• Synchronous vs Asynchronous ReplicationFlashcard
• Leader Election and FailoverFlashcard
• Shard Key Selection and HotspotsFlashcard
• Master-Master ReplicationFlashcard
• Polyglot PersistenceFlashcard
• Database Connection PoolingFlashcard
• Quorum-based Reads and WritesFlashcard
• Vertical PartitioningFlashcard
• Sharding StrategiesFlashcard
• Database IndexingFlashcard
• CAP TheoremFlashcard
• BASE PropertiesFlashcard
• SQL vs NoSQL Trade-offsFlashcard
• Caching Layer for DatabasesFlashcard
• Relational Database Fundamentals and SchemaSlides / Video