Oracle Database 19c: Data Warehousing Techniques LVC

Cui îi este dedicat cursul?

Data Analyst, Data Architect, Database Administrator

Cunoștințe și abilități inițiale

-

Prezentarea cursului

This course covers all facets of Data Warehousing Techniques, with lecture content and lab environment validated against the latest release of Oracle Database (19c).

The course covers the following topics:

• Data warehousing concepts
• Data warehousing techniques related to data extraction, transformation, and loading phases
• Various data capture methods for data refresh
• Summary management and implement materialized views
• Role of warehouse metadata
• Data warehouse implementation considerations

Ce subiecte abordează cursul

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.

You will learn how 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

Ce abilități se dobândesc în urmă cursului

• -