Relational Database Design
Pluralsight
Course Summary
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 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.
-
+
Course Syllabus
Introduction- 32m 12s
—Outline 1m 15s
—Development of Storage Hardware 9m 58s
—Database Technologies 10m 41s
—The Relational Model 6m 19s
—Data Modeling 2m 50s
—Summary 1m 1s
—References 0m 5sER Modeling- 51m 55s
—Outline 0m 38s
—ER Modeling (overview) 3m 37s
—Entity Types 3m 9s
—Attributes 5m 35s
—Relationships 9m 12s
—Identifying Relationships 4m 51s
—Special Relationships (1) 4m 17s
—Special Relationships (2) 4m 58s
—Special Relationships (3) 5m 57s
—Subtypes 7m 1s
—Summary 2m 29s
—References 0m 5sGathering Information- 33m 24sCreating The Initial ER Model- 46m 37sConverting to Relational- 1h 5mBasic Normalization - Part 1- 1h 20mBasic Normalization - Part 2- 57m 59sHigher Normal Forms- 53m 40sOther ER Methods- 31m 44s