- Introduction
- About the Course
Online
₹ 449 1,699
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
₹ 449 ₹1,699
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction
Traditional Data Warehousing
- The Story So Far...
- What is Data Warehousing
- Why build a Data Warehouse
- Basic DW Diagram
- The Iron Triangle and Data Warehousing
- The Data Journey
- Data Warehousing Quiz #1
- Data Warehousing Quiz #2
- Data Warehousing Quiz #3
- Summary
- Introduction to Data Modeling
- Introduction to SQL
- SQL Quiz
- Kimball Dimension and Fact Modelling
- Bonus Lecture: Creating a Simple Dimensional Data Model
- Bonus Lesson 1 Quiz
- Inmon Relational Modelling
- Big Data Modelling
- Data Modeling Quiz
- Architecture
- Summary
- Introduction to Extract, Transform, Load
- Bonus Lecture 2: Preparation For the ETL
- Extracting Data
- Transforming Data
- Loading Data
- Bonus Document 1: Things to Keep In Mind About the ETL
- Bonus Lecture 3: ETL Testing
- ETL Quiz
- ETL Quiz #2
- Bonus Quiz #2: Playing Well With Others
- Bonus Lecture: Interview Preview
- Bonus Lecture: Interview with a Data Architect
- ETL Tools
- Summary
- Introduction to Business Intelligence
- BI Tools
- Managing Report Development
- Summary
- The First Final Project
Transitioning to Modern Data Warehousing
- Bonus: State of Data Warehousing in 2017
- Data Lakes - Part I
- Data Lakes - Part II
- The BI/DW Project Manager in the Data Lake World
- Real-Time Reporting
- What's Streaming?
- Fools Rush In...To Real-Time
- Do Some Research into Distributed Architectures
- The Traditional Data Warehouse -- 24 Hour Latency
- Quick Reaction to Unelaborated Requirements
- Requirements Redux
- Last Look At Requirements
- Lambda in the Cloud
- Lambda On-Premises
- Helpful Documentation
- Organizing the Data Lake
- Challenge Time: You Tell Me
Conclusion
- What You've Learned
- Epilogue