Database Design Fundamentals

Course details

Understanding how to design databases effectively can be a game-changer—both for your current work and for your future career. In this course, get an overview of why database design is essential. Instructor Melody Zacharias covers the different types of designs—OLAP and OLTP—then expands on and explains why OLTP is the focus of the course. Melody then details the different normal forms and why they are essential—and when you use them and when you do not.

Then, once you have a solid base, explore entities and attributes, primary keys, and how they are designed. Plus, learn about naming conventions and data types, which are important for design as they can affect the physical size of the structure. Melody also explains how developments in AI affect database design, then guides you through a final project to bring everything you’ve learned together.

Concepts

0. Introduction

01 - AI-ready data - Learning database design for success
02 - What you should know

1. Database Design Basics

03 - Types of relational databases
04 - Database schemas
05 - Entity relationship diagrams
06 - Relational database design basics

2. Data Relationships and Collations

07 - Determining primary keys
08 - Different data relationships
09 - Collation and character sets

3. Data Normalization

10 - First normal form
11 - Second normal form
12 - Third normal form
13 - Normalization from BCNF to 6NF

4. Understanding the Physical Relational Design

14 - Data types that are key to relational databases
15 - How rows and columns impact database design
16 - Types of relationships
17 - Defining primary keys
18 - Automatically increment a field
19 - The importance of foreign keys
20 - What is a null
21 - Naming convention importance in relational databases

5. How Developments in AI Affect Database Design

22 - Architectural overview for AI
23 - Designing for AI
24 - Considerations for AI - Unstructured data and analytics

6. Final Project

25 - Final project setup - Design your own database
26 - Final project walkthrough - Design your own database

Conclusion

27 - Empower your world - Innovate, act, transform