Back to Topics

Databases

Understand ACID properties, indexing, transactions, replication, and database design.

ACID Properties

Read →

Master ACID properties to understand transaction guarantees. Critical for database interviews and system design discussions.

Intermediate12 min

Columnar Databases

Read →

Master columnar databases for analytics and data warehousing. Essential for big data and analytics system design interviews.

Senior18 min

Data Replication

Read →

Master database replication strategies for high availability and performance. Essential for distributed systems and database interviews.

Intermediate18 min

Document Stores

Read →

Master document-oriented databases like MongoDB. Essential for NoSQL and modern database design interviews.

Intermediate16 min

Indexing

Read →

Master database indexing to dramatically improve query performance. Essential for database optimization interviews.

Intermediate12 min

Isolation Levels

Read →

Master transaction isolation levels to balance consistency and concurrency. Essential for database and system design interviews.

Intermediate18 min

Key-Value Stores

Read →

Master key-value stores like Redis for caching and high-performance data access. Essential for system design interviews.

Beginner12 min

Normalization

Read →

Master database normalization to eliminate redundancy and improve data integrity. Essential for database design interviews.

Intermediate15 min

NoSQL Basics

Read →

Master NoSQL database fundamentals and when to choose them over relational databases. Essential for modern system design interviews.

Intermediate20 min

Partitioning

Read →

Master table partitioning to improve query performance and manageability. Essential for large-scale database design interviews.

Senior20 min

Query Optimization

Read →

Master query optimization techniques to improve database performance. Critical skill for database and backend engineering interviews.

Intermediate15 min

SQL Joins

Read →

Master SQL joins to combine data from multiple tables efficiently. Essential for relational database queries and interview success.

Beginner8 min

Time-Series Databases

Read →

Master time-series databases for metrics, logs, and IoT data. Essential for observability and monitoring system design interviews.

Intermediate20 min

Transactions

Read →

Master database transactions to ensure data consistency and reliability. Critical for database and system design interviews.

Beginner10 min