Student iPortal Login | Create an Account | Browse Our Course Catalog | Menu

Search

Training That Changes Your Life

We've helped hundreds of people just like you get back to work. Attend our seminar to learn how to get the grants to pay for training.
Register now for this free two-hour class

About MicroTrain

MicroTrain Technologies gives you the computer skills and knowledge you need by applying the perfect combination of expert hands-on instruction, superior customer service and convenient training locations.

Course Schedule | Information

Price: Instructor Led $2500 | Virtual Classroom  -Call for details

Details: *This is a 4 day course

Description

In this course, you will discover the capabilities of AllFusion ERwin Data Modeler (AllFusion ERwin DM). You will build and reverse-engineer logical and physical data models. In addition, you will validate, present, and refine data models. You will apply transforms, and manage Data Definition Language (DDL) scripts and database schemas. You will create user-defined domains (UDDs), which make it easier to reuse, maintain, and create attributes for your data models. After you have completed the course, you will be able to create data models for undocumented schemas and translate normalized logical data models into performance-oriented, physical data models.

Highlights

Discover the capabilities of AllFusion ERwin DM

Build and reverse-engineer logical and physical data models

Validate, present, and refine data models

Apply transforms and generate DDL scripts and database schemas

Audience

Data Architect

Data Administrator

Database Administrator

Prerequisites

This course does not require a prerequisite

Outline

Day 1

Module 1 - Explain Data Modeling Methodology and Concepts

Apply Data Modeling Concepts

Identify Supported Data Models

Review the AllFusion ERwin DM Case Study

Module 2 - Build a Logical Data Model

Create Entities, Attributes, and Keys

Create Relationships

Verify Your Actions

Day 2

Module 3 - Build a Physical Data Model

Compare Physical and Logical Data Models

Edit Table Properties

Edit Column Properties

Assign Database Views

Create Indexes

Calculate Volumetrics

Module 4 - Reverse-Engineer and Validate a Data Model

Create a Data Model from an Existing System
Validate the Data Model

Day 3

Module 5 - Present a Data Model

Create Subject Areas and Stored Displays

Create Reports with the Data Browser

Create Reports with the Report Template Builder

Module 6 - Refine a Data Model

Resolve One-To-Many Relationship Issues

Resolve Many-To-Many Relationship Issues

Construct Generalization Hierarchies

Create User-Defined Domains

Create Data Model Templates

Day 4

Module 7 - Apply Transforms

Apply Transform Concepts

Create Transforms

Module 8 - Generate and Synchronize Database Schemas

Enforce Referential Integrity and Support Business Rules

Generate a Schema Using Forward Engineering

Synchronize a Data Model and a Database

1-888-737-8512

200 W. Adams St, Suite 410
Chicago, IL 60606
Tel: 312.628.9200
Fax: 312.628.9210

720 E. Butterfield Rd, Suite 100
Lombard, IL 60148
Tel: 630.981.0200
Fax: 630.981.0210

770 Lake Cook Rd, Suite 200
Deerfield, IL 60015
Tel: 847.572.0600
Fax: 847.572.0610

• Individual Training
• Corporate Training
• Case Managers Portal
• Student Portal
• Room Reservations

• Privacy Policy