Online Solvers ( SINCE 2005 ) : Call US: +1 339 368 6489 (USA) | +91 - 880 138 6489 (INDIA)

Pioneer In Online Training.
Online Training By Real Time Industry Experts with Professionalism and Commitment.

DATA WAREHOUSING Online Training


Course Content:
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

Copyright 2010 Online Solvers. All Rights Reserved