Databases
Understand ACID properties, indexing, transactions, replication, and database design.
Data-related failures—wrong consistency guarantees, missing indexes, or replication lag—often surface late and cost dearly. At senior levels, interviewers and peers probe whether you actually understand isolation, durability, and scale, not just vocabulary.
These topics build a rigorous mental model of how data is stored, queried, and replicated: when to choose SQL vs NoSQL, how indexing and partitioning affect behavior, and which trade-offs are unavoidable. You'll learn to design schemas, diagnose issues under real constraints, and explain your decisions clearly in production and in interviews.
Topics in this category
ACID Properties
Read →Master ACID properties to understand transaction guarantees. Critical for database interviews and system design discussions.
Data Replication
Read →Master database replication strategies for high availability and performance. Essential for distributed systems and database interviews.
Columnar Databases
Read →Master columnar databases for analytics and data warehousing. Essential for big data and analytics system design interviews.