Get in Touch
 Duration 21 hours

Course Outline

Overview of Oracle Data Warehousing

  • Data warehouse architecture and practical applications
  • Distinctions between OLTP and OLAP workloads
  • Essential components of an Oracle DW solution

Designing Warehouse Schemas

  • Dimensional modeling approaches: star and snowflake schemas
  • Structure and use of fact and dimension tables
  • Managing slowly changing dimensions (SCD)

Data Ingestion and ETL Methodologies

  • Architecting ETL processes utilizing SQL and PL/SQL
  • Implementing external tables and SQL*Loader
  • Executing incremental loads and Change Data Capture (CDC)

Partitioning Strategies and Performance

  • Various partitioning techniques: range, list, and hash
  • Utilizing query pruning and parallel processing capabilities
  • Best practices for partition-wise joins

Compression and Storage Efficiency

  • Application of hybrid columnar compression
  • Strategies for data archival
  • Balancing storage optimization for enhanced performance and cost efficiency

Advanced Querying and Analytical Capabilities

  • Use of materialized views and automatic query rewrite
  • Employing analytical SQL functions (RANK, LAG, ROLLUP)
  • Performing time-based analysis and generating real-time reports

Data Warehouse Monitoring and Optimization

  • Tracking and analyzing query performance
  • Managing resource usage and workloads
  • Developing indexing strategies suitable for warehousing environments

Recap and Future Pathways

Requirements

  • Proficiency in SQL and fundamental Oracle database concepts
  • Professional experience with Oracle 12c/19c in either administrative or development capacities
  • Foundational knowledge of data warehousing principles

Target Audience

  • Developers specializing in data warehouses
  • Database administrators
  • Business intelligence specialists

Number of participants


Price per participant

Testimonials (1)

Upcoming Courses

Related Categories