Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Oracle Data Warehousing
- Data warehouse architecture and practical use cases.
- Distinctions between OLTP and OLAP workloads.
- Core components of an Oracle DW solution.
Warehouse Schema Design
- Dimensional modeling: implementing star and snowflake schemas.
- Structuring fact and dimension tables.
- Managing slowly changing dimensions (SCD).
Data Loading and ETL Strategies
- Designing ETL processes using SQL and PL/SQL.
- Leveraging external tables and SQL*Loader.
- Implementing incremental loads and CDC (Change Data Capture).
Partitioning and Performance
- Exploring partitioning methods: range, list, and hash.
- Techniques for query pruning and parallel processing.
- Partition-wise joins and associated best practices.
Compression and Storage Optimization
- Utilizing hybrid columnar compression.
- Strategies for data archival.
- Balancing storage optimization for performance and cost efficiency.
Advanced Query and Analytics Features
- Employing materialized views and query rewrite capabilities.
- Applying analytical SQL functions (RANK, LAG, ROLLUP).
- Conducting time-based analysis and enabling real-time reporting.
Monitoring and Tuning the Data Warehouse
- Monitoring query performance metrics.
- Managing resource usage and workload distribution.
- Developing indexing strategies specific to warehousing.
Summary and Next Steps
Requirements
- Solid understanding of SQL and Oracle database fundamentals.
- Hands-on experience with Oracle 12c/19c in administrative or development roles.
- Foundational knowledge of data warehousing concepts.
Audience
- Data warehouse developers.
- Database administrators.
- Business intelligence professionals.
21 Hours
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 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
