CDVP2 Class Agenda

Data Vault 2.0 Boot Camp and Certification

We are happy you are deciding to investigate the Certified Data Vault 2.0 Practitioner (CDVP2) course further.  We have provided a full agenda below that demonstrates the main topics the course covers.  If you would like a more detailed course agenda, contact us and we will be happy to speak with you about additional details.

​The practitioner certification test is included as a part of the course.  The test is offered ​privately on-line, usually ​four (​4) weeks after the class completes.  You will need to contact your instructor for further details.  ​We highly recommend studying, as the test is not easy.   It is open book, ​open note.​

The Training format is:  1 day of On-line CBT Video based training, 8 hours of run-time divided in to Modules, Modules are broken down in to 15 minute video segments. 3 days of in-person live training

It is imperative that you watch ALL the videos in the on-line portion of the course BEFORE attending the class in person. If you do not, then you will miss a significant portion of the content, and not be able to keep up with the lecture.

Dan Linstedt, Inventor of Data Vault

Computer Based Training, On-Line

  • What is Data Vault 2.0?
  • DV1.0 Compared to DV2.0
  • Issues Faced Today
  • Data Vault 2.0 In Business
  • Managed Self-Service BI
  • Agile Delivery and DV2.0 Methodology
  • Agile Requirements Gathering
  • Technical Numbering
  • Roles and Releases
  • Architecture Components

Agenda Day 1

  • Data Vault 2.0 Overview / Review / Introduction
  • Hadoop Overview (Cursory look)
  • SMP vs MPP
  • Data Vault at Lockheed Martin and Commonwealth Bank
  • Business Vault
  • Value of Data as an Asset
  • Business Processes to Business Keys
  • Hashing and Sequences
  • Common Terminology
  • Core DV Structures

Agenda Day 2

  • Dependent Child (Data Modeling)
  • Driving Key
  • Link to Link Denormalization
  • Link Unit Of Work
  • Exploration Links
  • Applying Links
  • Non-Historized Link
  • Satellites in Depth
  • Reference Data
  • Distribution and Co-Location
  • Queries in Hadoop MPP / Hive
  • Point-in-Time and Bridge Tables (Dashboards, analytical, virtual marts)
  • Group Workshop

Agenda Day 3

  • Workshop Review
  • Data Vault in a Data Lake
  • Record Source Tracking
  • Applying Set Logic
  • ELT / ETL Performance Tuning
  • Loading Architecture
  • Column Comparison and Hash Differences
  • Zero Key Concept
  • Staging Loads
  • DV2.0 Loading Templates / Standards
  • End-Dating Satellite Templates
  • Real-Time Loading
  • Dealing with Corrupted Data

Strongly Recommended Reading

” ​Hands-On Examples! ”

​It is also recommended that ​you ​have a copy of the book: Building A Scalable Data Warehouse With Data Vault 2.0 (available on Amazon.com) prior to attending the course. ​

This book provides a valuable resource with deep-dive data sets and hands-on examples to back up the lecture with practical and workable solutions.

​Dan Linstedt, Co-Author and Sole Data Vault Inventor