01
Foundations
- Advantages of data modeling
- Five prerequisites for creating a model
- Components: entities, attributes, representatives, relationships
- Subtyping, keys, hierarchies and networks
TEDAMOH Academy
Information Modeling — All about Information Modeling
Good business data models are the bridge between business and IT. In the Data Modeling Master Class you learn to read, build and validate them — with over 30 exercises.
New: the DMMC modules are now available as eLearning for pre-order — with an early-bird price.
New: the DMMC modules are now available as eLearning — start at your own pace.
Why information modeling?
Why do we spend a lot of money every year and thousands of hours building solutions that don't fit in the end? Often it comes down to business requirements that were captured and formulated poorly.
Good business data models prevent this waste. They capture business terminology and requirements precisely and at different levels of detail — ensuring smooth communication between business and IT.
The modules of the Data Modeling Master Class
Three modules that build on each other — from the foundations through building schemas to assessment with the Data Model Scorecard®.
02
Schema
- Conceptual, logical and physical models
- Relational and dimensional data models
- Distinguish NoSQL models from classic approaches
- Choose structure and methodology deliberately
03
Scorecard
- Best practices based on the Data Model Scorecard®
- Ten categories: correctness, completeness, schema, structure
- Abstraction, standards, readability, definitions
- Consistency and data
3modules
30+exercises
20teaching hours
What you can do afterwards
- Explain the components of data modeling and identify them in your projects through targeted questions.
- Read a data model of any size and complexity as confidently as a book.
- Validate any data model using key parameters — scope, abstraction, time frame, function, format — and the Data Model Scorecard®.
- Build relational and dimensional, conceptual and logical data models — and know the trade-offs of physical implementation for RDBMS and NoSQL.
- Apply requirements elicitation techniques: interviews, artifact analysis, prototyping and workplace observation.
Exercises & material
Over 30 hands-on exercises accompany the modules. Each one is explained in detail, with enough time to work through it yourself. A workbook guides you through every task.
30+ exercises
From "Modeling a book" and "Fun with cardinality" to the Six Questions.
Workbook
To work through all exercises — explained step by step.
Normalization & reservation
Examples like "Identify the normalization issues" and "Making a reservation".
Data Model Scorecard®
Template to validate your own models against ten categories.
Choose your format
Three ways to take the Data Modeling Master Class — all three are available.
Online training
Live training with other participants, virtual. Offered openly twice a year (Open Class).
€1,990 net per person · with DMC €2,240
Dates & bookingIn-House
Private training for your team — virtual or on-site, tailored to your use cases.
Send inquiryeLearning
At your own pace — recorded DMMC modules with all exercises.
Available soon.
Available in three packages — depending on how much guidance you want alongside it.
from €1,000 net
Notify me Get early-bird Request order Compare packagesDMMC Open Class in German. In-House also in English on request.
eLearning — three packages
The course content is identical in all three packages: all DMMC modules as video material with more than 30 exercises, one year of access. What differs is how much personal guidance comes with it.
Self-Paced
Learn at your own speed
€1,000 one-off, incl. one year of access
- All DMMC modules as video material, one year of access
- More than 30 exercises with workbook
- Three live calls within the first three months
Guided Learning
Learn with weekly expert support
€1,490 one-off, incl. one year of access
- Everything in Self-Paced
- Weekly live calls within the first three months
- Bring questions from your current work straight to the call
Fast Success
Accelerate your results with personal expert guidance
Limited places
€1,990 one-off, incl. one year of access
- Everything in Guided Learning
- Three additional 1:1 calls with Dirk Lerner
- Walk through your own models and cases one on one
With the Data Modeling Certification (DMC) — preparation and exam — each package costs €250 more (DMMC+). The live calls take place online at fixed weekly slots; you can join at any time. After the first year, access can be renewed for €99 per year, or extended to lifetime access once for €199. Group discount for several people from one company: 10 % from three, 15 % from six participants. All prices net.
DMC exam
The exam for the Data Modeling Certification. Four times a year, online. The exam is held in German only.
100multiple-choice questions
350+questions in the pool
85correct to pass
90minutes
Each question has six possible answers. The questions cover ten categories: syntax · components · process and approach · conceptual, logical, physical · relational and dimensional · notation · abstraction · naming standards · definitions · best practices and pitfalls.
With the Master Class
The Data Modeling Master Class+ includes the exam preparation and the exam — in the open class and in the eLearning.
+€250 net on top of the course price
See formatsExam only
For anyone who learned elsewhere and wants to get certified.
€250 net per person
Request orderDates: 4 Mar 2027, 3 Jun 2027, 2 Sep 2027, 2 Dec 2027, each 10:00–12:00 (German time)
Further trainings
FCO-IM Fundamentals Class
German version coming soonFact Based Modeling
A three-day training on fact-oriented information modeling: capture business knowledge precisely together with domain experts, verbalize it in natural language with concrete examples, add rules and constraints, transform models and generate artifacts. Delivered with CaseTalk.
Upcoming dates
No open dates listed right now. Sign up for updates or contact us for an individual offer.
Inquiry and order
For questions, in-house training and orders. Orders are confirmed by email; the contract is concluded with that confirmation.
Your trainer
Dirk Lerner
Founder of TEDAMOH · consultant & trainer for data modeling
Dirk is an independent consultant and coach with more than two decades of experience in BI projects. He is a recognized expert in BI architectures, data modeling and temporal data, and advocates for flexible, lean and easily extensible data warehouse architectures. As a Data Vault and FCO-IM pioneer in the German-speaking region, he has published numerous works and is a sought-after speaker at international conferences.
He has taught the Data Modeling Master Class since 2020. He conducts the DMC exams and was the first Data Modeling Certified in Europe.
What participants say
"The webinar series prepares you for the DMC certification in an entertaining way. Lots of questions, helpful exchange between participants. And Dirk, who always seems to know the answer!"
"The course covers the basics through to detailed information about data modeling and is suitable for both beginners and advanced users. Highly recommended!"
Frequently asked questions
Is prior knowledge required?
No. The Data Modeling Master Class requires no prior knowledge of data modeling — there are no special prerequisites for attending.
Is SQL required?
No. The Master Class is independent of any specific physical implementation of the data models. Knowledge of SQL or other programming languages is not required to attend.
What are the technical requirements?
For the virtual training you need a laptop, PC or tablet with access to Microsoft Teams (browser or client).
Online, In-House or eLearning — which fits?
Online training (Open Class): fixed date, mixed participants, in German. In-House: your team only, dates and content individual, English on request. eLearning: recorded DMMC modules at your own pace.
What's the difference between DMMC and the FCO-IM Fundamentals Class?
The Data Modeling Master Class focuses mainly on business-oriented modeling (conceptual, logical, physical; relational, dimensional, NoSQL). The FCO-IM Fundamentals Class teaches fact-oriented information modeling with CaseTalk — a German edition is currently in preparation.
Is the certification included?
If you add it. With the Data Modeling Certification (DMC) the DMMC becomes the DMMC+: preparation for the exam and the DMC exam itself are included — in the open class and in the eLearning, for €250 extra. More in the section DMC exam.
How does the exam work?
100 multiple-choice questions in 90 minutes, online. Each question has six possible answers; you pass with 85 correct answers.
How often are exams held?
Four times a year. The current dates are listed under Dates.
Can I take the exam without the Master Class?
Yes, the DMC exam can be booked on its own. It is included in the Data Modeling Master Class+.
How do I prepare?
With the Data Modeling Master Class+: it includes the exam preparation. On tedamoh.com there are sample questions (in German) to try out.
In which language is the exam held?
In German only. There is no English exam.
What happens if I don't pass?
You can retake the exam — either right afterwards or at the next exam date.
What is the difference between the three eLearning packages?
The course content is the same in all three packages. They differ in how closely Dirk supports you:
- Self-Paced — three live calls within the first three months
- Guided Learning — twelve live calls within the first three months, one a week
- Fast Success — everything in Guided Learning plus three 1:1 calls with Dirk. Places are limited.
How do the live calls work?
Once a week, at fixed times, online. They are there for your own questions — they are not guided lessons. Sometimes you are alone in the call, sometimes several participants join. You can start at any time.
With Self-Paced you pick your three calls from the weekly slots of the first three months, whenever it suits you.
What happens after the first three months?
The live calls and 1:1 calls always run in the first three months after you start. After that they end. Videos, materials and exercises stay available for your whole access period.
What does lifetime access mean?
You have access to the training for as long as the training exists. Without lifetime access, access ends after twelve months. You can still add lifetime access then (€199 net) or renew yearly (€99 net per year).
We are booking Fast Success as a team — how does that work?
Instead of individual 1:1 calls there are team calls — six instead of three. You sit down together with Dirk and work on your own models and cases.
How do I order?
Use the form on this page: choose „Order", pick a date or package and enter your billing address. You receive a summary by email right away. Dirk checks the order and confirms it; the contract is concluded only with that confirmation. The invoice comes with it.
Are there discounts?
If you are a student, a pupil, an apprentice or work at a university, ask Dirk about the education discount.
If several people from one company sign up, there is a group discount: 10 % per person from three, 15 % from six participants.