Oracle 23ai Data Warehousing Virtual Machine Training Appliance

This Oracle 23ai Data Warehousing VM Training Appliance is a Oracle 23ai Data Warehousing CBT course bundled with a 23ai Database Virtual Machine - VM Training Appliance for practical hands-on training purposes.

This course introduces students to the Oracle Database 23ai Data Warehousing Architecture technology. This course covers all aspects of the AI architecture, providing detailed information on the components of a CDB and its regular and application PDBs. You learn why and how to create and manage a data warehouse in its regular and analytics PDBs, with storage structures appropriate for Data Warehousing applications.

The Virtual Machine Training Appliance is a hands-on Lab designed to complement our Oracle Database 23ai Data Warehousing CBT and eLearning titles; it is delivered in either Oracle Virtual Box (ova) or VMWare format.

The Oracle Database 23ai Data Warehousing Virtual Machine Training Appliance is bundles Oracle Database 23ai VM software with our Oracle Oracle Database 23ai Data Warehousing  Computer Based Training - CBT courses.

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

• Define the terminology and explain the basic concepts of Oracle Artificial Intelligence
• Define the terminology and explain the basic concepts of data warehousing
• Understand the Oracle Data Warehouse Technology Stack
• Understand the Oracle Data Warehouse Reference Architecture
• 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
• 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