Databases Roadmap

What is a database?

ACID properties

Relational model (entities, attributes, relationships)

Normalization (1NF, 2NF, 3NF, BCNF)

Data types and constraints

Basics of Query Optimization

Database schema design principles

Indexing strategies

Transaction Isolation Levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable) and impact on concurrent transactions.

Eventual consistency, conflict resolution

Basic SQL

Data Definition Language (DDL), Data Manipulation Language (DML), Data Query Language (DQL)

JOINs (inner, outer, etc.), subqueries, functions, triggers, stored procedures

Document databases

Key-value stores

Graph databases

Wide-column stores

NoSQL consistency

MongoDB Architecture

NoSQL Data Modeling Techniques

BASE Properties

Referential integrity

Data constraints

Validation

Views and Materialized Views

Storage engines (How tables and indexes are stored on disk)

Row-Based vs Column-Based Databases

Primary Key vs Secondary Key - What you probably didn't know

Database Pages

Query execution plans

Transaction management

Locking mechanisms

Buffer management

Sharding, replication, data consistency in distributed systems

Horizontal vs. vertical scaling, load balancing

Indexing strategies, query optimization techniques

Denormalization, materialized views, caching strategies

Understanding the importance of data governance

Compliance with regulations like GDPR, HIPAA