IIRF Online > Business > Business Analytics & Intelligence > Data Modeling > Mastering Data Modeling Fundamentals
Mastering Data Modeling Fundamentals by Udemy
Entity-Relationship Techniques and Best Practices
Course Highlights
- Master the techniques needed to build data models for your organization.
- Apply key data modeling design principles through both classic entity-relationship notation and the “crow’s foot” notation.
- Build semantically accurate data models consisting of entities, attributes, relationships, hierarchies, and other modeling constructs.
- Convert conceptual data models to logical and physical data models through forward engineering.
Skills you will learn!
Curriculum
2 Topics
Welcome
About This Course
8 Topics
Introduction to Data Modeling Fundamentals
The Purpose and Role of Data Modeling
Basic Data Modeling Concepts and Terminology
Navigate Your Alternatives Among Methodologies Techniques and Notations
Compare Data Modeling to Database Design
Compare Transactional Data Modeling to Analytical Data Modeling
Summarize Data Modeling Fundamentals
Data Modeling Fundamentals
7 Topics
Introducing Data Modeling Building Blocks
The Role of Entities in Data Modeling
Add Attributes to Your Data Model
Use Multi-Valued Attributes in Your Data Model
Build Relationships into Your Data Model
Summarize Data Modeling Building Blocks
Basic Data Modeling
6 Topics
Why Real-World Complexities Matter in Data Modeling
Build Hierarchies for the Entities in Your Data Model
Specify Constraints for Your Attributes
Specify Cross-Entity Dependencies Through Strong and Weak Entities
Summarize Real-World Entity and Attribute Complexities
Entity and Attribute Constraints
7 Topics
Why Relationship Cardinality and Complexities Matter
Build Real-World Complexities into Data Model Relationships
Define the Maximum Cardinality of a Relationship
Define the Minimum Cardinality of a Relationship
Use Crow's Foot Notation for Minimum and Maximum Cardinality
Summarize Cardinality and Complex Relationships
Assessment: Relationship Complexity and Cardinality
7 Topics
Harmonize Different Levels of a Data Model
A Brief Look at Relational Database Normalization
Forward-Engineering Your Conceptual Data Model
More Data Model Forward-Engineering
Reverse-Engineer a Physical Model Back into a Conceptual Model
Summarize How to Work with Different Levels of a Data Model
Assessment: Forward- and Reverse-Engineering
4 Topics
The Importance of Data Modeling Software
Build a Data Model with a Drawing Program
Build a Model with a Data Modeling Software Tool
Assessment: Data Modeling Software
2 Topics
Thank you for taking the course!
Additional resources for further study
Mastering Data Modeling Fundamentals
Related Data Modeling Courses
Thank You!
Your review has been submitted successfully.