Erwin Tool Online Training Course Content

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!
• How Do I Use Erwin?
• Before You Begin
• Target Databases Supported by Erwin

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

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?

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

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

Indexing and Partitioning Strategy using Erwin Tool and SQL Database