Expert Course Tutorials
The tutorials in the Expert course build on the Professional course. The starting point and state of the contents in the DemoDW database is the end of Tutorial 10 of the Professional course. By this time you are familiar with the overall development process, so the most basic information will not be covered here.
For reference, have a look at the links on the Professional course front page.
Tutorial List
| Tutorial | What We Learn |
|---|---|
| 01. Key Groups | Use Key groups to define the context of the Business key. |
| 02. Implementing the Participation Design Pattern | Implement straight references in the source data using the more flexible Participation design pattern instead. |
| 03. Versioned Source Data | Implement a loading mechanism that only loads the latest version of the data from a set containing multiple versions. We also see how we can batch load the older versions in one go. |
| 04. Advanced State Handling | Fine-tune how individual rows are marked as deleted (D) when state handling is turned on for a class, even for incremental loads. |
| 05. Hierarchies | Split hierarchical data in different ways. |
| 06. Hierarchy Depth Changes | What kind of changes are required when a flat hierarchy gets a new level. |
| 07. Partial Load Deletion Detection | Automatically apply a source-aware algorithm for deletion detection to mark data as deleted. |
| 08. Merge Hashes Non-Destructively | Substitute a specific hash value for another in order to combine and standardize the way data is shown and used. |
| 09: Implementing Derived Classes | We study examples of how to create mappings between classes, derived as well as standard. |
| 10. Using GIT | We will go through the recommended practices how to use git to work within a team. |
