Databases Roadmap

Note: Not all questions may match a certain category on the roadmap.

Relational Databases and Database Design
Concepts
Relational model (entities, attributes, relationships)
Database schema design principles
Indexing strategies
SQL
Concepts
Basic SQL
Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL)
JOINs (inner, outer, etc.), subqueries, functions, triggers, stored procedures
NoSQL Databases
Concepts
Document databases
Key-value stores
Graph databases
Wide-column stores
NoSQL consistency
NoSQL Data Modeling
Concepts
NoSQL Data Modeling Techniques
BASE Properties
Data Integrity
Concepts
Referential integrity
Data constraints
Validation
Views and Materialized Views
Concepts
Views and Materialized Views
Database Internals
Concepts
Storage engines (B-trees, LSM-trees)
Query execution plans
Transaction management
Locking mechanisms
Buffer management
SQL Performance Tuning
Concepts
SQL Performance Tuning
Database Administration
Concepts
Performance monitoring and tuning
Security and access control
Backups and recovery
Replication and high availability
Data Warehousing
Concepts
Basics of data warehousing
OLAP vs. OLTP systems
ETL processes
Database Security
Concepts
In-depth focus on encryption
SQL injection prevention
Secure database design
Data Replication
Concepts
Deep dive into replication strategies
Database Testing
Concepts
Effectively test databases
Unit testing
Integration testing
Advanced SQL Techniques
Concepts
Window functions
Common table expressions (CTEs)
Recursive queries
Cloud-Based Database Services
Concepts
Overview of cloud database offerings
AWS RDS, Google Cloud SQL
Real-Time Data Processing
Concepts
Basics of stream processing
Kafka
Real-time analytics