SKU: DV101-Baseline Category: Tags: , , , , ,

DV101 Baseline Hands-On

$349, 6 months

Welcome to the world-class hands-on course for Data Vault.  This course walks you from start to finish, from the source system model through the staging elements, to the raw vault, business vault and information mart delivery.  100% hands-on, 100% self-paced.  Over 4+ Hours of Training from Dan Linstedt, this is a $1500 value!   

See the description below, it contains important information about Pre-Requisites, and SQL compliance, and downloads.

Are you buying on behalf of someone else? 
Click This Is A Gift to assign it to another individual

Gifting:

You can purchase on behalf of a student or someone else.  To “give” the subscription to someone, click the This is a Gift checkbox – then enter the email address of the individual who will utilize the subscription!  Our system will automatically create an account for them.
NOTE: if you have more than one person to purchase for  you will need to add this product multiple times to the cart, with a quantity of ONE and gift each one.

Prerequisites:

This course is meant to be a companion course – this course teaches HOW-TO build, it does not cover: why Data Vault, nor does it teach about the different types of objects in the DV Modeling paradigm.  This course is a companion to: CDVP2 class, OR the book: Building a Scalable Data Warehouse with Data Vault 2.0, or for an individual with at least a basic knowledge of what Data Vault is.

ANSI-SQL Compliance:

All SQL is 98% ANSI-SQL compliant.  There are a few differences that are pointed out in the videos, and at the end of the course we provide some conversion hints for specific MERGE vs UPSERT views.

Supported Databases:

  • PostGreSQL v12.9 (or newer)
  • Snowflake

We include the downloads with the course, ** SQL files ** that you can see and run the code.   All DDL (models) are provided in text files, so you can create the tables and schemas in the right place.   See the description below for more information.

Video Lesson Agenda:

  • (00:02:42) Sample: Introduction to This Course
  • (00:09:37) Sample: Source Model Walkthrough
  • (00:05:35) Sample: Create Source DB
  • (00:11:17) Sample: Create Stage DB
  • (00:08:06) Create and Load Stage 2 DB
  • (00:03:38) Stage Load Process ID
  • (00:02:25) Create and Load Raw Vault
  • (00:11:34) DV Model Walkthrough
  • (00:05:25) Ghost Rec and Null Keys
  • (00:08:44) Intro to Raw Vault Hubs
  • (00:04:16) Load Remaining Raw Vault Hubs
  • (00:04:44) Load Raw Vault Links
  • (00:07:07) Load Raw Vault Standard Satellites
  • (00:13:36) Load Insert Only Effectivity Satellites
  • (00:11:34) Load Business Vault Effectvity Sats with Updates
  • (00:05:07) Load BV Hierarchical Link Eff Sats
  • (00:19:23) Load Raw Vault Multi-Active Sats
  • (00:11:21) Load Same As Link Effectivity Sats
  • (00:09:49) Introducing Control Data Updates
  • (00:18:11) Validating and Reviewing Updated Data
  • (00:06:30) Effectivity Satellite Restore
  • (00:08:56) InfoMart Prep for Effectivity Satellite
  • (00:13:37) Select and Load PIT and Bridge Hybrid
  • (00:12:22) Select and Load Raw PIT
  • (00:09:04) Select and Load Raw Bridge
  • (00:06:08) Selecting and Load Bridge with SnapDate
  • (00:09:43) Loading Bridge with SnapDate
  • (00:11:52) Building BI Views
  • (00:22:33) Snowflake DB Setup
  • (00:04:09) Convert PostGreSQL Upsert to Snowflake Merge
  • (00:05:45) Convert Snowflake Merge to PostGreSQL Upsert
  • (04:44:50) Total Course Video Time

Related products

Shopping Cart