Entity Relationship Data Modeling
-
Erwin Tool Installation ( 3 mins)
- 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
- OLTP vs OLAP
- Under standing OLTP, OLAP , Differentiating wrt ...
- OLTP vs OLAP - Slides
- OLTP vs OLAP -Quiz
- REQUIREMENTS GATHERING - DATA MODEL
- Building a ER Data Model -Requirements Gathering ...
- Building a Data Model -Steps - Slides
- TOP Down and Bottom UP Approach - Case Study ( 5...
- TOP Down and Bottom UP Approach -Part 2 (7 mins)
- Top down vs Bottom Up Approach - Slides
- Why Separate Design Patterns (18 mins)
- Banking and HR Case Study- Requirements (5 mins)
- Collecting Requirements wrt Case study (18 mins)
- Banking Enterprise - Case Study -1
- Requirements 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 Installation
- Erwin Tool Installation ( 3 mins)
- Erwin Installation - Slides
- Erwin Installation - Quiz
- Building a ER Data Model in Erwin
- Building a Data Model in ERwin and Notations ( 11 ...
- Building a Data Model in Erwin-Steps and Notation...
- Building a Data Model in Erwin - 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
- Entities and Attributes
- 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 Data Modeling Examples
- ER Modeling Examples ( 5 mins)
- ER Data Modeling Examples- Slides
- 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
- 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 Diagrams and 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
- 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 Future reading on DataModel (8 ...
- Reference Material Information
- 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
- Generating Diagrams pictures in ERwin Tool ( 5 mi...
- Erwin Tool Installation ( 3 mins)
- Data Modeling - Career Option ( 2 mins)
- Erwin Tool Demo ( 5 mins)
- Data Modeling Interview Questions ( 2 mins)
- Designing Hive Tables in Erwin ( 6 mins)
- Data Modeling Demo (25 mins)
- Import table metadata using api in erwin ( 5 mins)
- Testimonial on ERwin Training
- FAQ /Interview Questions
- Data Modeling - Interview Questions
- Course info
