Oracle Data Warehousing Fundamentals

The Oracle Data Warehousing course provides step-by-step instructions on how to perform a variety of introductory right through to advanced analytics, business intelligence, data analysis, visualisation, ETL and data warehouse development tasks for activities based on real-life work scenarios.

On successful Completion of this course you will be able to:

• Define the terminology and explain the basic concepts of data warehousing
• Define the terminology and explain the basics of Oracle Big data warehousing
• Understand the Oracle Data Warehouse Technology Stack
• Understand the Oracle Multitenant Architecture for Data Warehousing
• Understand the Oracle Data Warehouse Reference Architecture
• Discuss the different Oracle tools to implement data warehousing on-premise
• Discuss Autonomous Data Warehouse Cloud (ADWC) and Data Integration Platform Cloud (DIPC)
• Understand the Oracle Business Intelligence and Analytics Technology Stack
• Describe methods and tools for extracting, transforming, and loading data
• Use Oracle Data Integrator ETL for extracting, transforming, and loading data
• Identify some of the tools for accessing and analysing warehouse data
• Understand the Oracle AI & Machine Learning Tools for data warehousing
• Identify the technology and some of the tools from Oracle to implement a successful data warehouse
• Define the decision support purpose and end goal of a data warehouse
• Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
• Understand the implementation and organisational issues surrounding a data warehouse project
• Use materialised views and query rewrite to improve the data warehouse performance
• Develop familiarity with some of the technologies required to implement a data warehouse