Erwin is a software tool for data modeling (data requirements analysis, database design etc.) Of custom developed information systems, including databases of transactional systems and data marts. Erwin’s data modeling engine is based upon the IDEF1X method, although it now supports diagrams displayed with information engineering notation as well.
About Erwin
Prerequisites
Knowledge of Logical/physical modeling
Course Content
DATA MODELING CONCEPTS
ERWIN: THE INFORMATION MANAGEMENT SOLUTION
Database Design Made Easy
Implement Enterprise-wide Design Standards
Erwin’s Benefits
CA Modeling Suite Manages Application Development
THE PREMIER MODEL SOLUTION AT YOUR FINGERTIPS
Erwin Overview and Installation Information
How Do I Use Erwin?
Before You Begin
Target Databases Supported by Erwin
Before You Install Erwin
Erwin’s Easy Installation Procedure
ERWIN’S NEW AND ADVANCED FEATURES
Introducing Product Enhancements
What’s New in Erwin?
What’s New in Erwin 7.3 or later?
Flexible Support of Multiple Model Types
Adaptable Menu Structure
The Model Explorer
What Can You Do In The Model Explorer?
Using the Model Explorer Context Menu
Model Pane
Subject Areas Pane
Domains Pane
Dockable Toolbars
Erwin Toolbox
Selecting, Moving, and Resizing Objects
Alignment, Spacing, and Grouping Tools
Drawing Tools
JUMP START YOUR DATA DESIGN PROCESS
Use Existing Data to Build a New Model
Reverse Engineering
Using the Reverse Engineer Wizard
Using Erwin’s Complete Compare
What’s next?
PUTTING ERWIN TO WORK
Working With Data Models
What Is an Entity?
What Is an Attribute?
What Is a Relationship?
What Is a Foreign Key?
Creating a Data Model
Enhance Your Data Model
Splitting a Logical/Physical Data Model
Derive a New Model
Forward Engineering
What’s next?
BUILD REPORTS ON YOUR ERWIN MODELS
Learn What Report Builder Can Do
USING ERWIN’S ADVANCED FEATURES
Working with Design Layers
What Is a Design Layer?
Other Design Layer Hierarchies
Creating New Design Layers
Creating New Design Layers
Splitting a Model
Deriving a Model
Adding a Model Source
What Is A Transform?
Transform Toolbar
Applying Transforms
Expected Transform Results
Transforms and the Model Explorer
Resolving and Reversing Transforms
Synchronizing Changes between Design Layers
Preserving Model History
How to design Dimensional Model using Erwin Training
ETL Rules using CA Erwin Data Modeler
Call Now- +91-921-276-0556
