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 DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save