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!
Sign up for updates and be the first to know when new dates are confirmed.
The training is open for booking — with a 20% early-bird price for newsletter members, while seats last.
The training is running. Book your seat directly.
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 and Self-Paced follow the current phase. In-House and the strategy workshop are available on request anytime.
Open Class
Open training with other participants. Virtual or on-site, in four sessions or as a two-day block.
Subscribe for dates Get 20% early-bird Book now Upcoming dates →In-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.
Available from autumn 2026.
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.
Send inquiry
For in-house trainings, individual dates or general questions. We'll get back to you shortly.
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.