Home / Course catalog / Dimensional and ER Data Modeling Video Tutorial-2...

Data Modeling

Dimensional and ER Data Modeling Video Tutorial-2026


Description
Video Duration : 30 hours
Quizes : ( 100+ Questions)
ONE Mock Test ( 40 questions)
ONE Month Video View Access.
PDF Material for each topic can be downloaded.
Content
  • Data Modeling Introduction
  • Importance of Data Modeling and Data Modelers Role ( 3 mins)
  • Data Modeling "what , why, when ,how " Factors (22 mins)
  • Data Modeling Introduction - Slides
  • Data Modeling Introduction - Quiz
  • Data Warehousing - Concepts
  • Under standing OLTP, OLAP , Differentiating wrt Requirements. (25 mins)
  • Datawarehousing Concepts ( 32 mins)
  • Data Warehousing Concepts - Quiz
  • Requirements Gathering - Data Model
  • Requirements Phase Importance (3 mins)
  • Building Dimensional Modelling -Requirements Gathering (37 mins)
  • TOP Down and Bottom UP Approach - Case Study ( 5 mins)
  • TOP Down and Bottom UP Approach -Part 2 (7 mins)
  • Why Separate Design Patterns (18 mins)
  • Banking Enterprise - Case Study -1
  • Second - Case Study
  • Building a Dimensional Model_Requirement Gathering- Slides
  • Requirement Gathering - Quiz
  • Erwin Tool Introduction
  • Learner Expectations on ERwin Tool ( 12 mins)
  • ERwin Tool Introduction (30 mins)
  • Erwin Tool Introduction - Slides
  • Erwin Tool Introduction - Quiz
  • ERwin Tool Alternatives -For practising sample
  • Draw-io Free Design Tool -Conceptual Model Purpose (Erwin Alternative) sample
  • DB Diagram - Erwin Alternative (Reference) sample
  • Erwin Tool Installation
  • Erwin Tool Installation ( 3 mins)
  • Erwin Installation - Slides
  • Erwin Installation - Quiz
  • Building a Data Model in Erwin
  • Building a Data Model ( 11 mins)
  • Building a Data Model - Slides
  • Create Entity ( 1 min)
  • Building a Data Model - Quiz
  • Erwin Tool bars and windows
  • Erwin Toolbars and Windows (47 mins)
  • Subject Areas ( 17 mins)
  • Diagrams and Themes in Erwin (10 mins)
  • Working with Erwin Tool - slides
  • Diagrams and Themes - Slides
  • Domains in Erwin Tool
  • Working with Domains (10 mins)
  • Domains - Slides
  • Working with Erwin Tool - Quiz
  • Dimensions In Detail
  • Dimensions (60 mins)
  • Slowly Changing Dimensions-SCD (19 mins)
  • SCD -Quiz Discussion( 8 mins)
  • Hybrid Dimensions (8 mins)
  • Fast Changing Dimension-FCD and Junk or Garbage dimension (24 mins)
  • Degenerate Dimension ( 6 mins)
  • Conformed and Static and Role Playing Dimension (15 mins)
  • Role Playing Dimensions in ERwin (5 mins)
  • Dimensions Basic - Part-1- slides
  • Dimensions Basic - Part-2- slides
  • Dimensions - Quiz
  • Facts
  • Facts-Concept (13 mins)
  • Facts-Types (fully Additive,Non Additive,Semi Additive (23 mins)
  • Facts-Less Fact in Erwin(24 mins)
  • Facts -Slides
  • Facts - Quiz
  • Sample Data
  • Real Time Data -Dimensions and Facts (13 mins)
  • Grain and Hierarchy
  • Grain - Concept (12 mins)
  • Grains - Concept - slides
  • Grains -Multiple slides
  • Hierarchies Balanced /Unbalanced/Ragged (20 mins)
  • Hierarchies - slides
  • Grains and Hierarchies- Quiz
  • Schema Patterns
  • Star Schema (10 mins)
  • SnowFlake Schema ( 22 mins)
  • Schema Patterns - Slides
  • Schema Patterns - Quiz
  • Data Modeling Examples
  • Dimensional Modeling Examples (11 mins)
  • FAQ Videos
  • FAQ on Facts and Dimensions - (47 mins)
  • Data Abstraction
  • Conceptual ,Logical ,Physical Models (24 mins)
  • Conceptual Logical Physical Model - slides
  • Data Abstraction - Quiz
  • Enforcing Business Rules in Erwin
  • Constraints in Erwin ( 25 mins)
  • Default Values and Logical /Physical Only ( 16 mins)
  • Constraints in Erwin - Slides
  • Business Rules in erwin - Quiz
  • DMDL
  • Dimension Model Design Life Cycle -DMDL (4 mins)
  • Dimensional model life cycle- DMDL - Slides
  • DMDL- Quiz
  • Forward and Reverse Engineering
  • Forward Engineering (26 mins)
  • Reverse Engineering (12 mins)
  • Forward and Reverse Engineering - Slides
  • Forward and Reverse Engineering - Quiz
  • Naming Standards - Erwin
  • Model Naming Options (12 mins)
  • Naming Standards Editor (27 mins)
  • Import glossary from CSV file (2 mins)
  • Name Hardening in Detail ( 11 mins)
  • Naming Standards - Slides
  • Naming Standards - Quiz
  • Data type Standards
  • Data Type Standards - Detail (29 mins)
  • Data Type Standards- Brief (3 mins)
  • Data Type Standards - Slides
  • Data Type Standards - Quiz
  • Data Modeling Standards - Sample Documents
  • Data Modelling Standards- Sample Document
  • Data Modeling - Best Practices
  • Comparison of Models
  • Complete Compare Feature (26 mins)
  • Comparison of Models- slides
  • Complete Compare - Quiz
  • Querying and Report Generation
  • Query Tool -Detailed (8 mins)
  • Query Tool - Brief (4 mins)
  • Bulk Editor (9 mins)
  • Generating Diagram Pictures (5 mins)
  • Report Designer (12 mins)
  • Querying and Reporting in Erwin - Slides
  • Querying and Reporting in Erwin - Quiz
  • Validating Data Model
  • Validating Data Model ( 16 mins)
  • Validating Data Model - Slides
  • Validating Data Model - Quiz
  • Inmon Vs Kimbal Approach
  • Inmon Vs Kimbal Approach (11 mins)
  • Inmon vs Kimball Approach - Slides
  • Relationship and Cardinality
  • Relationship Types - ( 9 mins)
  • Cardinality and Degree - ( 32 mins)
  • Identifying and Non-Identifying Relationships (11 mins)
  • Relationship Types - Slides
  • Relationship and Cardinality - Quiz
  • Normalization Concepts
  • Need of Normalization ( 10 mins)
  • First Normalization -1NF ( 10 mins)
  • Second and Third Normal Forms (13 mins)
  • Normalization -Example ( 16 mins)
  • Normalization - Case Study Discussion and Quiz (15 mins)
  • Primary key and Other Keys (17 mins )
  • Foreign Keys (5 min)
  • Surrogate Keys (19 mins)
  • Case study for Normalization
  • Normalization- slides
  • Normalization - Quiz
  • Using Erwin Help / Data Modeling References
  • Using Erwin Help (3 mins)
  • Reference Material Information
  • Reference Material Future reading on DataModel (8 mins)
  • Dimensional Modeling Examples (11 mins)
  • Additional Videos
  • How to "Add Audit Columns" in "ERwin Tool" ( 6 mins)
  • How to "Add Audit Columns" using Forward Engineering Template (8 mins)
  • Split Model ( 3 mins)
  • Derive Model ( 4 mins)
  • Split Model and Derive Model - slides
  • Add Model Source( 3 mins)
  • Dimensional modeling features (3 mins)
  • Export Import Formats in Erwin( 5 mins)
  • Vertical Partitioning in ERwin ( 11 mins)
  • Demo Videos
  • ERwin 15ai AI Feature - STOP Modeling Data Manually! sample
  • Generating Diagrams pictures in ERwin Tool ( 5 mins) sample
  • Erwin Tool Installation ( 3 mins) sample
  • Data Modeling - Career Option ( 2 mins) sample
  • Data Modeling Demo (25 mins) sample
  • Erwin Tool Demo ( 5 mins) sample
  • Data Modeling Interview Questions ( 2 mins) sample
  • Designing Hive Tables in Erwin ( 6 mins) sample
  • Import table metadata using api in erwin ( 5 mins) sample
  • Testimonial on ERwin Training  sample
  • FAQ / Interview Questions
  • Data Modeling - Interview Questions  sample
  • Job Winning Data Modelling Strategies sample
  • Mock Tests -Test Your Knowledge (40 Questions)
  • Mock Test -1
Completion rules
  • All units must be completed