Relational Database Design
Database design principles12 H 11 M
In this series of videos, you will learn key concepts and best practices for designing a relational database in Microsoft Access for Windows machines.
Just you? Training a whole team? There's an ITProTV plan that fits.
Start Training TodayEpisodes
Episodes
- Relational Database Basics
- Overview
- History, Terms and Definitions
- History, Terms and Definitions Part 2
- Data Normalization
- Data Normalization Part 2
- Data Normalization Part 3
- Designing the Database
- Designing a Database
- Designing a Database Part 2
- Designing a Database Part 3
- Creating Models
- Creating Database Models
- Creating Database Models Part 2
- Finalizing the Model
- Data Integrity
- Entity Integrity
- Referential Integrity
- Referential Integrity Part 2
- Domain Integrity
- Domain Integrity Part 2
- Domain Integrity Part 3
- Domain Integrity Part 4
- Query Basics
- Getting Started with Queries
- Getting Started with Queries Part 2
- Getting Started with Queries Part 3
- Querying Multiple Tables
- Querying Multiple Tables Part 2
- Querying Multiple Tables Part 3
Overview
8 M



- Episode Description
- Transcript
In this series of videos, we will cover key concepts and best practices for designing a relational database. Many problems that arise in using databases can be traced back to poor initial design. We will walk through the entire design process, from initial concept, through the design phase, ending with a fully functional database. This course is not platform specific; however, some concepts are demonstrated with Access on Windows operating system.