Day 1
Preface - Course Logistics, Agenda and Participant Introductions
Logical Data Modeling – Concepts
Chapter 1) What is Data Modeling? Picture This!
> Logical Data Modeling Definition and Benefits
> Data Modeling Basics: The Tools of the Trade
> What is Metadata? And Why Do We Care?
> Entities
> Attributes
> Business Rules
> A Logical Introduction to Keys (more later…)
> Primary, Alternate & Inversion Entry
>Relationships
Chapter 2) Gathering Information for the Data Model
> Modeling in the Real World
> The Data Modeling Team
> The Interview Process
> The Group Facilitated Session (GFS)
> What are we going to analyze?
> The Business Case Study
Chapter 3) It’s All in the Details – Let’s Have a GFS!
> Our Business Case Study
> Determine & Define Entities, Attributes & Keys
> Determine & Define Relationships
> A Word About User Defined Properties (UDPs)
> Definition & Benefits
> Suggestions, Anyone?
Chapter 4) Now That You Know The Basics - Advanced Concepts
> Unification & Rolenaming of Keys
> Recursive Relationships (Have We Been Here Before?)
> Resolving Many to Many Relationships (Like in Life)
> Supertypes & Subtypes (Generalization Hierarchies)
> Referential Integrity
> Normalizing The Model (Not the Modelers)
Day 2
Using ERwin™ – Logically Speaking
Chapter 5) Getting Started - Building an ERwin Model
> ERwin™ Navigation: Getting around town
> The Lay of the Land –
> The Model Explorer
> The ‘Undo Redo’ Window
> The Workspace
> Drop Down & Popup Menus
> Model Settings & Notation
> A Visit to the Toolbox
> The Editors
> Building and Documenting the GFS Material
> Creating Entities, Attributes & Keys
> Logical Domains & Properties
> Creating Relationships
> Creating UDPs
Chapter 6) Communication is Everything: Logically Organizing & Displaying the Model
> Subject Areas
> Custodianship, Business Areas & ‘Work Spaces’
> Stored Displays
> Diagram Enhancement Tips
> Color & Font
> Drawing & Alignment Options
Chapter 7) The Ability to Meaningfully Document and Report
> Determining Documentation Standards
> The Benefit of Consistent Deliverables
> Creating Command UDPs
> The Data Browser
> Creating Standardized, Customized & UDP Reports
> Exporting Options
> Printing Models
>The Report Template Builder
>Talk About Output!
Day 3
Chapter 8) Advanced Concepts – Let’s Get Some Resolution!
> Validating Keys - Unification & Rolenaming
> Building Recursive Relationships
> Evaluating and Resolving ‘Many to Many(s)’
>Determining & Building Supertypes & Subtypes (Generalization Hierarchies)
> Logical Transforms
> Many-to-Many
Using ERwin™ – Let’s Get Physical
Chapter 9) Logical? Physical? - What’s The Difference?
> Physical Data Design Basics: A Mirror Image (at the beginning)
> Logical vs. Physical Objects
> Let’s Talk About:
> Columns
> Tables
> Indexes
> Referential Integrity (Remember the Business Rules?)
> Preparing the Model for Database Creation
> Transforms
> Many to Many
> Supertype/Subtype Identity
> Validation Rules
Chapter 10) Forward Engineering – Giving Your Model a Promotion
> What’s Forward Engineering?
> Physical Transforms
> Supertype/Subtype Rollup/Rolldown
> Creating A Database from an ERwin™ Model
> Schema Generation Options
> Validating the Script
> Generating The Database
Day 4
Chapter 11) Reverse Engineering – Making Friends With Your Databases
> What’s Reverse Engineering?
> Do It With a Catalogue!
> Do It With a Script!
> Analyzing the Re-engineered Model: Making Sense of it All
> Using ERwin™ Domains
> Validating Standards
> Using ERwin™ Macros
> Synchronizing
> ERwin™’s Complete Compare
Chapter 12) Database Views – The Art of Perspective
> What a View!
> Creating A Database View
> Modifying the View
> Synchronizing the Model With the View
Getting Your Money’s Worth
Chapter 13) Best Practices - Suggestions for a successful modeling effort
> The Big Picture: An Enterprise Wide View
> Methods, Standards & Procedures
> Model Reviews
> Logical Model Validation & Quality Assurance
> Physical Model Validation & Quality Assurance
> Logical & Physical Models – Keep The Link
> Creating A Structured Environment – Let ERwin™ Help
> Design Layers: Establish Your Model Environment
> Maintenance: We’re Back to Standards & Procedures!
> Splitting Logical/Physical Models
> Deriving Models
> Model Sources
> Consistency! Reusability! Standards!
> The Naming Standards Editor
> The Datatype Standards Editor
Epilogue: Be Careful Out There
> Closing Remarks
> Evaluations
> Certificates
Optional Course Chapters
Chapter 14) The Database Administrator’s World (DBA: Life on the Other Side)
> The Finer Points of Referential Integrity
> ERwin™ RI Templates
> Customizing Triggers
> Stored Procedures
> Pre & Post Scripts
> Physical Transforms
> Denormalization
> Partitioning
> Volumetrics
Chapter 15) Dimensional Modeling
> So You Want A Data Warehouse?
> Basic Concepts
> Building a Star Schema Diagram