Building the Logical Data Model

2 Days

Description

Apply Proven Techniques for Data Modeling and Improve Business Processes

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 doesnt 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 thats easily testable and highly adaptable. By doing this precise analysis you will deliver more value in less time with higher quality.

Objectives:

  • 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

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

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Building the Logical Data Model class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

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 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

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Building the Logical Data Model class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Building the Logical Data Model class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Comments

Please call for Group Rate for 2 or more registrations.  Registrations must be made at the same time to receive discount.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Building the Logical Data Model class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date