Database Design Course Index — Dataplexa
Home › Learning Hub › Database Design
Database Design

Database Design
Course Index

35 Lessons · 4 Levels

Master database design from fundamentals to enterprise-level architecture — ER modeling, normalization, logical & physical design, indexing, scalability and security.

Start Course → ← Back to Learning Hub
35Lessons
4Levels
1Project
FreeAccess
Level I Fundamentals Lessons 1–8
Lesson 01
What is Database Design
Lesson 02
Why Database Design is Important
Lesson 03
OLTP vs OLAP Systems
Lesson 04
Types of Databases
Lesson 05
Data vs Information
Lesson 06
Entities and Attributes
Lesson 07
Keys in Database Design
Lesson 08
Introduction to Relationships
Level II Conceptual Design (ER Modeling) Lessons 9–17
Lesson 09
Conceptual vs Logical vs Physical Design
Lesson 10
Entity Relationship Model
Lesson 11
ER Diagram Symbols
Lesson 12
One-to-One Relationships
Lesson 13
One-to-Many Relationships
Lesson 14
Many-to-Many Relationships
Lesson 15
Weak Entities
Lesson 16
Cardinality & Participation
Lesson 17
ER Diagram Case Study
Level III Normalization & Logical Design Lessons 18–27
Lesson 18
What is Normalization
Lesson 19
First Normal Form (1NF)
Lesson 20
Second Normal Form (2NF)
Lesson 21
Third Normal Form (3NF)
Lesson 22
Boyce–Codd Normal Form (BCNF)
Lesson 23
Denormalization
Lesson 24
Surrogate vs Natural Keys
Lesson 25
Handling NULLs in Design
Lesson 26
Referential Integrity
Lesson 27
Logical Schema Design
Level IV Physical & Enterprise Design Lessons 28–35
Lesson 28
Physical Database Design
Lesson 29
Indexing Strategy
Lesson 30
Partitioning Concepts
Lesson 31
Designing for Performance
Lesson 32
Designing for Scalability
Lesson 33
Designing for Security
Lesson 34
Database Design for Microservices
Lesson 35
Mini Project
Ready to Start?
Database Design Course Index
Start Course → ← Back to Learning Hub