AllFusion® ERwin® Data Modeler: Model Architecture Practices and Standards

Overview:

In this course, you will gain the knowledge and skills necessary to implement and manage data models using the AllFusion ERwin Data Modeler (AllFusion ERwin DM). Using advanced data modeling features like Complete Compare and synchronization, you will learn how to create and maintain design layers that model data flexibly. Applying the AllFusion ERwin macro language, you will create code for reusable prescripts and postscripts, custom triggers and custom stored procedures. You will also work through an implementation of modeling standards to create models with a consistent look and feel.

Description:

Who Should Attend:

Data Administrator

Database Administrator

Data Architect

Prerequisites:

AllFusion ERwin Data Modeler: Effective Data Modeling Practices (EM115) (ILT) (4 days)

Minimum of 12 months data modeling experience with AllFusion ERwin DM

You Will Learn How To:

Implement design layer architecture

Implement naming and datatype standards

Create reports

Compare and synchronize models

Implement the AllFusion ERwin DM macro language

Course Activities:

Case studies

Demonstrations

Hands-on exercises

Recommended Next Courses:

AllFusion ERwin Data Modeler: Dimensional Modeling (ERL15) ( Web Instructor-Led Live )

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

For Managers:

The AllFusion ERwin Data Modeler: Model Architecture Practices and Standards course will help improve team performance and m aximize your investment. Working in a classroom setting under the expert guidance of a Computer Associates-certified instructor, your team will build the essential skills necessary to create and manage data models flexibly using design layers. Students will implement modeling standards to establish consistency. Additionally, they will create reusable code for prescripts and postscripts, custom triggers and custom-stored procedures with the AllFusion ERwin macro language.

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 – Implement Design Layer Architecture

Plan Design Layer Architecture

Apply Design Layer Architecture

Module 2 – Implement Naming and Datatype Standards

Develop Data Model Naming Standards

Implement Datatype Standards

Day 2

Module 3 – Create Reports

Create Reports with the Report Template Builder

Share Report Templates

Module 4 – Compare and Synchronize Models

Compare Models Using Complete Compare

Synchronize Models

Module 5 – Implement the AllFusion ERwin DM Macro Language

 Implement AllFusion ERwin DM Macros

Implement Prescripts and Postscripts

Implement Basic Referential Integrity

Day 3

Module 5 – Implement the AllFusion ERwin DM Macro Language (continued)

Create Custom Templates

Implement Stored Procedures