• Oracle 21c Data Warehousing Fundamentals

Oracle 21c Data Warehousing Fundamentals

The Oracle 21c Data Warehousing course provides step-by-step instructions on how to perform a variety of introductory right through to advanced 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 19c Data Warehouse Technology Stack
  • Understand the Oracle 19c Multitenant Architecture for Data Warehousing
  • Understand the Oracle 19c 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 19c 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

Write a review

Please login or register to review

Oracle 21c Data Warehousing Fundamentals

  • Brand: Weblearning Publishing
  • Product Code: Oracle 21c Data Warehousing Fundamentals
  • Reward Points: 100
  • Availability: In Stock
  • £89.99
  • £69.99

  • Price in reward points: 1200

Available Options


Related Products

Oracle Database SQL Workshop

Oracle Database SQL Workshop

Oracle Database SQL Workshop  This course is a combination of Oracle Database: SQL Workshop ..

£72.99 £89.99

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL CBT

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL eLearning

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£59.99 £79.99

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL Training Guide

Oracle Database Design and Programming with SQL This covers the Data Modelling and Database Devel..

£23.99 £29.99

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning

Oracle Database 12c Performance Management and Tuning The Oracle Database 19c: Performance Manage..

£79.99 £99.99

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation

Oracle Database 12/19c Essentials Certified Implementation The Oracle Database 12/19c Essentials ..

£169.99 £329.99

SQL Server 2022 Database Administration Workshop

SQL Server 2022 Database Administration Workshop

SQL Server 2022 Database Administration Workshop This course is designed for beginners and interm..

£79.99 £99.99

SQL Server Database Modelling and Design

SQL Server Database Modelling and Design

SQL Server Database Modelling and Design The SQL Server Database Modelling and Relational Databas..

£64.99 £89.99

Database Administration Unlimited

Database Administration Unlimited

Database Administration Unlimited Cloud Learning SubscriptionThe Database Administration Unlimited C..

£320.00 £355.00

Oracle Database 23ai Data Warehousing Fundamentals

Oracle Database 23ai Data Warehousing Fundamentals

Oracle 23ai Data Warehousing Fundamentals This course introduces students to the Oracle Database ..

£110.99 £129.99

Oracle Database 23ai SQL Workshop

Oracle Database 23ai SQL Workshop

Oracle Database 23ai: SQL Workshop This course is designed for Developers and Database Administra..

£84.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals CBT

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals eLearning

Oracle Database 19c Data Warehousing Fundamentals This course introduces students to the Oracle D..

£79.99 £99.99

Oracle Database Administration for Microsoft SQL Server DBAs

Oracle Database Administration for Microsoft SQL Server DBAs

Oracle Database Administration for Microsoft SQL Server DBAs The Oracle Database Administration f..

£91.99 £129.99

IBM DB2 Database Administration for SQL Server DBA's

IBM DB2 Database Administration for SQL Server DBA's

IBM DB2 Database Administration for SQL Server DBA's The IBM DB2 Administration for SQL Server&nb..

£89.99 £119.99

Microsoft SQL Server Database Administration for Oracle DBAs

Microsoft SQL Server Database Administration for Oracle DBAs

Microsoft SQL Server Database Administration for Oracle DBAs The Microsoft SQL Server Database Ad..

£84.99 £129.99

Fundamentals of the Java Programming Language, Java SE

Fundamentals of the Java Programming Language, Java SE

Fundamentals of the Java Programming Language, Java SE This course will assist in preparation for..

£59.99 £69.99

SQL Server Data Warehousing Fundamentals

SQL Server Data Warehousing Fundamentals

SQL Server Data Warehousing Fundamentals The Microsoft SQL Server Data Warehousing Fundamentals c..

£69.99 £89.99

SQL Server 2019 Database Administration Workshop

SQL Server 2019 Database Administration Workshop

SQL Server 2019 Database Administration Workshop This course is designed for beginners and interm..

£79.99 £99.99

Data Science Unlimited

Data Science Unlimited

Data Science Unlimited Cloud Learning SubscriptionThe Data Science Unlimited Cloud Learning Sub..

£310.00 £348.00

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited

AI & Machine Learning Unlimited Cloud Learning SubscriptionThe Machine Learning Unlimited C..

£310.00 £348.00

Big Data Unlimited

Big Data Unlimited

Big Data Unlimited Cloud Learning SubscriptionThe Big Data  Unlimited Cloud Learning Subsc..

£365.00 £399.00

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training Appliance

Big Data & Data Science VM Training ApplianceThis Big Data & Data Science VM Training Applia..

£249.00 £279.00

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171

Oracle Database 23ai SQL & PL/SQL Development Workshop - 1Z0-171 This course introduces stude..

£124.00 £149.99

Tags: Database Management, Oracle Database, DB2, SQL, DBA, Business Intelligence, Data Warehousing