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: Concepts, Trade-offs & Interview Use Cases
Read →Master ACID properties to understand transaction guarantees. Critical for database interviews and system design discussions.
Transactions: Concepts, Trade-offs & Interview Use Cases
Read →Master database transactions to ensure data consistency and reliability. Critical for database and system design interviews.
Isolation Levels: Concepts, Trade-offs & Interview Use Cases
Read →Master transaction isolation levels to balance consistency and concurrency. Essential for database and system design interviews.
Normalization: Concepts, Trade-offs & Interview Use Cases
Read →Master database normalization to eliminate redundancy and improve data integrity. Essential for database design interviews.
SQL Joins: Concepts, Trade-offs & Interview Use Cases
Read →Master SQL joins to combine data from multiple tables efficiently. Essential for relational database queries and interview success.
Indexing: Concepts, Trade-offs & Interview Use Cases
Read →Master database indexing to dramatically improve query performance. Essential for database optimization interviews.
Query Optimization: Concepts, Trade-offs & Interview Use Cases
Read →Master query optimization techniques to improve database performance. Critical skill for database and backend engineering interviews.
Partitioning: Concepts, Trade-offs & Interview Use Cases
Read →Master table partitioning to improve query performance and manageability. Essential for large-scale database design interviews.
Data Replication: Concepts, Trade-offs & Interview Use Cases
Read →Master database replication strategies for high availability and performance. Essential for distributed systems and database interviews.
NoSQL Basics: Concepts, Trade-offs & Interview Use Cases
Read →Master NoSQL database fundamentals and when to choose them over relational databases. Essential for modern system design interviews.
Key-Value Stores: Concepts, Trade-offs & Interview Use Cases
Read →Master key-value stores like Redis for caching and high-performance data access. Essential for system design interviews.
Document Stores: Concepts, Trade-offs & Interview Use Cases
Read →Master document-oriented databases like MongoDB. Essential for NoSQL and modern database design interviews.
Columnar Databases: Concepts, Trade-offs & Interview Use Cases
Read →Master columnar databases for analytics and data warehousing. Essential for big data and analytics system design interviews.
Time-Series Databases: Concepts, Trade-offs & Interview Use Cases
Read →Master time-series databases for metrics, logs, and IoT data. Essential for observability and monitoring system design interviews.