Data Analyst Training Icon

Building The Logical Data Model

2 Days Classroom Session   |  
3 Days Live Online
Classroom Registration
Group Rate:
(per registrant, 2 or more)
GSA Individual:
Live Online Registration
Live Online:
Private Onsite Package

This course can be tailored to your needs for private, onsite delivery at your location.

Request a Private Onsite Price Quote

Professional Credits


ASPE is an IIBA Endorsed Education Provider of business analysis training. Select Project Delivery courses offer IIBA continuing development units (CDU) in accordance with IIBA standards.

This course offers 14.00 IIBA CDUs.


Select courses offer Leadership (PDU-L), Strategic (PDU-S) and Technical PMI professional development units that vary according to certification. Technical PDUs are available in the following types: ACP, PBA, PfMP, PMP/PgMP, RMP, and SP.

This course offers:
    12.00 PMP/PgMP Technical PDUs
    9.00 PMI-PBA Technical PDUs
    2.00 PMI-ACP Technical PDUs
    1.00 PMI-RMP Technical PDUs
    1.00 PMI Strategic PDUs
    1.00 PMI Leadership PDUs


If you work with distributed teams, including offshore developers and testers, you know that the more distant the development team, the greater the need for precision. Precise doesn't mean bigger documents in more abstruse notations. In this course you will learn a simple and compact system for collaborative modeling that enables you to capture the most information in the smallest space with the least work in a way that's easily testable and highly adaptable. By doing this precise data analysis you will deliver more value in less time with higher quality.

*Please note, if you are taking this class as part of the St. Louis University Certificate requirements, there is a $500 fee to claim your certificate once you have completed ALL requirements.

Learn how to organize a problem domain's concepts into a formal and accurate relational data model.
Create tables, columns, relations, and constraints that accurately reflect data requirements.
Use basic principles of normalization to ensure consistency.
Understand when "de-normalization" is and is not appropriate.
Create non-relational data models (such as XML schemas) and learn how to convert between relational and nonrelational models.
Upcoming Dates and Locations
All Live Online times are listed in Eastern Time Guaranteed To Run

There aren’t any public sessions currently scheduled for this course, but if you fill out the form below, we can tell you about how we can bring this course to you!

Course Outline

Section 1. Basics of the Relational Data Model?

  • Logical vs. Physical Models
  • Tables, Columns, Keys, and Relations
  • Entity-Relationship Diagramming (ERDs) and UML Class Diagrams

Section 2. Normalization Techniques

  • Why is normalization important?
  • Common Normal Forms
  • Real-World Data Issues

Section 3. Data Models in Context

  • Evaluating Data Requirements
  • Data Analysis in Business Process Models
  • Dealing with Legacy Systems and Data

Section 4. Applying Data Models

  • Data Models and UI Designs
  • Hierarchical Data Models (e.g. XML)
  • Object-Relational Mapping
Who should attend

This course is valuable for anyone who needs to accurately understand and manage the role of data and information in any given business processes or area. Perfect for:

  • Business Analysts
  • DBAs
  • Data Modelers
  • Data Analysts
  • Process Modelers
  • Project Managers

Download the brochure