EncartaLabs

CA ERwin Data Modeler - Data Modeling Practices

( Duration: 4 Days )

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

  • General understanding of data modeling concepts

  • Data Architects
  • Data Administrators
  • Database Administrators

COURSE AGENDA

1

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
2

Build a Logical Data Model

  • Create entities, attributes, and keys
  • Create relationships
  • Verify your actions
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
4

Reverse‐Engineer and Validate a Data Model

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

Present a Data Model

  • Create subject areas and ER diagrams
  • Use the ODBC reporting functions
  • Create Crystal Reports
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
7

Apply Transformations

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

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 4,000 Modules 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 http://encartalabs.com/course-catalogue-all.php

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

Top