Relational Database Design (2014)-0daytown

Relational Database Design (2014)

WMV | VC-1 384kbps | English | 1024×768 | 15fps | 7h 33mins | WMA2 stereo 192kbps | 1.53 GB

Genre: Video Training

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. 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.

│ relational-database-design.zip
│
├───01. Introduction
│ 01. Outline.wmv
│ 02. Development of Storage Hardware.wmv
│ 03. Database Technologies.wmv
│ 04. The Relational Model.wmv
│ 05. Data Modeling.wmv
│ 06. Summary.wmv
│ 07. References.wmv
│
├───02. ER Modeling
│ 01. Outline.wmv
│ 02. ER Modeling (overview).wmv
│ 03. Entity Types.wmv
│ 04. Attributes.wmv
│ 05. Relationships.wmv
│ 06. Identifying Relationships.wmv
│ 07. Special Relationships (1).wmv
│ 08. Special Relationships (2).wmv
│ 09. Special Relationships (3).wmv
│ 10. Subtypes.wmv
│ 11. Summary.wmv
│ 12. References.wmv
│
├───03. Gathering Information
│ 01. Outline.wmv
│ 02. Introduction.wmv
│ 03. Analyzing a Mission Statement.wmv
│ 04. Interviews.wmv
│ 05. Counter Examples.wmv
│ 06. Summary.wmv
│
├───04. Creating The Initial ER Model
│ 01. Outline.wmv
│ 02. Generalizing Fact Types.wmv
│ 03. Finding Entity Types.wmv
│ 04. Identifying Fact Types.wmv
│ 05. Entity Types.wmv
│ 06. Attributes.wmv
│ 07. Relationships.wmv
│ 08. Artificial Entity Types.wmv
│ 09. Summary.wmv
│
├───05. Module 5 – Converting to Relational
│ 01. Outline.wmv
│ 02. Different Representations.wmv
│ 03. Representing a Relational Design.wmv
│ 04. ER to Relational Entity Types.wmv
│ 05. ER to Relational Candidate Keys.wmv
│ 06. ER to Relational One-to-many Relationships.wmv
│ 07. ER to Relational Many-to-many Relationships.wmv
│ 08. ER to Relational Other Constraints.wmv
│ 09. ER to Relational Demo.wmv
│ 10. Relational to ER First Draft.wmv
│ 11. Relational to ER Variations.wmv
│ 12. Relational to ER Demo.wmv
│ 13. Summary.wmv
│
├───06. Basic Normalization – Part 1
│ 01. Outline.wmv
│ 02. Why Normalize .wmv
│ 03. Functional Dependencies.wmv
│ 04. First Normal Form.wmv
│ 05. Find Functional Dependencies 1 Are Candidate Keys Minimal.wmv
│ 06. Find functional Dependencies 2 Missing Candidate Keys.wmv
│ 07. Demo Verify that Attributes are Atomic.wmv
│ 08. Demo Verify that Candidate Keys are Minimal.wmv
│ 09. Demo Check for Missing Candidate Keys.wmv
│ 10. Summary.wmv
│
├───07. Basic Normalization – Part 2
│ 01. Outline.wmv
│ 02. Second Normal Form.wmv
│ 03. Find Functional Dependencies 3 Dependencies on Subsets of Keys.wmv
│ 04. Demo Dependencies on Subsets of Candidate Keys.wmv
│ 05. Third Normal Form.wmv
│ 06. Find Functional Dependencies 4 Verify Third Normal Form.wmv
│ 07. Demo Verify Third Normal Form.wmv
│ 08. Summary.wmv
│ 09. References.wmv
│
├───08. Higher Normal Forms
│ 01. Outline.wmv
│ 02. Boyce-Codd Normal Form and Elementary Key Normal Form.wmv
│ 03. Fourth Normal Form.wmv
│ 04. Fifth Normal Form.wmv
│ 05. Domain Key Normal Form.wmv
│ 06. Sixth Normal Form and Optimal Normal Form.wmv
│ 07. Denormalization.wmv
│ 08. Standard Solutions for Non-standard Patterns.wmv
│ 09. Summary.wmv
│ 10. References.wmv
│
└───09. Module 9 – Other ER Methods
01. Outline.wmv
02. Many Methods.wmv
03. Entity Types.wmv
04. Attributes.wmv
05. Relationships.wmv
06. Crow’s foot Notation.wmv
07. Special Relationships.wmv
08. Summary.wmv