Home / Course catalog / Erwin Tool

Data Modeling

Erwin Tool


Description
ERwin Tool Is used for ER Data Modeling and Dimensional Modeling.
Videos : 12 Hours
Quizes : 50 Questions ( one Hour)
What we cover :
Introduction to Erwin Tool
Installation and configuration of Erwin and Notation
Creation of Entities and attributes
Creation of Relationships, Degree, Cardinality
Understanding constraints (PK,FK) in Erwin tool
Creation of Domains , Default Values, Validation rules
Creating Diagrams, Themes
Creating Conceptual model
Creating Logical model
Creating Physical model
Creating Subject area model
Generating Scripts from Physical Model
Naming standards Implementation
Datatype Standards Implementation
Building reports and Printing in erwin
Forward Engineering
Reverse Engineering
Complete compare of models/schema
Bulk Editor
Generating diagram in Picture format
Vertical Partitioning in Erwin
Excel import into Erwin using erwin api/macros


ONE Month Video View Access.

Contact info@dbvidya.com

+91 991 2323000


www.dbvidya.com

www.dbvidya.com/blog
Content
  • Erwin - Introduction
  • Learner Expectations on ERwin Tool ( 12 mins)
  • ERwin Tool Introduction (30 mins)
  • Erwin Tool Introduction - Slides
  • Erwin Tool Introduction - Quiz
  • Erwin Tool Software and Installation
  • Erwin Tool Installation ( 3 mins)  sample
  • Erwin Installation - Slides  sample
  • Erwin Installation - Quiz
  • Building a Data Model
  • Building a Data Model ( 11 mins)
  • Building a Data Model - Slides
  • Create Entity ( 1 min)
  • Building a Data Model - Quiz
  • Working with ERwin Tool
  • Erwin Toolbars and Windows (47 mins)
  • Subject Areas ( 17 mins)
  • Working with Erwin Tool - slides
  • Working with Domains (10 mins)
  • Domains - Slides
  • Diagrams and Themes in Erwin (10 mins)
  • Diagrams and Themes - Slides
  • Working with Erwin Tool - Quiz
  • Business Rules in Erwin
  • Default Values Logical /Physical Only ( 16 mins)
  • Constraints in Erwin ( 25 mins)
  • Constraints in Erwin - Slides
  • Business Rules in erwin - Quiz
  • Relationships 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
  • Data Abstraction Layers
  • Conceptual ,Logical ,Physical Models (24 mins)
  • Conceptual Logical Physical Model - Slides
  • Data Abstraction - 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 for DataModel
  • 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
  • Complete Compare Feature
  • 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
  • Additional Information - Erwin Tool
  • 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)
  • Export Import Formats in Erwin( 5 mins)
  • Dimensional modeling features (3 mins)
  • Vertical Partitioning in ERwin ( 11 mins)
  • Erwin Help and Future Reading
  • Using Erwin Help (3 mins)
  • Reference Material Information
  • Demo /Sample Videos
  • Erwin Tool Course Contents List sample
  • Erwin Tool Demo ( 5 mins) sample
  • Generating Diagrams and Pictures ( 5 mins) sample
  • Erwin Tool Installation ( 3 mins) sample
  • Designing Hive Tables in Erwin  sample
  • Import table metadata using api in erwin ( 5 mins) sample
  • Testimonial on ERwin Training sample
  • FAQ/ Interview Questions
  • Data Modeling Interview Questions -Video sample
  • Data Modeling - Interview Questions sample
Completion rules
  • All units must be completed