Jump to content

Data Modelling Online Training


georgejackson

Recommended Posts

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: 001-309-200-3848

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...