Relational Database Design Bootcamp

Project Based Approach to Mastering Database Design. Conceptual Modeling, Database Relationships, Normalization and More

What you'll learn

Design a relational database from scratch.

Understand and implement database relationships.

Learn what database normalization is and why we need it for good database design.

Master more advanced database concepts such as indexes and views.

Data modeling for structured data.

Understand how to improve data integrity and data reliability.

Requirements

No prior knowledge of databases or SQL is needed.

Description

Master the fundamentals of relational database design in this hands-on, project-based bootcamp. Learn to build efficient, scalable databases using database relationships, normalization, ER diagrams, and best practices. Perfect for beginners and aspiring data professionals. Enroll today to boost your data skills!This course takes a project based approach to learning database design. We begin from scratch and each section builds knowledge of different aspects of database design. Each section has a mini-project to solidify the concepts learnt. Finally we tie this all together in a final project where we apply everything we have learned in the course to design a database for a music streaming application.Relational database design skills remain highly relevant in 2025 for several key reasons:Ubiquity of Structured DataDespite the rise of NoSQL and other data storage paradigms, most business-critical data is still structured and fits well into relational models — think customer records, financial transactions, inventories, etc. Relational databases (RDBMSs) like PostgreSQL, MySQL, and Microsoft SQL Server continue to power thousands of enterprise systems.Foundations for Other TechnologiesRelational design concepts like normalization, keys, and constraints form the core foundation for understanding data modeling in general, even in modern hybrid systems or when working with ORM tools in application development.Longevity and InteroperabilityRelational databases are decades-old yet still dominant. Knowing how to design them means you can work across legacy systems, modern microservices, and even cloud-native environments — a critical skill in environments where systems need to interoperate.Demand in the Job MarketIn 2025, companies continue to list relational database skills (SQL, schema design, normalization) as core requirements for software engineers, data analysts, and data engineers. The demand hasn't disappeared — it’s simply evolved.Relational database design is a timeless skill. In 2025, it's not just about writing SQL — it's about understanding how to model data effectively, optimize performance, ensure data quality, and future-proof systems in increasingly hybrid tech environments.In this bootcamp you will learn everything you need to design efficient and reliable relational databases. By the end of this course you will understand:Relational databases and table structure. Why good database design is important and the steps to database design. Data modeling using conceptual models and entity-relationship diagrams. The different types of database relationships and how they are implemented. Key relational database concepts such as data integrity, data reliability and data redundancy. The different data types, keys, constraints and indexes used in relational databases. Database normalization and why databases should conform to at least third normal form.A final project where you will bring all of this together to design a relational database for a music streaming service.No prior knowledge of databases, SQL or coding is needed to take this course as we begin from scratch. Enroll today to boost your data skills!

Overview

Section 1: Welcome to the Course

Lecture 1 Welcome to the Course

Section 2: Introduction to Database Design

Lecture 2 Introduction to Database Design

Lecture 3 Relational Databases Explained

Lecture 4 Table Structure in Relational Databases

Lecture 5 Database Design Objectives

Lecture 6 Steps to Database Design

Lecture 7 Conceptual Data Modelling

Lecture 8 Entity Relationship Diagrams (ERD)

Section 3: Database Relationships

Lecture 9 Database Relationships Introduction

Lecture 10 Database Relationships Explained

Lecture 11 Primary Keys

Lecture 12 Foreign Keys

Lecture 13 One to One Relationships

Lecture 14 One to Many Relationships

Lecture 15 Many to Many Relationships

Lecture 16 Self Referencing Relationships

Lecture 17 Mini Project: Database Relationships

Lecture 18 Mini Project: Modeling the Core Data

Lecture 19 Mini Project: Modeling Playlist Functionality

Lecture 20 Mini Project: Modeling Library Functionality

Section 4: Keys, Constraints, Data Types, Views and Indexes

Lecture 21 Introduction to Keys, Constraints, Data Types, Views and Indexes

Lecture 22 Common Data Types

Lecture 23 Keys

Lecture 24 Constraints

Lecture 25 More Data Types

Lecture 26 Database Views

Lecture 27 Database Indexes

Section 5: Database Normalization

Lecture 28 Database Normalization Introduction

Lecture 29 Database Normalization Explained

Lecture 30 First Normal Form

Lecture 31 Second Normal Form

Lecture 32 Third Normal Form

Lecture 33 Boyce-Codd Normal Form (BCNF)

Lecture 34 Mini Project: Database Normalization

Lecture 35 Mini Project: First Normal Form

Lecture 36 Mini Project: Second Normal Form

Lecture 37 Mini Project: Third Normal Form

Section 6: Project: Dotify

Lecture 38 Project Dotify Explained

Lecture 39 Project Dotify: First Step

Lecture 41 Project Dotify: Second Step

Lecture 42 Project Dotify: Second Step Walkthrough

Section 7: Appendix: Software Installation and Setup

Lecture 43 Visual Studio Code Installation and Setup

Lecture 44 Basic VS Code and Draw IO Extension User Guide

Section 8: Bonus Material

Lecture 45 Referal Codes

Developers curious to improve their relational database skills.,Data Engineers, Business Analysts or Database Designers looking to improve their data modeling skills.