Data Modelling Online Training

[cssadhar]

Chapter 1: Data Modeling Concepts

Data Modeling Development Cycle

Data Modeling Standards

Steps to Create a Data Model

Data Modeler Role

Enterprise Data Modeling

Conceptual Data Modeling

Logical Data Modeling

Physical Data Modeling

Data Modeling Reports using Erwin (Also covered in chapter 7)

Logical V/s Physical Data Modeling

Relational Data Modeling / OLTP

Dimensional Data Modeling / OLAP

Slowly Changing Dimensions / Different Types of SCD

Relationships

Data Model Versioning 

Chapter 2: Erwin Tool: The Information Management Solution!

Database Design Made Easy

Implement Enterprise-wide Design Standards

ERwin's Benefits

CA Modeling Suite Manages Application Development 

Chapter 3: The Premier Model Solution At Your Fingertips!

How Do I Use ERwin?

Before You Begin

Target Databases Supported by ERwin 

Chapter 4: ERwin's New And Advanced Features!

Introducing Product Enhancements

What's New In ERwin?

What's New In ERwin 7.3 or later?

Flexible Support Of Multiple Model Types

Adaptable Menu Structure

The Model Explorer

What Can You Do In The Model Explorer?

Using The Model Explorer Context Menu

Model Pane

Subject Areas Pane

Domains Pane

Dockable Toolbars

ERwin Toolbox

Selecting, Moving, and Resizing Objects

Alignment, Spacing, And Grouping Tools

Drawing Tools

Chapter 5: Putting ERwin To Work!

Working With Data Models

What Is An Entity?

What Is An Attribute?

What Is A Relationship?

What Is A Foreign Key?

Creating A Data Model

Enhance Your Data Model

Splitting A Logical/Physical Data Model

Derive A New Model

Forward Engineering

What's Next? 

Chapter 6: Jump Start Your Data Design Process!

Use Existing Data To Build A New Model

Reverse Engineering

Using The Reverse Engineer Wizard

Using ERwin's Complete Compare 

Chapter 7: Build Reports On Your ERwin Models!

Learn What Report Builder Can Do 

Chapter 8: Using ERwin's Advanced Features!

Working With Design Layers

What Is A Design Layer?

Other Design Layer Hierarchies

Creating New Design Layers

Creating New Design Layers

Splitting A Model

Deriving A Model

Adding a Model Source

What Is A Transform?

Transform Toolbar

Applying Transforms

Expected Transform Results

Transforms And The Model Explorer

Resolving And Reversing Transforms

Synchronizing Changes Between Design Layers

Preserving Model History

How to design Dimensional Model using Erwin

Chapter 9: Indexing and Partitioning Strategy using Erwin Tool and SQL Database

 

Contact Us:309-200-3848