Overview

This OD-19c-DWC: Oracle Database 19c: Data Warehousing Concepts course covers the following 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

Skills Covered

  • 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

Who Should Attend

  • Data warehouse developers
  • Data warehouse engineers
  • Data warehouse analysts
  • Data warehouses builders and administrators
  • Data warehouse implementation team members
  • Data warehouse developers

Course Curriculum

Prerequisites

Good working knowledge of the SQL language.

Download Syllabus

Course Modules

Request More Information