SWE Quiz
Learn
Questions
Open main menu
Databases Roadmap
Note: Not all questions may match a certain category on the roadmap.
Database Fundamentals
Concepts
What is a database?
Database Types (SQL, NoSQL, NewSQL, Vector, etc.) ->
Pros/cons and use cases of various databases ->
Relational Databases and Database Design
Concepts
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
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
MongoDB Architecture
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 (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