Entity Relationship Data Modeling
Data Modeling Interview Questions ( 2 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
×
Course info
Entity Relationship Data Modeling
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
OLTP vs OLAP
Under standing OLTP, OLAP , Differentiating wrt Requirements. (25 mins)
OLTP vs OLAP - Slides
OLTP vs OLAP -Quiz
REQUIREMENTS GATHERING - DATA MODEL
Building a ER Data Model -Requirements Gathering ( 27 mins)
Building a Data Model -Steps - Slides
TOP Down and Bottom UP Approach - Case Study ( 5 mins)
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 mins)
Building a Data Model in Erwin-Steps and Notations - Slides
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 Relationship ( 18 mins)
Identifying,Non Identifying,Sub Type/Super Type,Recursive Relationships(47mins)
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 mins)
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 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 Future reading on DataModel (8 mins)
Reference Material Information
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
Generating Diagrams pictures in ERwin Tool ( 5 mins)
sample
Erwin Tool Installation ( 3 mins)
sample
Data Modeling - Career Option ( 2 mins)
sample
Erwin Tool Demo ( 5 mins)
sample
Data Modeling Interview Questions ( 2 mins)
sample
Designing Hive Tables in Erwin ( 6 mins)
sample
Data Modeling Demo (25 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
Completion rules
All units must be completed
×
Congratulations!
Course completed!
Download certificate
Continue
Go to next course
×
You didn't quite make it
Unfortunately, you didn't reach a passing score for this course
Go to course list
×
Notice
×
Notice
×
Notice