Data Warehousing Course Content

  • Need of Data Warehousing
  • Definitions for Data Warehousing
  • Architecture of OLTP Systems
  • Drawbacks of OLTP Systems
  • Introduction to SOA (Service Oriented Architecture)
  • Difference between OLTP Systems and OLAP Systems
  • General Architecture of Data Warehousing
  • Different Approaches for DWH
  • Top Down
  • Bottom Up
  • Components of Data Warehousing
  • Modeling
  • Logical
  • Physical
  • Complete comparison
  • Data Modeling
  • Dimensional Modeling
  • Different Types of Dimensions
  • Normalized
  • De normalized
  • Different Types of Fact Tables
  • Periodic Snapshot
  • Accumulated Snapshot
  • Transactional grain
  • Fact less

OLAP system Design

  • ROLAP
  • MOLAP
  • HOLAP
  • DOLAP
  • TOLAP
  • Enterprise Data Warehousing
  • Data Marts
  • Independent
  • Dependent
  • ODS (operational Data Store)
  • Difference between OLTP, OLAP, ODS
  • Difference between DWH and Data Marts

Schemas:

  • Star Schema
  • Snowflake Star Schema
  • Galaxy Schema
  • Difference between E-R Model and Dimensional Model.
  • Working with data modeling concepts.
  • Conceptual model
  • Logical model
  • Physical model
  • Introduction to Erwin:
  • Design logical model with entities, attributes and relationships
  • Design Physical model with tables, columns and relationships
  • Working with identifying and non-identifying relationships
  • Explanation on different types of relationships:
  • Unary relationship
  • Binary relationship
  • Ternary relationship
  • Working with 1-m and m-m relationships
  • Working with bridge or associate tables
  • Working with forward engineering process
  • Working with reverse engineering process
  • Working complete comparison