Mahamudul Hasan Rubel
All Courses
beginner Databases

Database Design: Data Modeling & Normalization Basics

Master Database Design from scratch — data modeling & normalization basics.

47 lessons 8 available ~31 min total
Start the course

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. 1

    Introduction to Database Design

    4 min
  2. 2

    Requirements Gathering for SaaS

    4 min
  3. 3

    Defining Entities and Attributes

    3 min
  4. 4

    Understanding Relationships

    4 min
  5. 5

    Introduction to ERD Notation

    4 min
  6. 6

    Mapping SaaS Users and Accounts

    4 min
  7. 7

    Designing Subscription Models

    4 min
  8. 8

    Refining the Conceptual Model

    4 min
  9. 9

    Logical vs Physical Schema

    Coming soon
  10. 10

    Primary Keys and Identifiers

    Coming soon
  11. 11

    Foreign Keys and Relationships

    Coming soon
  12. 12

    Constraints and Data Integrity

    Coming soon
  13. 13

    Setting Up the SQL Environment

    Coming soon
  14. 14

    Implementing the User Table

    Coming soon
  15. 15

    Implementing Subscription Tables

    Coming soon
  16. 16

    Introduction to Normalization

    Coming soon
  17. 17

    First Normal Form (1NF) Basics

    Coming soon
  18. 18

    Applying 1NF to the SaaS Schema

    Coming soon
  19. 19

    Normalization Review and Trade-offs

    Coming soon
  20. 20

    Handling Many-to-Many Relationships

    Coming soon
  21. 21

    Implementing Roles and Permissions

    Coming soon
  22. 22

    Advanced Subscription Modeling

    Coming soon
  23. 23

    Designing for Scalability

    Coming soon
  24. 24

    Refactoring for Query Efficiency

    Coming soon
  25. 25

    CRUD Operations and Schema Testing

    Coming soon
  26. 26

    Understanding Indexes

    Coming soon
  27. 27

    Primary Key Indexing

    Coming soon
  28. 28

    Designing Composite Indexes

    Coming soon
  29. 29

    Index Maintenance and Trade-offs

    Coming soon
  30. 30

    Auditing Schema Performance

    Coming soon
  31. 31

    Handling Large Data Sets

    Coming soon
  32. 32

    Schema Versioning Basics

    Coming soon
  33. 33

    Implementing Migrations

    Coming soon
  34. 34

    Finalizing the SaaS Database Architecture

    Coming soon
  35. 35

    Database Documentation

    Coming soon
  36. 36

    Security Fundamentals in Design

    Coming soon
  37. 37

    Handling Soft Deletes

    Coming soon
  38. 38

    Data Archiving Strategies

    Coming soon
  39. 39

    Modeling Audit Trails

    Coming soon
  40. 40

    Implementing Time-Series Data

    Coming soon
  41. 41

    Database Normalization vs Denormalization

    Coming soon
  42. 42

    Entity Lifecycle Management

    Coming soon
  43. 43

    Database Backup and Recovery

    Coming soon
  44. 44

    Designing for Multi-tenancy

    Coming soon
  45. 45

    Analyzing Query Complexity

    Coming soon
  46. 46

    Refactoring for Feature Expansion

    Coming soon
  47. 47

    Database Maintenance Plans

    Coming soon