Database Design Introduction
Prevent typical developer mistakes by learning how to properly create and normalize a relational database.
This course familiarizes the student with techniques necessary to
properly create and normalize a relational database. This single
course can help prevent the new database developer from creating
mistakes that add hours and days to a development project.
Information in this course is a must for anyone responsible for
building and maintaining a database.
Basic Microsoft Windows training or equivalent experience.
Who is this course intended for?
Students just getting start with designing databases and those who have been designing databases but looking for tips on more effective design.
StartWhat is Normalization? (2:16)
StartBasic Steps to Normalization (4:38)
StartA. Brainstorm (1:08)
StartB. Organize (3:12)
StartC. Eliminate Repetition (11:33)
StartD. Assign Relationships (0:22)
StartD1. One to One Relationship (6:00)
StartD2. One to Many Relationship (4:19)
StartD3. Many to Many Relationship (5:29)
StartRelating Tables with IDs (1:46)
StartExamples of Bad Design (15:19)
StartExamples of Good Design (5:52)
StartDesign Rules (5:09)