Oracle Cloud-Native Data Warehouse Technologies.
Utilize data warehousing on-premises or in the cloud. Data Warehousing and analytics technologies such as zero-downtime scaling, Autonomous Data Guard, Oracle Database In-Memory, Oracle Multitenant, machine learning, spatial and graph capabilities enable analytics teams to deliver deeper richer insights in less time.
Overview
This OD-19c-DWC: Oracle Database 19c: Data Warehousing Concepts course covers the following topics:
- Evolution of information management systems and data warehousing
- Need for machine learning, artificial intelligence, and big data in future data analytics
- Data warehouse concepts and terminology
- Multidimensional model concepts and create analytic views
- Explain the business, logical, dimensional, and physical data warehousing models
- Importance of extraction, transformation, and loading in data warehousing systems
Skills Covered
- Assess Data Warehousing and Business Intelligence requirements
- Create Analytic Views in SQL Developer
- Assess Business Modeling tasks
- Assess Logical and Dimensional Modeling tasks
- Assess Extraction, Transformation, and Loading tasks
Prerequisites
Good working knowledge of the SQL language.
Target Audience
- Data warehouse developers
- Data warehouse engineers
- Data warehouse analysts
- Data warehouses builders and administrators
- Data warehouse implementation team members
- Data warehouse developers
Module 1 : Course Overview
Module 2: Evolution of Information Management and Data Warehousing
- Evolution of Information Management and Data Warehousing
- Business Intelligence: Requirements
Module 3: Overview of Data Warehouse and Multidimensional Model Concepts
- Overview of Data Warehouse and Multidimensional Model Concepts
- Data Warehouse Architectures
- Data Warehousing Process Components
Module 4: About Business, Logical, Dimensional, and Physical Models
- About Business, Logical, Dimensional, and Physical Models
- Determining Granularity
- Primary Key and Foreign Key
Module 5: Introduction to Extracting, Transforming, Loading Data
Module 6: Introduction to Data Warehousing Platforms and Tools
Dates & Locations
August 19, 2026 - August 20, 2026
August 19, 2026 - August 20, 2026
November 25, 2026 - November 26, 2026
November 25, 2026 - November 26, 2026
Exam & Certification
This course is not associated with any Certification.
Training & Certification Guide
Frequently Asked Questions
Speak to a Training Consultant
All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631
