Dimensional Modeling and ER Data Modelling Video Tutorial
-
Job Winning Data Modelling Strategies
- Data Modeling Introduction
- Importance of Data Modeling and Data Modelers Role...
- Data Modeling "what , why, when ,how " Factors (2...
- Data Modeling Introduction - Slides
- Data Modeling Introduction - Quiz
- Data Warehousing - Concepts
- Under standing OLTP, OLAP , Differentiating wrt ...
- Datawarehousing Concepts ( 32 mins)
- Data Warehousing Concepts - Quiz
- OLTP vs OLAP - Slides
- OLTP vs OLAP -Quiz
- Requirements Gathering - Data Model
- Requirements Phase Importance (3 mins)
- Building Dimensional Modelling -Requirements Gathe...
- TOP Down and Bottom UP Approach - Case Study ( 5...
- 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...
- 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
- Draw-io Free Design Tool -Conceptual Model Purpose...
- DB Diagram - Erwin Alternative (Reference)
- 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 di...
- Degenerate Dimension ( 6 mins)
- Conformed and Static and Role Playing Dimension (1...
- 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 Addi...
- 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 m...
- 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 ...
- 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...
- 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 ...
- Dimensional Modeling Examples (11 mins)
- ER Data Modeling Concepts
- Building a ER Data Model -Requirements Gathering ...
- Collecting Requirements wrt Case study ER (18 mins...
- Banking and HR Case Study- ER Requirements (5 min...
- Entities and Attributes and Case Study ( 42 mins...
- Entities - Slides
- Attributes - Slides
- Entities and Attributes - Quiz
- RELATIONSHIPS - TYPES
- Unary , Binary, Ternary Relationships-Degree of Re...
- Identifying,Non Identifying,Sub Type/Super Type,Re...
- Relationships -Introduction - slides
- Relationship Types -In Detail - slides
- Relationship Types - Quiz
- ER Modeling Examples ( 5 mins)
- ER Data Modeling Examples- Slides
- Additional Videos
- How to "Add Audit Columns" in "ERwin Tool" ( 6 min...
- How to "Add Audit Columns" using Forward Engineer...
- 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 Manuall...
- Generating Diagrams pictures in ERwin Tool ( 5 mi...
- Erwin Tool Installation ( 3 mins)
- Data Modeling - Career Option ( 2 mins)
- Data Modeling Demo (25 mins)
- Erwin Tool Demo ( 5 mins)
- Data Modeling Interview Questions ( 2 mins)
- Designing Hive Tables in Erwin ( 6 mins)
- Import table metadata using api in erwin ( 5 mins)
- Testimonial on ERwin Training
- FAQ / Interview Questions
- Data Modeling - Interview Questions
- Job Winning Data Modelling Strategies
- Mock Tests -Test Your Knowledge (40 Questions)
- Mock Test -1
- Course info
