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 14 hours (2 days)
Course Outline
Foundations of Data Warehousing
- Defining the role of a data warehouse.
- Advantages of warehousing for analytics and reporting.
- The role of Oracle Database 19c in supporting warehousing efforts.
Architecture of Oracle Data Warehouses
- Core components: source data, ETL, staging, and presentation layers.
- Comparing star and snowflake schema designs.
- Utilizing Oracle tools to manage DW environments.
Principles of Data Modeling
- The function of fact and dimension tables.
- Understanding surrogate keys and data granularity.
- An overview of slowly changing dimensions (SCD).
Getting Started with ETL Processes
- A general view of ETL and the Oracle tools that support it.
- Distinguishing between batch and real-time data loading.
- Addressing data integration and quality challenges.
Queries and Reporting Principles
- Understanding the differences between OLAP and OLTP workloads.
- How Oracle optimizes queries for warehouse environments.
- An introduction to materialized views and aggregate tables.
Planning and Scaling Oracle Warehouses
- Considering hardware and architectural requirements.
- The benefits of partitioning and data compression.
- An overview of Oracle licensing and available features.
Practical Applications and Best Practices
- Examining warehouse design through case studies.
- Best practices for planning Oracle DW projects.
- Initiating a pilot implementation strategy.
Recap and Future Directions
Requirements
- Familiarity with relational database systems.
- Foundational knowledge of SQL.
- No previous experience with Oracle data warehousing is necessary.
Target Audience
- Data analysts.
- IT personnel preparing to engage with Oracle data warehousing environments.
- 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 3200 € + 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.
