65 items
Choosing Storage for Different Data Types
Slides / VideoCaching Layers for Data Storage
Slides / VideoData Consistency Models Explained
Slides / VideoVertical vs Horizontal Partitioning
Slides / VideoResharding and Consistent Hashing
Slides / VideoShard Key Selection and Hotspot Avoidance
Slides / VideoSynchronous vs Asynchronous Replication
Slides / VideoDatabase Replication Strategies
Slides / VideoDatabase Indexing and Query Performance
Slides / VideoNormalization vs Denormalization
Slides / VideoCAP Theorem Explained
Slides / VideoBASE and Eventual Consistency
Slides / VideoTwo-Phase Commit
QuizRelational Model and Relationships
QuizNoSQL Data Models
QuizACID Transactions
QuizBASE and Eventual Consistency
QuizNormalization vs Denormalization
QuizSchema-on-Read vs Schema-on-Write
QuizIndexing and Query Performance
QuizChoosing a Shard Key
QuizResharding Challenges
QuizCross-Shard Queries
QuizMulti-Master Replication
QuizSynchronous vs Asynchronous Replication
QuizReplication Lag
QuizCAP Theorem Basics
QuizPartition Tolerance and Failover
QuizQuorum Reads and Writes
QuizVertical vs Horizontal Partitioning
QuizPolyglot Persistence
QuizOLTP vs OLAP
QuizBackup and Disaster Recovery
QuizConnection Pooling
QuizACID Properties Explained
Slides / VideoSQL vs NoSQL Trade-offs
Slides / VideoNoSQL Database Types
Slides / VideoDistributed Transactions and 2PC
FlashcardLeader Election and Failover
FlashcardShard Key Selection and Hotspots
FlashcardMaster-Master Replication
FlashcardData Warehouses, Lakes, and Object Storage
FlashcardPolyglot Persistence
FlashcardDatabase Connection Pooling
FlashcardQuorum-based Reads and Writes
FlashcardConsistency Models
FlashcardVertical Partitioning
FlashcardSharding Strategies
FlashcardDatabase Indexing
FlashcardCAP Theorem
FlashcardBASE Properties
FlashcardSQL vs NoSQL Trade-offs
FlashcardResharding and Data Rebalancing
FlashcardDatabase Replication Fundamentals
FlashcardReplication Lag and Its Consequences
FlashcardOLTP vs OLAP Workloads
FlashcardRelational (SQL) Database Fundamentals
FlashcardNoSQL Data Model Types
FlashcardPACELC Theorem
FlashcardSynchronous vs Asynchronous Replication
FlashcardCaching Layer for Databases
FlashcardNoSQL Database Fundamentals
FlashcardACID Properties
FlashcardNormalization vs Denormalization
FlashcardRelational Database Fundamentals and Schema
Slides / VideoTwo-Phase Commit
The two phases of the 2PC distributed transaction protocol.
In two-phase commit (2PC), what happens in the first phase?