Oracle Database 19c: Data Warehousing Techniques
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.
STUDENTS WILL LEARN TO
- 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

Phone
|
Phone
|
---|---|
Product
|
Oracle
|
Code
|
D1101948GC10
|
Duration
|
3 Days
|
Price (baht)
|
45,000
|
About the course
COURSE OUTLINE
MODULE 01 Course Overview
- Course Overview
- Practice 1-0: Lab Environment
- Practice 1-1: Exploring the Lab Setup
- Practice 1-2: Examine the Use Case Schema in Oracle Database
- Practice 1-3: Examine the Use Case Schema in MySQL Database
MODULE 02 Data Extraction Techniques
- Data Extraction Techniques
- Data Extraction Process
- Practice 3-1: Defining the Topology
- Practice 3-2: Setting Up the ODI Project
- Practice 3-3: Creating ODI Models and Reverse Engineering.
- Practice 3-4: Checking Data Quality in the Model
MODULE 03 Introduction to Data Transformation
- Introduction to Data Transformation
MODULE 04 Data Transformation Techniques
- Data Transformation Techniques
- Practice 5-1: Creating an ODI Mapping: Simple Transformations
- Practice 5-2: Creating ODI Mapping: Complex Transformations
MODULE 05 Data Loading Techniques
- Data Loading Techniques
- Loading Techniques Supported by Oracle
- Practice 6-1: Loading Data from a Single Data Source
- Practice 6-2: Loading Data from Multiple Data Sources
MODULE 06 Database Sizing, Storage, and Security Considerations
- Database Sizing, Storage, and Security Considerations
- Data Partitioning
MODULE 07 Data Refresh Techniques
- Data Refresh Techniques
- Applying the Changes to the Data Warehouse
- Practice 8-1: Implementing Changed Data Capture in ODI
MODULE 08 Summary Management
- Summary Management Refresh Modes
- Practice 9-1: Creating and Refreshing Materialized Views
- Practice 9-2: Demonstrating Query Rewrite Using a Materialized View
MODULE 09 Metadata Management
- Metadata Management
- Metadata Strategy and Considerations
MODULE 10 Data Warehouse Implementation Considerations
- Data Warehouse Implementation Considerations
Register for Training
Schedule
Start Date | End Date | Duration (days) | Price | Register | Course | Code | Product |
---|