Data Vault 2.0 Bootcamp + Certification

This 3-day intensive course covers extensively all aspects of the new Data Vault 2.0 version. It teaches you how to be a general practitioner, and enables you to implement Data Vault 2.0 successfully within your organization. CDVP2 (Certified Data Vault 2.0 Practitioner) is available privately for those who complete this course.

Topics during the course

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

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

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