Relational Data Modeling

Course:  DMA
Duration:  4 Days
Level:  I
Course Summary

This four-day instructor-led course provides both an initial high-level and then in-depth coverage of data modeling. The course begins by covering the reasons why building data models is important, notation for data models, and concludes with how data models fit into long-term business planning and what value they add. Special attention is paid throughout the course to best practices in the application of data models and data modeling techniques.

« Hide The Details
Topics Covered In This Course

Day 1

  • Course Introduction
  • Introduction to Data Modeling
  • Data Modeling and Business Needs
  • Lab: Mapping Business Needs to Data Modeling
  • Overview of Data Modeling Notation
  • Overview of Entity-Relationship Models
  • Data Modeling Notation Standards
  • Lab: Entity Relationship Models

Day 2

  • Database Fundamentals
  • Normalization
  • Understanding Keys
  • Lab: Defining Keys
  • Subtypes and Supertypes
  • Attributes and Columns
  • Best Practices for Database Attributes
  • Lab: Designing Effective Attributes

Day 3

  • Data Modeling and Business Alignment
  • Assessing the Situation
  • Gathering Requirements
  • Lab: Data Modeling Business Alignment
  • Object Class Hierarchy
  • Conceptual Data Modeling
  • Logical Data Modeling
  • Physical Data Modeling
  • Best Practices for Conceptual, Logical, and Physical Modeling
  • Lab: Conceptual, Logical, and Physical Data Modeling

Day 4

  • Enterprise Data Modeling
  • Developing an Enterprise Data Model
  • Best Practices for Enterprise Data Models
  • Lab: Enterprise Data Models
  • Enterprise Data Management
  • Best Practices for Enterprise Data Management
  • Business Analysis and Incorporating an Enterprise Data Model
  • Lab: Business Analysis and Enterprise Data Models
  • Data Models as Inputs to Business Planning
  • Data Warehouses and Data Marts
  • Best Practices for Data Warehouses and Data Marts
Recommended Prerequisites

None

« Hide The Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]