Summary
Objectives
Topics
Other Trainings

This course covers all facets of Data Warehousing concepts, with lecture content and lab environment validated against the latest release of Oracle Database (19c).

The course covers the following topics:

Objectives

  • Assess Data Warehousing and Business Intelligence requirements
  • Create Analytic Views in SQL Developer
  • Assess Business Modeling tasks
  • Assess Logical and Dimensional Modeling tasks
  • Assess Extraction, Transformation, and Loading tasks

Topics

  • Evolution of information management systems and data warehousing
  • Need for machine learning, artificial intelligence, and big data in future data analytics
  • Data warehouse concepts and terminology
  • Multidimensional model concepts and create analytic views
  • Explain the business, logical, dimensional, and physical data warehousing models
  • Importance of extraction, transformation, and loading in data warehousing systems

Other Trainings

Database
91 Training Set
Back to Trainings