TRAINING

Enroll Now

Data Modeler Training  

In CA ERwin Data Modeler - Data Modeling Practices training course, Participants will discover the capabilities of CA Erwin Data Modeler. They will build and reverse-engineer logical and physical data models. In addition, they will validate, present, and refine data models. They will apply transformations and manage data definition language (DDL) scripts and database schemas.

They will create user-defined domains (UDDs), which make it easier to reuse, maintain, and create attributes for their data models. After they have completed the course, they will be able to create data models for undocumented schemas and translate normalized logical data models into performance-oriented, physical data models.

By attending CA ERwin Data Modeler - Data Modeling Practices workshop, Participants will learn to:

• Discover the capabilities of CA ERwin Data Modeler
• Build and reverse-engineer logical and physical data models
• Validate, present, and refine data models
• Apply transformations and generate DDL scripts and database schemas

Audience

• Data Architects
• Data Administrators
• Database Administrators

Data Modeler Course Content

Explain Data Modeling Methodology and Concepts

• Apply data modeling concepts
• Identify supported data models
• Explain the role of the RBC case study in this course

Build a Logical Data Model

• Create entities, attributes, and keys
• Create relationships
• Verify your actions

Build a Physical Data Model

• Compare physical and logical data models
• Edit table properties
• Edit column properties
• Assign database views
• Create indexes
• Calculate volumetrics

Reverse‐Engineer and Validate a Data Model

• Create a data model from an existing system
• Validate the data model

Present a Data Model

• Create subject areas and ER diagrams
• Use the ODBC reporting functions
• Create Crystal Reports

Refine a Data Model

• Designer
• Resolve one-to-many relationship issues
• Resolve many-to-many relationship issues
• Construct generalization hierarchies
• Create user-defined domains
• Create data model templates

Apply Transformations

• Apply transformation concepts
• Execute transformations
• Create a column link

Generate and Synchronize Database Schemas

• Enforce referential integrity and enforce business rules
• Generate a schema using FE
• Synchronize a data model and a database