Data Warehouse

This course will help you understand the basic concepts of administering a data warehouse. You'll learn to use various Oracle Database features to improve performance and manageability in a data warehouse.

Course Syllabus

  • What is Data warehouse?
  • Characteristics of Data warehouse.
  • What is Data warehousing?
  • Principles of Data warehouse.
  • Benefits of DWH.
  • What is Online transactional systems (OLTP)?
  • Difference between OLTP and DWH.
  • Architecture of DWH.
  • Approaches of Data warehousing.
  • DWH Lifecycle: Data Modeling-Dimension table
  • Fact Table
  • Schemas
  • Star schema
  • Snowflake schema
  • Fact less Fact
  • Confirmed Dimension
  • ODS
  • Cube
  • Hierarchies
  • Slowly changing Dimension Concepts
For More Information : Call us @ 8792056828
Book Now for a Demo