Data Vault 2.0 · Advanced

Data Vault 2.0 Modelling in Practice

Model Raw and Business Vault structures that stay auditable as sources change.

An advanced, workshop-style course on Data Vault 2.0: business keys, Hubs, Links and Satellites, PIT and Bridge tables, and loading patterns, applied to a banking case study.

Duration
24 hours
Mode
Hybrid
Next batch
To be announced
Schedule
Two weekends, 10am–4pm IST

Who it is for

Data modelers, data architects and senior data engineers.

Prerequisites

Experience with relational or dimensional modelling and SQL.

What you will be able to do

  • Identify business keys and design Hubs, Links and Satellites
  • Model history, effectivity and multi-active data correctly
  • Build PIT and Bridge tables for efficient querying
  • Review AI-drafted Data Vault models against the business

Course contents · 5 modules · 24 hours

01
Why Data Vault

Architecture layers, Raw vs Business Vault, when to use it

3 h
02
Core structures

Business keys, Hubs, Links, Satellites, hash keys, naming standards

7 h
03
Advanced patterns

Effectivity and multi-active Satellites, same-as links, hierarchical links

6 h
04
Query layer

PIT and Bridge tables, information marts

4 h
05
Case study review

Banking case study; design review with the trainer

4 h

Hands-on approach

30% concepts, 70% hands-on labs on realistic business scenarios. AI practice support between sessions; every project is reviewed by the trainer.

Keep exploring
SnowflakeIntermediate

Snowflake Data Engineering Bootcamp

For data engineers and SQL developers who want to build reliable, cost-aware pipelines on Snowflake.

Duration
24 hrs
Mode
Live online
Starts
To be announced
Syllabus · 5 modules · Sat–Sun, 10am–1pm IST
  1. Snowflake architecture and setup · 4h
    Storage, compute and services layers; warehouses; databases and schemas; roles and cost basics
  2. Loading data · 5h
    Stages, file formats, COPY INTO, Snowpipe, semi-structured data with VARIANT
  3. Transformations and ELT · 6h
    Streams, tasks, dynamic tables, MERGE patterns, incremental loads, time travel
  4. Security and governance · 4h
    RBAC design, masking and row access policies, tagging, data sharing
  5. Performance, cost and capstone · 5h
    Clustering, query profile, resource monitors; end-to-end capstone reviewed by the trainer
You will be able to: Design Snowflake databases, schemas and warehouses for a real workload · Load batch and continuous data with COPY, stages and Snowpipe · Build incremental ELT with streams, tasks and dynamic tables · Apply role-based access, masking and cost controls · Review AI-assisted SQL critically before it runs
Fees on requestEnquire for fees and the next batch
View course detailsEnquire
DatabricksIntermediate

Databricks Lakehouse Engineering with PySpark

Build medallion-architecture pipelines on Databricks with PySpark and Delta Lake.

Duration
30 hrs
Mode
Live online
Starts
To be announced
Syllabus · 5 modules · Weekday evenings, 7–9pm IST
  1. Lakehouse fundamentals · 4h
    Workspace, clusters, notebooks, Delta Lake basics, medallion architecture
  2. PySpark for data engineering · 8h
    DataFrames, joins, window functions, UDF trade-offs, performance basics
  3. Delta Lake in depth · 6h
    MERGE, change data feed, schema evolution, OPTIMIZE and Z-ORDER, time travel
  4. Governance and quality · 5h
    Unity Catalog, expectations and data quality checks, lineage
  5. Orchestration and capstone · 7h
    Workflows, parameters, monitoring; capstone pipeline reviewed by the trainer
You will be able to: Build medallion (Bronze, Silver, Gold) pipelines with PySpark and Delta Lake · Handle incremental and historical loads, schema evolution and data quality checks · Govern data with Unity Catalog · Orchestrate and monitor jobs with Databricks Workflows
Fees on requestEnquire for fees and the next batch
View course detailsEnquire
AI for Data TeamsIntermediate

AI for Data Teams: LLMs, RAG and Reviewing AI Output

Use AI productively in data work, and know when not to trust it.

Duration
16 hrs
Mode
Live online
Starts
To be announced
Syllabus · 4 modules · Sat–Sun, 10am–2pm IST
  1. LLM basics for data people · 3h
    How models work, strengths, failure modes, hallucination
  2. Prompting for data work · 4h
    SQL generation, documentation, data quality rules, STTM drafts
  3. Retrieval and vector search · 4h
    Embeddings, chunking, RAG over metadata and documentation
  4. Safe use and review · 5h
    Data privacy, human gates, review checklists, measuring quality; capstone reviewed by the trainer
You will be able to: Explain how LLMs work and where they fail · Design prompts for SQL, documentation and data quality tasks · Build a simple retrieval (RAG) pipeline over your metadata · Set up review gates so AI output is checked before use · Keep personal and sensitive data out of AI tools
Fees on requestEnquire for fees and the next batch
View course detailsEnquire