Data Modelling Online Training

[onlineandhra]

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