Oracle Database 19c: Data Warehousing Concepts Course Overview

Enroll for the 2-day Oracle Database 19c: Data Warehousing Concepts course from Koenig Solutions accredited by Oracle. This course teaches you the various Data Warehousing concepts.

Through a blend of hands-on labs and interactive lectures you will learn the following:

  • 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


Target Audience:

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

Learning 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


  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Course Overview
  • Details are not available.
  • Evolution of Information Management and Data Warehousing
  • Business Intelligence: Requirements
  • Overview of Data Warehouse and Multidimensional Model Concepts
  • Data Warehouse Architectures
  • Data Warehousing Process Components
  • About Business, Logical, Dimensional, and Physical Models
  • Determining Granularity
  • Primary Key and Foreign Key
Live Online Training (Duration : 16 Hours)
Group Training 1050 Per Participant
23 - 24 May 09:00 AM - 05:00 PM CST
(8 Hours/Day)
06 - 07 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 05 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 2100 1400 + If you accept merging of other students.
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 16 hours is too fast, we can offer Comfort Track for 32 hours for only USD 2,800

Course Prerequisites

Good working knowledge of the SQL language.


Request More Information

Add Name and Email Address of participant (If different from you)