Section 1 : Welcome
Lecture 1 Welcome 00:03:29 Duration
Lecture 2 About This Course 00:03:21 Duration

Section 2 : Data Modeling Fundamentals
Lecture 1 Introduction to Data Modeling Fundamentals 00:01:09 Duration
Lecture 2 The Purpose and Role of Data Modeling 00:08:13 Duration
Lecture 3 Basic Data Modeling Concepts and Terminology 00:10:19 Duration
Lecture 4 Navigate Your Alternatives Among Methodologies, Techniques, and Notations
Lecture 5 Compare Data Modeling to Database Design 00:04:18 Duration
Lecture 6 Compare Transactional Data Modeling to Analytical Data Modeling 00:05:09 Duration
Lecture 7 Summarize Data Modeling Fundamentals

Section 3 : The Building Blocks of Data Modeling
Lecture 1 Introducing Data Modeling Building Blocks 00:00:37 Duration
Lecture 2 The Role of Entities in Data Modeling 00:05:02 Duration
Lecture 3 Add Attributes to Your Data Model 00:08:39 Duration
Lecture 4 Use Multi-Valued Attributes in Your Data Model 00:05:43 Duration
Lecture 5 Build Relationships into Your Data Model 00:07:04 Duration
Lecture 6 Summarize Data Modeling Building Blocks 00:00:32 Duration

Section 4 : Add Real-World Complexities to Entities and Attributes
Lecture 1 Why Real-World Complexities Matter in Data Modeling 00:01:07 Duration
Lecture 2 Build Hierarchies for the Entities in Your Data Model 00:09:50 Duration
Lecture 3 Specify Constraints for Your Attributes 00:09:59 Duration
Lecture 4 Specify Cross-Entity Dependencies Through Strong and Weak Entities 00:07:42 Duration
Lecture 5 Summarize Real-World Entity and Attribute Complexities 00:01:01 Duration

Section 5 : Add Real-World Complexities to Relationships
Lecture 1 Why Relationship Cardinality and Complexities Matter 00:01:33 Duration
Lecture 2 Build Real-World Complexities into Data Model Relationships 00:09:46 Duration
Lecture 3 Define the Maximum Cardinality of a Relationship 00:06:43 Duration
Lecture 4 Define the Minimum Cardinality of a Relationship 00:07:48 Duration
Lecture 5 Use Crow's Foot Notation for Minimum and Maximum Cardinality
Lecture 6 Summarize Cardinality and Complex Relationships

Section 6 : Move Across the Different Levels of a Data Model
Lecture 1 Harmonize Different Levels of a Data Model 00:01:05 Duration
Lecture 2 A Brief Look at Relational Database Normalization 00:09:56 Duration
Lecture 3 Forward-Engineering Your Conceptual Data Model
Lecture 4 More Data Model Forward-Engineering 00:07:44 Duration
Lecture 5 Reverse-Engineer a Physical Model Back into a Conceptual Model 00:07:39 Duration
Lecture 6 Summarize How to Work with Different Levels of a Data Model 00:00:37 Duration

Section 7 : Software for Data Modeling
Lecture 1 The Importance of Data Modeling Software 00:00:39 Duration
Lecture 2 Build a Data Model with a Drawing Program 00:05:24 Duration
Lecture 3 Build a Model with a Data Modeling Software Tool 00:07:11 Duration