Course Name:Data Warehousing
Course Duration:3 month
Course Fees:20,000
Syllabus:
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
Data Modelling Tools
• Forward Engineering
• Reverse Engineering
• Update Model, Alter database
• Complete compare