Duration: 30 Days
- 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
|
