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!
The training returns in June 2026. Sign up for updates and you'll be the first to know when 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
- Read Allen relationships like a shopping list — and use them where they actually fit.
- Model bitemporal data correctly, without falling into the standard traps.
- Apply retroactive changes cleanly, without breaking history.
- Write time-travel queries that show the right picture at the right time.
- Pick clock ticks and time periods deliberately instead of by accident.
- Audit existing data models for bitemporal correctness.
- Talk about temporality with auditors, BI teams and business — with a shared vocabulary.
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, bi-time slices
- Test data set with deliberately built-in temporal anomalies
- Download area with slides, scripts and schema templates
Pick your format
Three ways to take the training. Open Class and Self-Paced follow the current phase. In-House is always available on request.
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.
Notify me Notify me Start nowUpcoming 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.
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 and Self-Paced?
Open Class: fixed dates, mixed participants. In-House: your team only, dates and content tailored. Self-Paced: recorded modules, your own pace, English only.