CA ERwin Data Modeler - Data Modeling Practices Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

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

CA ERwin Data Modeler - Data Modeling Practices

COURSE AGENDA