Oracle Database Data Warehousing Concepts

Descrizione del corso

This course covers the core concepts of Oracle Database Data Warehousing, including data warehouse architecture, multidimensional models, and the ETL process. Participants will explore business, logical, dimensional, and physical models, learn to create analytic views in SQL Developer, and gain hands-on experience with Oracle Data Integrator (ODI). The course provides a solid foundation in data warehousing platforms and tools, preparing you to manage and optimize data-driven solutions.

Programma

Evolution of Information Management and Data Warehousing

• Business Intelligence: Requirements

Overview of Data Warehouse and Multidimensional Model Concepts

• Data Warehouse Architectures
• Data Warehousing Process Components
• Creating Analytic Views in SQL Developer

About Business, Logical, Dimensional, and Physical Models

• About Business, Logical, Dimensional, and Physical Models
• Determining Granularity
• Primary Key and Foreign Key

Introduction to Extracting, Transforming, Loading Data

Introduction to Data Warehousing Platforms and Tools

Product Tour of Oracle Data Integrator (ODI)