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 applicable use cases.
- Distinguishing between OLTP and OLAP workloads.
- Core components of an Oracle DW solution.
Warehouse Schema Design
- Dimensional modelling using star and snowflake schemas.
- Structure and role of fact and dimension tables.
- Managing slowly changing dimensions (SCD).
Data Loading and ETL Strategies
- Designing ETL processes using SQL and PL/SQL.
- Utilising external tables and SQL*Loader.
- Implementing incremental loads and CDC (Change Data Capture).
Partitioning and Performance
- Partitioning methods: range, list, and hash.
- Query pruning and parallel processing techniques.
- Partition-wise joins and associated best practices.
Compression and Storage Optimisation
- Hybrid columnar compression.
- Strategies for data archiving.
- Optimising storage to balance performance and cost.
Advanced Query and Analytics Features
- Materialised views and query rewrite capabilities.
- Analytical SQL functions (including RANK, LAG, and ROLLUP).
- Time-based analysis and real-time reporting.
Monitoring and Tuning the Data Warehouse
- Monitoring and assessing query performance.
- Managing resource usage and workload.
- Indexing strategies specific to warehousing environments.
Summary and Next Steps
Requirements
- A solid understanding of SQL and fundamental Oracle database concepts.
- Practical experience working with Oracle 12c/19c in an administrative or development capacity.
- Foundational knowledge of data warehousing principles.
Target 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
Testimonials (1)
good explanation on each points and provide assignment for practices.
