67 items
Quorum Consistency Overlap Check
Code QuizQuorum Consistency in Replicated Systems
QuizChoosing 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 / VideoReplication Lag
QuizCAP Theorem Basics
QuizPartition Tolerance and Failover
QuizQuorum Reads and Writes
QuizConnection Pooling
QuizBackup and Disaster Recovery
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
QuizPolyglot Persistence
QuizTwo-Phase Commit
QuizVertical vs Horizontal Partitioning
QuizOLTP vs OLAP
QuizACID Properties Explained
Slides / VideoSQL vs NoSQL Trade-offs
Slides / VideoNoSQL Database Types
Slides / VideoConsistency Models
FlashcardData Warehouses, Lakes, and Object Storage
FlashcardNoSQL Database Fundamentals
FlashcardACID Properties
FlashcardNormalization vs Denormalization
FlashcardResharding and Data Rebalancing
FlashcardDatabase Replication Fundamentals
FlashcardReplication Lag and Its Consequences
FlashcardDistributed Transactions and 2PC
FlashcardOLTP vs OLAP Workloads
FlashcardRelational (SQL) Database Fundamentals
FlashcardNoSQL Data Model Types
FlashcardPACELC Theorem
FlashcardSynchronous vs Asynchronous Replication
FlashcardLeader Election and Failover
FlashcardShard Key Selection and Hotspots
FlashcardMaster-Master Replication
FlashcardPolyglot Persistence
FlashcardDatabase Connection Pooling
FlashcardQuorum-based Reads and Writes
FlashcardVertical Partitioning
FlashcardSharding Strategies
FlashcardDatabase Indexing
FlashcardCAP Theorem
FlashcardBASE Properties
FlashcardSQL vs NoSQL Trade-offs
FlashcardCaching Layer for Databases
FlashcardRelational Database Fundamentals and Schema
Slides / VideoOLTP vs OLAP Workloads
OLTP handles many small transactions; OLAP runs complex analytical queries.
What is the difference between OLTP and OLAP?