Theory
- The concepts of valid time and transaction time
- Allen relationships as a shared vocabulary
- Clock ticks, time periods, open vs. closed intervals
- What the standards (SQL:2011) actually cover — and what they don't
TEDAMOH Academy
Temporal data in a fast-changing world!
Next open class: 20, 21, 27 and 28 October 2027, online, 8:30–13:00 German time each day.
Why temporal data?
Data rarely stays still. Contracts change, prices get corrected retroactively, master data takes on new values. Ignore that, and you lose history, can't answer audits, and report wrong numbers.
Bitemporal data solves this systematically: every change carries both its valid time and its transaction time. You can reconstruct state at any point — even when the truth only became known later.
The three modules
The training is split into three steps — theory, loading, querying. Each one has a clear focus and builds on the previous.
Loading
- Loading data correctly into bitemporal structures
- Retroactive corrections without losing data
- Late-arriving and out-of-order events
- Patterns for ELT in a cloud database
Querying
- Writing time-travel queries that don't accidentally return today
- Point-in-time snapshots and bi-time slices
- Joins across time periods
- Performance patterns for temporal queries
What you'll be able to do
- Talk about temporality with auditors, BI teams and business — with a shared vocabulary.
- Recognise when a data model needs historization — and when it doesn't.
- Audit existing data models for bitemporal correctness.
- Apply retroactive changes cleanly, without breaking history.
- Model bitemporal data correctly, without falling into the standard traps.
- Write time-travel queries that show the right picture at the right time.
- Pick clock ticks and time periods deliberately instead of by accident.
- Read Allen relationships like a shopping list — and use them where they actually fit.
Exercises & material
Around ten hands-on exercises accompany the modules. You work with real test data in a cloud database, write SQL statements, and verify results against prepared validation queries.
~10 exercises
With task and reference solution.
SQL tutorials
On time periods, Allen relationships and bi-time slices.
Test data set
With deliberately built-in temporal anomalies.
Download area
With slides, scripts and schema templates.
Pick your format
Four ways to get started. Open Class, In-House and the strategy workshop are available; the self-paced training is in the works.
Open Class
Open training with other participants, online in four sessions.
€1,990 net per person
Dates & bookingIn-House
Private training for your team — virtual or on-site. Content and focus tailored to your use cases.
Send inquirySelf-Paced
Recorded modules you work through at your own pace. Includes all exercises and SQL tutorials.
In the works. Sign up and you will be the first to know when it starts.
Notify me Notify me Start nowStrategy workshop
Two hours with data management leads and CDOs. We map side by side what your data foundation already supports — and where the gaps are, before an audit asks.
Book an intro callUpcoming Open-Class dates
No open dates scheduled at the moment. Sign up for updates or send us a note 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.
Prefer to talk first? Book an intro call →
Your trainer
Dirk Lerner
Founder TEDAMOH · Consultant & trainer for data modeling
Dirk has worked with data models for more than two decades — especially the ones where time matters. He advises banks, insurers and industrial companies, and has seen many bitemporal models that didn't work. This training is the result.
What participants say
"Finally a training that explains bitemporal data in a way my team could actually apply on the project."
"The mix of theory and concrete SQL exercises was spot on. We restructured our schema afterwards."
Frequent questions
Do I need SQL knowledge?
Yes. You should be comfortable writing SELECT, JOIN and aggregations. Specific temporal SQL constructs are introduced in the training.
What do I need technically?
A laptop with a browser. The exercises run in a cloud database — no local installation required.
Which database do we use?
We use a cloud-based database that supports SQL:2011 temporal constructs. The patterns translate to other relational systems.
Which prior knowledge is useful?
Experience with relational data modeling helps. If you've worked with historization or slowly changing dimensions before, you'll get the most out of it.
What is the difference between Open Class, In-House, Self-Paced and the strategy workshop?
Open Class: fixed dates, mixed participants. In-House: your team only, dates and content tailored. Self-Paced: recorded modules, your own pace, English only. Strategy workshop: two hours for data leads and CDOs — a strategic assessment rather than hands-on training.
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.