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
• Vertical vs Horizontal PartitioningQuiz
• Choosing a Shard KeyQuiz
• Cross-Shard QueriesQuiz
• Resharding ChallengesQuiz
• Indexing and Query PerformanceQuiz
• Relational Model and RelationshipsQuiz
• Polyglot PersistenceQuiz
• Backup and Disaster RecoveryQuiz
• Synchronous vs Asynchronous ReplicationQuiz
• Schema-on-Read vs Schema-on-WriteQuiz
• Normalization vs DenormalizationQuiz
• CAP Theorem BasicsQuiz
• Replication LagQuiz
• OLTP vs OLAPQuiz
• Connection PoolingQuiz
• Multi-Master ReplicationQuiz
• BASE and Eventual ConsistencyQuiz
• Partition Tolerance and FailoverQuiz
• Two-Phase CommitQuiz
• NoSQL Data ModelsQuiz
• Quorum Reads and WritesQuiz
• ACID TransactionsQuiz
• ACID Properties ExplainedSlides / Video
• SQL vs NoSQL Trade-offsSlides / Video
• NoSQL Database TypesSlides / Video
• PACELC TheoremFlashcard
• Distributed Transactions and 2PCFlashcard
• Quorum-based Reads and WritesFlashcard
• Leader Election and FailoverFlashcard
• Shard Key Selection and HotspotsFlashcard
• NoSQL Data Model TypesFlashcard
• Polyglot PersistenceFlashcard
• Vertical PartitioningFlashcard
• Master-Master ReplicationFlashcard
• Resharding and Data RebalancingFlashcard
• Caching Layer for DatabasesFlashcard
• Database Connection PoolingFlashcard
• Synchronous vs Asynchronous ReplicationFlashcard
• ACID PropertiesFlashcard
• OLTP vs OLAP WorkloadsFlashcard
• CAP TheoremFlashcard
• SQL vs NoSQL Trade-offsFlashcard
• Normalization vs DenormalizationFlashcard
• Consistency ModelsFlashcard
• Data Warehouses, Lakes, and Object StorageFlashcard
• Sharding StrategiesFlashcard
• Database IndexingFlashcard
• BASE PropertiesFlashcard
• Relational (SQL) Database FundamentalsFlashcard
• NoSQL Database FundamentalsFlashcard
• Database Replication FundamentalsFlashcard
• Replication Lag and Its ConsequencesFlashcard
• Relational Database Fundamentals and SchemaSlides / Video