e-Learning

C3-X-MS-DV (Beginner)

Learn about data vault modeling with the biGENIUS-X Microsoft SQL Server generator in this hands-on practice module, and earn your Engineer certificate.

Enroll now

C3-X-MS-DV Microsoft SQL Server Generator (Data Vault modeling)

750 CHF / 750 EUR / 855 USD

Duration

3 days

Target group

  • Data solutions developers
  • Data solutions project managers
  • BI consultants

Course content

Practical exercises with step-by-step instructions for the biGENIUS-X Microsoft SQL Server Data Vault Generator:

  1. Setup
  2. Setup Solution and Project
  3. Add source system and discover
  4. Define Raw Vault Hubs
  5. Define Raw Vault Satellites
  6. Define Raw Vault Links
  7. Add transactional data
  8. Add a new source
  9. Define PIT tables
  10. Define Current Views
  11. Create a reference table and work with a Raw Vault Composite
  12. Define Business Vault objects
  13. Define Business Vault objects
  14. Define Business Vault objects
  15. Define Business Vault objects
  16. Build a Data Mart

To obtain the biGENIUS-X Engineer certification, you would need to pass an online exam with 47 questions.

Prerequisites

Knowledge prerequisites

  • Completion of module: C1-X – Introduction to biGENIUS-X
  • Completion of module C2-X – biGENIUS-X application features
  • SQL Server basics
  • Data Vault 2.0 modeling basic knowledge

Here are some links that will help you better understand data vault modeling:

Technical prerequisites

  • Please prepare your training environment as instructed in this biGENIUS-X Knowledge Base article: Target environment for Microsoft SQL Server‍
  • We suggest you use a Docker image instead of installing a local SQL server.
  • If you use a local installation, you must know how to use and configure SQL Server before starting this training.
  • No additional support from biGENIUS will be provided regarding your SQL Server installation and configuration.

How to enroll

1. Once you have registered for a module, we will add you to our e-Learning platform with your business contact details.
‍
2. You will then receive an email. If you don't yet have an account, it is then necessary for you to create your own user and register yourself in the biGENIUS Learning Manager.

Enroll now