Basic Data Modeling: For New Data Modelers

In this introductory workshop, Karen Lopez covers the theory and skills required to being working on data models in an enterprise environment on modern project teams.


With demonstrations and several exercises, this training course provides the basics and tests attendees to demonstrate their new skills. This course follows a workshop format, with both individual and team exercises. We offer this as a public workshop as well as in an onsite corporate format.

…but this isn’t your average "Here are all the Normal Forms, now go create a model" course.  Our goal is to make data modeling relevant to modern development practices and tools.  We’ll talk about some of the pain points modelers feel, why developers and DBAs sometimes don’t see the same beauty in our data models and how to ensure everyone, IT and business, sees the value of data modeling and data modelers. 

Participant Pre-requisites

As a basic course, it is not expected that attendees will significant data modeling experience.  However, we do expect them to have more than two years of hands-on information technology skills at the enterprise level.   We offer advanced courses for those who do have data modeling experience.  It is also common for attendees of the Basics course to sit in on the Advanced courses to get a better understanding of the issues that experienced data modeler see on a regular basis.

Interested in Attending?

For information about public courses, watch our blog and events page.

For inquiries about private courses, contact Karen with your desired timeframe and number of participants.


Defining Data Modeling and Why it is Important

Relational Notation and Normalization

Entity Relationship Diagrams

  • Conceptual Modeling
  • Logical Data Modeling
  • Physical Data Modeling
  • Relationships
  • Cardinality
  • Optionality
  • Notation Overview

Subtypes, Attributes, Primary Keys

  • Supertypes and Subtypes
  • Attributes
  • Datatypes
  • Nullability

The Data Modeling Process

A Brief Look at Data Modeling for Other Types of Datastores

Leave a comment

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to by Email