From Our Students

"I just want to let you know that your professionalism, sense of caring, and listening to the needs of someone who lost their job is deeply appreciated. The job that I now have would not have been possible had I not passed the PMP exam."

-Hector A. Fundora
Sign Up

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.

Find your classes now: Search for a class class schedule WIA-Approved Classes
Microsift Gold Partner

AllFusion® ERwin® Data Modeler: Effective Data Modeling Practices - EM115

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
  • Location Date

    Take a look at some of MicroTrain's programs to keep you on the cutting edge:

    View Complete Course List
    Course Schedules
    WIA-Approved Programs

    Individual
    Training

    Corporate
    Training

    Case Managers
    Portal

    Student
    Portal

    Room
    Reservations
    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

    You should follow us on Twitter and Facebook

    Copyright © 2010 MicroTrain Technologies. All rights reserved.

    Privacy Policy

    INC 5000 Click to verify BBB accreditation and to see a BBB report.