Training courses¶

Guided courses with videos and exercises live at timextender.training. Every published module is now integrated into these docs — the pages below are the course content, cross-linked to the reference documentation. Interactive exercises, quizzes and the certification flow stay on the training site.

Start here¶

Data Integration¶

The most complete course — 22 modules, from a first instance to enterprise architecture. Course overview

Foundations

1. What is Data Integration? — start here for an introduction
2. SQL Sandbox — configure a data storage resource for your training environment
3. Install and configure — install the server service and desktop application
4. Portal — configure user access, instances and data source connections

Ingest

5. Ingest instance — ingest from multiple sources, run transfer and synchronization tasks

Prepare

6. Prepare instance — foundations of dimensional modelling, deployment and execution
7. Product dimension — data areas, incremental load, denormalising with conditional lookups
8. Customer dimension — multi-field lookups and conditional transformations
9. Sales transactions — denormalise header and detail tables, calculated fields
10. Finalize the presentation layer — presentation layer, date table, relations

Deliver

11. Deliver instance — curate a business-ready semantic model
12. Semantic model endpoints — choose endpoints for each analytics platform

Quality, performance and modelling

13. Data cleansing — validation rules, primary key constraints, referential integrity
14. Optimization — automated tools, indexing and compression
15. Table transformations — schema behavior, aggregations, table inserts
16. Slowly Changing Dimensions — SCD types and surrogate keys
17. Security — table, column and row level control

Operating it

18. Scheduled executions — orchestration, execution packages, scheduled refreshes
19. Agile Team Development — sprints, perspectives and promotion plans
20. Multiple Environments — configure environments and migrate between them
21. Enterprise Architectures — Azure SQL, Snowflake and Fabric reference architectures

Certification

22. Solution Architect Exam — review the study guide, register and get certified. See Certification Exam Study Guide in these docs.

Data Quality¶

Course overview

1. What is Data Quality? — concepts, core features, the three control types
2. Data Providers — connect to the systems you want to check
3. Query Control — build quality control checks and exception notifications

Then in these docs: Create your first query and Create a Test Group from a template.

Data Enrichment¶

1. What is Data Enrichment? — master core business data, replace spreadsheets, import source data

Then in these docs: Getting started with Data Enrichment, which walks through the four setup steps.

Orchestration¶

Coming soon on the training site. In the meantime: Getting started with Orchestration and Turnkey introduction.

Timextender Classic¶

Classic training is hosted separately, on Teachable. It covers building a data infrastructure using Business Units.

In these docs: Classic prerequisites and Activate Timextender Classic.

Other ways to learn¶