Oracle Database 19c: Data Warehousing Techniques

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