Relational Database Design

This course is for anyone who wants to understand relational database design, or data modeling in general. You will learn how to gather requirements, model them, normalize the model, and transform that model into a fully normalized relational database design.
Course info
Rating
(355)
Level
Intermediate
Updated
Jan 6, 2014
Duration
7h 33m
Table of contents
Introduction
ER Modeling
Gathering Information
Creating The Initial ER Model
Converting to Relational
Basic Normalization - Part 1
Basic Normalization - Part 2
Higher Normal Forms
Other ER Methods
Description
Course info
Rating
(355)
Level
Intermediate
Updated
Jan 6, 2014
Duration
7h 33m
Description

In this course, you will learn all the skills required to design good databases. This starts with information gathering: how to find all required information, and how to ask questions without miscommunications. You will learn how to abstract the information gathered into a data model, how to normalize the data model so that your database will be free of anomalies, and how to transform the final, normalized data model into a relational database design - ready to be implemented.

About the author
About the author

SQL Server MVP Hugo Kornelis is co-founder and R&D lead of perFact BV. He develops analysis methods and tools to generate completely functional SQL Server applications from the analysis. Hugo also likes to visit internet forums, read and write books and blogs as well as speak at conferences.