Database Design: Data Modeling & Normalization Basics
Master Database Design from scratch — data modeling & normalization basics.
What you'll learn
By the end you can confidently apply Database Design at a beginner level: data modeling & normalization basics, with real, working code.
Who it's for
Developers learning Database Design at a beginner level.
Prerequisites
Basic SQL.
A structured, hands-on beginner course on Database Design, taking you from scratch by building a data model for a SaaS product.
Curriculum
- 1
Introduction to Database Design
4 min - 2
Requirements Gathering for SaaS
4 min - 3
Defining Entities and Attributes
3 min - 4
Understanding Relationships
4 min - 5
Introduction to ERD Notation
4 min - 6
Mapping SaaS Users and Accounts
4 min - 7
Designing Subscription Models
4 min - 8
Refining the Conceptual Model
4 min - 9
Logical vs Physical Schema
4 min - 10
Primary Keys and Identifiers
4 min - 11
Foreign Keys and Relationships
4 min - 12
Constraints and Data Integrity
4 min - 13
Setting Up the SQL Environment
4 min - 14
Implementing the User Table
4 min - 15
Implementing Subscription Tables
4 min - 16
Introduction to Normalization
5 min - 17
First Normal Form (1NF) Basics
4 min - 18
Applying 1NF to the SaaS Schema
4 min - 19
Normalization Review and Trade-offs
4 min - 20
Handling Many-to-Many Relationships
3 min - 21
Implementing Roles and Permissions
3 min - 22
Advanced Subscription Modeling
4 min - 23
Designing for Scalability
3 min - 24
Refactoring for Query Efficiency
4 min - 25
CRUD Operations and Schema Testing
4 min - 26
Understanding Indexes
4 min - 27
Primary Key Indexing
4 min - 28
Designing Composite Indexes
4 min - 29
Index Maintenance and Trade-offs
Coming soon - 30
Auditing Schema Performance
Coming soon - 31
Handling Large Data Sets
Coming soon - 32
Schema Versioning Basics
Coming soon - 33
Implementing Migrations
Coming soon - 34
Finalizing the SaaS Database Architecture
Coming soon - 35
Database Documentation
Coming soon - 36
Security Fundamentals in Design
Coming soon - 37
Handling Soft Deletes
Coming soon - 38
Data Archiving Strategies
Coming soon - 39
Modeling Audit Trails
Coming soon - 40
Implementing Time-Series Data
Coming soon - 41
Database Normalization vs Denormalization
Coming soon - 42
Entity Lifecycle Management
Coming soon - 43
Database Backup and Recovery
Coming soon - 44
Designing for Multi-tenancy
Coming soon - 45
Analyzing Query Complexity
Coming soon - 46
Refactoring for Feature Expansion
Coming soon - 47
Database Maintenance Plans
Coming soon