Data Warehousing course content

Course Content:

Online IT training at Slakesoft Solutions

INTRODUCTION:
Transaction Database
Transaction Database Definition and features
E-R Data Model Database Normalization using
Six Normal Forms Database Denormalization.

Warehouse Database
Data Warehouse Definition and Features
Difference between Transaction Database and Warehouse Database
Dimensional Data Model
Star Schema Model
Star Flake Schema Model
Snow Flake Schema Model
Extended Star Schema Model
Galaxy Schema Model
Cube Designing using different models
Denormalization of Data Warehouse
Other Databases Data Mart Staging Database Operation Data Storage/Source (ODS)

Database Modeling using ERWIN Logical Data Model and Physical Data Model Models,
Subject Areas and Display Objects Entities,
Relations,
Attributes and Business Rules Relation Cardinalities,
Verb Phrases,
Relation Types & Referential Integrity ERWin Macros,
Model Properties,
Model Mart

For more details about online Data ware housing training visit: Slakesoft Solutions