Basic Data Modeling: Introduction for Non-Data Modeler Teammates
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. However, unlike our course for New Data Modelers, this course is focused on teammates of data modelers who want to get a better understanding of how data modeling works, what benefits there are and how their processes and deliverables may be affected…for the better.
Format
With demonstrations and hands-on exercises, this training course provides the basics of logical and physical data modeling. 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 "You will JUST LOVE data modeling" 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, gets value from data modeling and data modelers.
Participant Pre-requisites
As a basic course, it is not expected that attendees will have any data modeling experience. However, we do expect them to have more than two years of hands-on information technology skills at the enterprise level.
As this is a compact course (1.5 days), it will not provide attendees with sufficient skills or knowledge to become data modelers. It is intended to provide enough insight into the data modeling products and processes to help team members of data modelers understand the goals and outcomes of data modeling efforts.
We offer basic and advanced courses for those who do have data modeling experience.
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
Entity Relationship Diagrams
- Logical Data Modeling
- Physical Data Modeling
- Relationships
- Cardinality
- Optionality
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 (5)
- 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)




