Course Outline
Introduction to Data Warehousing
- What is a data warehouse?
- Benefits of warehousing in analytics and reporting
- Oracle Database 19c support for warehousing
Oracle Data Warehouse Architecture
- Key components: source data, ETL, staging, presentation
- Star vs snowflake schemas
- Oracle tools for managing DW environments
Data Modeling Concepts
- Fact and dimension tables
- Surrogate keys and granularity
- Slowly changing dimensions (SCD) basics
Introduction to ETL Processes
- Overview of ETL and Oracle-supported tools
- Batch vs real-time loading
- Challenges in data integration and quality
Query and Reporting Concepts
- Basics of OLAP vs OLTP workloads
- How Oracle optimizes queries for data warehouses
- Introduction to materialized views and aggregates
Planning and Scaling Oracle Warehouses
- Hardware and architecture considerations
- Partitioning and compression benefits
- Oracle licensing and feature overview
Use Cases and Best Practices
- Warehouse design case studies
- Best practices for planning Oracle DW projects
- Getting started with a pilot implementation
Summary and Next Steps
Requirements
- An understanding of relational databases
- Basic knowledge of SQL
- No prior experience with Oracle data warehousing required
Audience
- Data analysts
- IT staff planning to work with Oracle data warehousing
- Business intelligence teams
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
