Jump to content

Data Modelling Online Training | Training -3092003848


davidjhon21

Recommended Posts

Best Online Training Providers by Real Time Experts on Data Modelling Erwin

Course Outline:

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

Erwin Tool: The Information Management Solution

  • Database Design Made Easy
  • Implement Enterprise-wide Design Standards
  • ERwin’s Benefits
  • CA Modeling Suite Manages Application Development

The Premier Model Solution At Your Fingertips

  • How Do I Use ERwin?
  • Before You Begin
  • Target Databases Supported by ERwin

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

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?

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

Build Reports On Your ERwin Models

  • Learn What Report Builder Can Do

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

Indexing and Partitioning Strategy using Erwin Tool and SQL Database

 

Data-Modelling-Online-Training.jpg

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...