Data Modelling Training

Data Modelling Online Training

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


Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message