Data Modelling Online / Corporate Training

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?

Contact US: 201-905-1656/201-210-8616