Call : (+91) 968636 4243
Mail :

CA ERwin Data Modeler - Data Modeling Practices

( Duration: 4 Days )

In CA ERwin Data Modeler - Data Modeling Practices training course, you will discover the capabilities of CA Erwin Data Modeler. You will learn to build and reverse-engineer logical and physical data models. In addition, you will validate, present, and refine data models. You will apply transformations 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 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, delegates 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

  • General understanding of data modeling concepts

  • Data Architects
  • Data Administrators
  • Database Administrators



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

  • 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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.