18/05/2013
ProjectioNext launches new course on Introduction to Data Warehousing.
The students enrolled for this Data Warehousing training will become proficient in using the database, ETL to its full potential. It will teach them how to read, write, delete and manage data in a Data Warehouse
Introduction to Data warehousing
Who needs Data warehouse?
Why Data warehouse is required?
Types of Systems
(i)OLTP (ii) DSS
Maintenance of Data warehouse
Datawarehouslng Life cycle
Data warehousing Testing Ute Cycle
Source
Data warehousing Architecture
Integration Layer
Staging Area
Targets
Analysis & Reporting
HPQS
Introduction
Data Modelling
Different Phases of ModellIng
What Is a Dimension?
Multi Dimensional Modelling
What are Facts?
Multi Dimensional Model
Hierarchies
OLAP
MOLAP
ROLAP
HOLAP
Cubes and its Functions
Star Schema
Fact Table
Dimensional Tables
Snow flake Schema
Fact less Fact Table
Confirmed Dimensions
Introduction to Erwin
Data Modelling Tools
Forward Engineering
Reverse Engineering
Update Model, Alter database
Complete compare
Edupro Training is the leading provider of customised online training courses for the IT, Telecom, banking and finance sector.