Advanced Data Modeling

Course Duration: 2 days

Professional Development Units (PDU’s): 14

Course Description: This course extends participants knowledge of data modeling by exploring advanced concepts such as sub-types, recursive and network relationships, denormalization and when to apply it, and other considerations for transforming a logical model into a physical design.  It picks up where our introductory course on Data Modeling leaves off.  It assumes participants have grasped or have experience with the fundamental concepts of data modelling and builds on them.  Depending on the level of experience and knowledge of the participants, this course can be reduced to a 1-day class (by eliminating the sub-types/super-types and recursive relationships sections of the course).

Key Learning Objectives:

  • normalize entities to fifth normal form
  • handle complex relationships
    • sub-types and super-types
    • recursive hierarchies
    • recursive networks
  • apply various data modelling guidelines to improve the quality of data models, and therefore the data requirements of an enterprise
  • refine a data model in order to best prepare it for physical database design
  • describe the issues involved with denormalization and explain 2-3 strategies for deciding on; if, when and how to accomplish it. This skill will be useful to work with data analysts and database administrators
  • use two practical methods to balance your data model with processes or use cases, to ensure that all needed data and only needed data is present
  • use State Transition Diagrams to uncover missing data and processes

Audience: This course is designed for business analysts, application developers/analysts, project leaders and data/database administrators

Course Prerequisites: A basic knowledge of data modeling concepts and techniques is required

Course Price: For on-site courses please contact Mindavation on 1-866-888-MIND(6463) or e-mail: info@mindavation.com For public course availability please see Public Course Schedule.

PMBOK® Guide Knowledge Areas:

  • Project Scope Management
  • Project Quality Management

BABOK® Knowledge Areas:

  • Requirements Analysis

Click here to view course content.

PMBOK is a registered mark of the Project Management Institute, Inc.

The Mindavation Foundation is proud to donate 5% of profits towards development of youth leaders.
Copyright © 2011 Mindavation - All rights reserved.