- Important - Working Files - Download These First
- 0101 What You Will Learn
- 0102 data Warehouse Concepts and Architecture
- 0103 data Warehouse Solutions
Online
₹ 449 2,299
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 ₹2,299
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Introduction to Data Warehousing
Data Warehouse Hardware
- 0201 Data Warehouse Challenges - Memory
- 0202 Data Warehouse Challenges - Physical
- 0203 Data Warehouse Architectures
- 0204 Data Warehouse Appliances
Designing and Implementing a Data Warehouse
- 0301 Data Warehouse Logical Design
- 0302 Data Warehouse Physical Design
- 0303 Exercise: Implementing A Data Warehouse Schema
- 0304 Solution For Implementing A Data Warehouse Schema
Design and Implement a Data Warehouse Schema
- 0401 ETL And SSIS
- 0402 Defining A Data Source
- 0403 Implementing A Data Flow - Part 1
- 0404 Implementing A Data Flow - Part 2
- 0405 Exercise: Implementing A SSIS Package
- 0406 Solution For Implementing A SSIS Package
Control Flows and SSIS Package
- 0501 Introduction To Control Flows
- 0502 Dynamic Packages
- 0503 Defining Containers - Part 1
- 0504 Defining Containers - Part 2
- 0505 Manage Consistency
- 0506 Exercise: Implement Control Flows In SSIS
- 0507 Solution For Implementing Control Flow SSIS
Debugging And Troubleshooting SSIS Packages
- 0601 Debugging SSIS
- 0602 Error Log Providers
- 0603 Error Handling And SSIS - Part 1
- 0604 Error Handling And SSIS - Part 2
- 0605 Exercise: Debugging And Troubleshooting SSIS
- 0606 Solution For Debugging And Troubleshooting SSIS
Incremental ETL Processes
- 0701 Introduction To Incremental ETL Processes
- 0702 Extract Modified Data - Part 1
- 0703 Extract Modified Data - Part 2
- 0704 Load Modified Data
- 0705 Exercise: Load Incremental Data
- 0706 Solution For Incremental Load
Enforcing Data Quality
- 0801 Data Cleansing
- 0802 Data Quality Services
- 0803 Data Quality Services And Matching Data
- 0804 Exercise Cleansing Data
- 0805 Solution For Cleansing Data
- 0806 Exercise: De-Duplicating Data
- 0807 Solution For De-Duplicating Data
Master Data Services
- 0901 What Is Master Data Services
- 0902 Implementing Master Data Services
- 0903 Excel Add-In For Master Data Services
Extending SSIS
- 1001 Custom SSIS Components
- 1002 Scripting And SSIS - Part 1
- 1003 Scripting And SSIS - Part 2
Deploying SSIS Packages
- 1101 Overview Of SSIS Deployment
- 1102 Deploying SSIS Packages - Part 1
- 1103 Deploying SSIS Packages - Part 2
- 1104 Planning SSIS Package Execution
- 1105 Exercise: Deploying An SSIS Package
- 1106 Solution For Deploying SSIS Package
Consuming Data
- 1201 Data Warehouse Using Excel
- 1202 Using PowerPivot And Data Warehouse
- 1203 Data Warehouse And SSRS
- 1204 Exercise: Using Excel And PowerPivot
- 1205 Solution For Excel And PowerPivot
About The Author
- 1301 Learn About Me