Overview
The Oracle Database 19c: Data Warehousing Techniques course teaches you the various Data Warehousing concepts and techniques related to data extraction, transformation, and loading phases. You will learn about the different changed data capture methods for data refresh, and how to define summary management and implement materialized views. You will also learn about the role of warehouse metadata along with the various data warehouse implementation considerations.
Skills Covered
- Connect to ODI Master and Work Repositories
- Define the Topology for source and target data warehouse system
- Set Up an ODI Project
- Create ODI Models and Reverse Engineer
- Check Data Quality in the Model
- Create an ODI Mapping: Simple Transformations
- Create an ODI Mapping: Complex Transformations
- Load Data from a Single Data Source
- Load Data from Multiple Data Sources
Prerequisites
Required Prerequisite Skills:Â Basic knowledge of data warehouse concepts and related terminology. Relational database concepts and Oracle server concepts including application and server tuning, and the operating system environment under which you are running the Oracle Database Server. Good working knowledge of the SQL language.
Target Audience
- Data warehouse developers
- Data warehouse engineers
- Data warehouse analysts
- Data warehouses builders and administrators
- Data warehouse implementation team members
- Data warehouse developers
Module 1: Course Overview
Module 2: Data Extraction Techniques
- Data Extraction Techniques
- Data Extraction Process
Module 3: Introduction to Data Transformation
Module 4: Data Transformation Techniques
Module 5: Data Loading Techniques
- Data Loading Techniques
- Loading Techniques Supported by Oracle
Module 6: Database Sizing, Storage, and Security Considerations
- Database Sizing, Storage, and Security Considerations
- Data Partitioning
Module 7: Data Refresh Techniques
- Data Refresh Techniques
- Applying the Changes to the Data Warehouse
Module 8: Summary Management
- Summary Management
- Refresh Modes
Module 9: Metadata Management
- Metadata Management
- Metadata Strategy and Considerations
Module 10: Data Warehouse Implementation Considerations
Dates & Locations
September 28, 2026 - September 30, 2026
September 28, 2026 - September 30, 2026
December 7, 2026 - December 9, 2026
December 7, 2026 - December 9, 2026
Exam & Certification
This course is not associated with any Certification.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
