About Erwin

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.

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

Send a Query









Tai Infotech Pvt Ltd, 2017 All Rights Reserved