AllFusion® ERwin® Data Modeler: Effective Data Modeling Practices

Overview:

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.

Description:

Who Should Attend:

Data Architect
Data Administrator
Database Administrator 

Prerequisites:

AllFusion ERwin Data Modeler: Data Modeling Concepts (LW100) (ILT) (1 day) 

Optional:

AllFusion ERwin Data Modeler: Data Modeling Concepts (LWL10) (WILL) (6 hours)
General understanding of data modeling concepts 

You Will Learn How To:

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 

Course Activities:

Case studies
Demonstrations
Hands-on exercises 

Recommended Next Courses:

AllFusion ERwin Data Modeler: Model Architecture Practices and Standards (EM125) (ILT) (3 days)
And

AllFusion Model Manager: Collaborated Model Management in a Secure Environment (EM135) (ILT) (2 days) 

For Managers:

This course will help maximize your investment in AllFusion Data Modeler: Effective Data Modeling Practices software by giving your administrators and architects the skills necessary to communicate business requirements. By providing them with effective data modeling practices, they will be able to represent and document your data structures and business rules. They will be able to build logical models, target starting points for schema generation using physical models, and create graphic and text-based reports. This course will also enable your team to increase its productivity and improve output by creating model subsets and UDDs . Finally, your team will be able to generate DDL scripts from physical models and ensure that both physical models and database schemas are properly synchronized through the Complete Compare feature.

CA Education and Training strives to be your preferred source for enterprise IT management education and best practices training solutions that deliver measurable results and a rewarding learning experience.   Our training is designed to ease ramp-up time. We work to ensure your overall satisfaction with CA products and service.   We appreciate your business.

Course Agenda:
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