All Forums Data Modeling
21cssindia1 0 posts Joined 09/13
29 Sep 2013
Data Modeling Online Training Call Us +919000444287

Data Modeling Online Training

Click Here For Enquiry

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


You must sign in to leave a comment.