Building a Data Warehouse with Oracle
(ORWARE, Live Instructor-Led Training, 5 days)


Description

This SETC Certified course focuses on the art, functionality and application of Data Mining and Data Warehousing as performed within an Oracle OLAP database environment. Beginning with the definitions of facts and dimensions, the course discusses every aspect of the Data Warehouse creation process from data loading to data mining. Implementing a data warehouse has never been this intuitive.

Dates and Pricing


Jan 22 to Jan 26, 2018$3,000/person Feb 19 to Feb 23, 2018$3,000/person Mar 19 to Mar 23, 2018$3,000/person

Outline

Data Warehousing
What is a Data Warehouse?
Oracle Data Warehouse Features
Challenges of Building a Data Warehouse
Essential Data Warehouse Concepts
Data Warehouse versus Data Mart
Where is Data Warehouse Going?
About the Oracle Warehouse Builder
Designing a Data Warehouse
About Dimensional Modeling
Dimension Tables and Fact Tables
Warehouse Keys
Data Warehouses and Normalization
Management and Performance Considerations
Implementing the Data Warehouse
The Topology of the Design
The Database Configuration Assistant
Data Files, Tablespaces and Schemas
Creating the Fact and Dimension Tables
Indexing and Partitioning
Testing the Design
Architecture
The Hardware Configuration
Hardware Components
Automatic Storage Management
File Management
The Physical Design
Data Partitioning
Indexing
IOTs
Data Compression
Loading Data
Extracting Data from the OLTP System
Transforming Data
Loading the Warehouse
Oracle Database Transformations
Postload Operations
Commonly Used Tools
Querying
The Query Optimizer
Parallel Execution
Data Warehouse Specific SQL
Summary Management
About Summary Tables
Planning the Physical Storage
Creating a Materialized View
Refreshing the Materialized View
Partitioning and Indexing
The EXPLAIN_MVIEW Utility
Dimensions
About Dimensions
Creating a Dimension
Single and Multiple Hierarchies
Adding Attributes
Dimensions and Normalized Tables
Dimension Validation
Query Rewrite
What is Query Rewrite
Overview of Rewrite Types
SQL Text Match
Join Back
Adding Aggregations
Filtered Data
Dimensions
Constraints
Integrity Modes
Partitioning Change Tracking
Advanced Query Rewrite Options
Tuning Query Performance
Monitoring Performance
Advisor Central
SQL Access Advisor
SQL Tuning Advisor
Memory Advisor
OLAP
Overview of Oracle OLAP
ROLAP and MOLAP
OLAP Architecture
Analytic Workspaces
The OLAP Catalog
The Analytic Workspace Manager
Querying Analytic Workspaces
Oracle Data Mining
Overview of Oracle Data Mining
Association Rules
Clustering
Feature Extraction
Classification
Regression
The PMML Standard
Final Case Study : The ChoquetteTech Data Warehouse