Data Warehousing

Introduction:Data Warehousing

11 ratings, 147 students enrolled

Instructed by Abrar Hussain Development / Programming Languages

UME Academy offers data warehousing training. You will gain thorough proficiency in multidimensional modeling, RDBMS tools, SQL parsing, comparison of data warehouse and database, Cube and Erwin implementation. This data warehousing online training course can be taken both by fresher’s and advanced professionals.

Who should do this course?

  • Database Administrators and Database Modelers
  • Analytics Managers, ETL and BI Developers, Data Scientists and Analysts
  • Those looking for a career in Data warehousing

What are the pre-requisites?
This course can be pursued regardless of the individual’s skills

Take this Course
Take this Course


Lectures 25
Video 3 Hour
Skill Level Medium Level
Languages English

Course Description

1.Introduction to Data Warehousing

Introduction and Objectives 16m
Definition of Data Warehousing 16m
Advantages of Data Warehousing 16m
Disadvantages of Data Warehousing 16m
Benefits of Data Warehousing 16m
Concepts of Data Warehousing 16m

2.OLTP, OLAP and Other Terminologies

Introduction and Objectives 16m
Online Transaction Processing 16m
Data Store 16m
Data Mart 16m
Design Schemas 16m
Meta Data 16m
Data Webhouse and Data Warehousing Queries 16m
Extract, Transform, Load 16m


3.Lifecycle and Rules of Data Warehouse

Introduction and Objectives 16m
Data Warehouse Lifecycle 16m
Design 16m
Prototype 16m
Deploy 16m
Enhance 16m
Data Warehouse Cycle of Cycles 16m
Related Factors 16m
Rules of Data Warehouse 16m

4.Data Warehouse Architecture and Flow

Introduction and Objectives 16m
Introduction to Data Warehouse Architecture 16m
Key Components 16m
The Static Declaration And Variable Expiry 16m
Typical Architecture of Data Warehousing 16m
Common Architecture 16m
Data Warehouse Information Flow 16m

5.Data Warehouse Modeling

Introduction and Objectives 16m
Importance of Data Modeling 16m
Introduction to Data Modeling Techniques 16m
Entity-Relationship Modeling 16m
Limitations of ER 16m
Dimensional Modeling 16m
Benefits of Dimensional Modeling 16m

6.Data Warehouse Applications

Introduction and Objectives 16m
Introduction to Data Warehouse Application 16m
Retail Industry 16m
Manufacturing and Distribution 16m
Bank 16m
Insurance Company 16m
Health Care Providers 16m
Government Agencies 16m
Internet Companies 16m
Telecommunications 16m
Sports 16m

7.Challenges and Future of Data Warehouse

Introduction and Objectives 16m
Challenges to Data Warehousing 16m
Ensuring Data Quality 16m
Ensuring Performance 16m
Testing the Data Warehouse 16m
User Acceptance 16m
Future of Data Warehouse 16m

No Comments

Post a Reply