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.
Format
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
Subscribe via E-mail
Recent Comments
- Karen Lopez on Strutting: We all Know When You are Doing It. So Stop.
- Joey D'Antoni on Strutting: We all Know When You are Doing It. So Stop.
- Karen Lopez on Strutting: We all Know When You are Doing It. So Stop.
- Thomas LaRock on Strutting: We all Know When You are Doing It. So Stop.
- Karen Lopez on Strutting: We all Know When You are Doing It. So Stop.
Recent Posts
Downloads
- EDW 2013 Karen Lopez Get Blogging
- Karen Lopez presentation DAMA PS 2012
- Data Modeling Contentious Issues - DAMA Nebraska
- Karen Lopez - 10 Physical Blunders - DAMA
- Career Success In Data Profession - DAMA
- The Straw Poll
- You've Just Inherited a Data Model CheckList
- KarenLopez - 5 Physical Blunders - 24HOP-2011
- Handouts for OEMUG / CA Global Modeling User Group Why Be Normal Webcast
- Handouts Database Design Contentious Issues - New York 2010
- Handouts Database Design Contentious Issues - DC 2010
Archive
- May 2013 (4)
- April 2013 (5)
- March 2013 (4)
- February 2013 (7)
- January 2013 (12)
- December 2012 (2)
- November 2012 (3)
- October 2012 (3)
- September 2012 (13)
- August 2012 (5)
- July 2012 (17)
- June 2012 (2)
- May 2012 (4)
- April 2012 (4)
- March 2012 (8)
- February 2012 (11)
- January 2012 (3)
- December 2011 (10)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (9)
- July 2011 (5)
- June 2011 (5)
- May 2011 (5)
- April 2011 (9)
- March 2011 (4)
- February 2011 (9)
- January 2011 (8)
- December 2010 (15)
- November 2010 (27)
- September 2010 (2)
- August 2010 (1)
- July 2010 (4)




