Database Design Crash Course

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

Fundamental Concepts
Concepts
What is a Database? ->
Database Management Systems (DBMS) ->
DB Characteristics and Real-World Examples ->
Types of Databases ->
Database Classifications ->
Data Modeling
Concepts
Introduction to Data Models
Schemas and Instances
Data Independence
Entity-Relationship Data Model
Concepts
Intro to Entity-Relationship Model
Entities, Entity Sets and Entity Types
Attributes
Keys
Relationships, Relationship Sets and Relationship Types
The Relational Data Model
Concepts
The Relational Model
Introduction to Database Keys
Integrity Rules and Constraints
Relational Database Schemas
Normalization and Optimization
Concepts
Functional Dependencies
Normalization
Understanding Database Indexes
Query Execution Plans
Basic Query Optimization Techniques
ACID Properties and Transaction States
Concepts
ACID Properties: Atomicity, Consistency, Isolation, Durability
Transaction States and Isolation Levels