Brochure
Enquire
- Course Overview
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 599 ₹3,699
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction to the Course
Traditional Modelling Concepts
- Entity Relationship Diagram
- Conceptual & Logical & Physical Model
- What is OLTP, What is Data Warehouse?
- Database Normalisation, 1NF & 2NF 3NF
- DWH Design Approaches “Top Down & Bottom up"
- Dimensional Modeling
- Star Schema & Snowflake Schema
- Slowly Changing Dimensions
- Conformed Dimensions
- Project 1: Convert ER Diagram to 3NF and 3NF to Dimensional Model
Data Vault Basics
- What is Data Vault
- Data Vault Basics
- Modeling Steps of data Vault
- How to split source records to target DV tables
Link Detail
- Link Detail
- Non-Historized (Transactional) Link
- Alternative Method to Model Transactions
- Link to Link Denormalization
- Flexibility and Granularity of Link
- Same-As Link
- Hierarchical Link
- Exploration Link
Satellite Detail
- Load End Date
- Multi active Satellite
- Status Tracking Satellite
- Record Tracking Satellite
- Effectivity Satellite & Driving Key
Data Vault Architecture
- Data Vault Layers
Business Vault
- Point in Time Table
- Bridge Table
- Reference Table
Information Vault
- Dimensional Model in Data Vault
- Type-1 Dimension with Single Satellite
- Type-1 Dimension with Multiple Satellite
- Type-2 Dimension with Single Satellite
- Type-2 Dimension with Multiple Satellite
- Fact Table
3NF & Dimensional Model & Data Vault
- 3NF & Dimensional Model & Data Vault
- Project 2: Convert 3NF to Data Vault
- Project 3: Convert Dimensional Model to Data Vault
Data Loading Architecture
- Data Load Terminologies
- Loading Data Vault Tables
Big Data Architecture & Agile Methodology
- Agile Methodology
- Introduction to Big Data
- Big Data & Data Vault Integration
- Reference Documents
Articles
Popular Articles
prev
next
