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.
Duration 21 hours
Course Outline
Introduction to Oracle Data Warehousing
- Data warehouse architectures and applicable use cases.
- Distinguishing between OLTP and OLAP workloads.
- Essential components of an Oracle DW solution.
Warehouse Schema Design
- Dimensional modeling techniques, specifically star and snowflake schemas.
- Structure and function of fact and dimension tables.
- Managing slowly changing dimensions (SCD).
Data Loading and ETL Strategies
- Designing ETL processes utilizing SQL and PL/SQL.
- Implementation of external tables and SQL*Loader.
- Strategies for incremental loads and CDC (Change Data Capture).
Partitioning and Performance
- Partitioning methods including range, list, and hash.
- Techniques for query pruning and parallel processing.
- Best practices for partition-wise joins.
Compression and Storage Optimization
- Hybrid columnar compression.
- Data archival strategies.
- Optimizing storage to balance performance and cost.
Advanced Query and Analytics Features
- Materialized views and query rewrite capabilities.
- Analytical SQL functions such as RANK, LAG, and ROLLUP.
- Time-based analysis and real-time reporting.
Monitoring and Tuning the Data Warehouse
- Monitoring query performance.
- Managing resource usage and workloads.
- Indexing strategies specific to warehousing.
Summary and Next Steps
Requirements
- Proficiency in SQL and core Oracle database concepts.
- Practical experience with Oracle 12c/19c in administrative or development capacities.
- Foundational knowledge of data warehousing principles.
Target Audience
- Data warehouse developers.
- Database administrators.
- Business intelligence specialists.
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
