ADVANCE YOUR CAREER. TRANSFORM YOUR LIFE WITH IN-DEMAND SKILLS FOR AN ON.DEMAND WORLD. EARN MINIMUM £55K WITH YOUR ORACLE DATA WAREHOUSING SKILLS.

 


EXCELLENT INTERACTIVE SELF-TEACH TRAINING COURSE . IDEAL FOR THOSE DESIGNING AND DEVELOPING ANALYTICS, BUSINESS INTELLIGENCE AND DATA WAREHOUSING SOLUTIONS IN AN ORACLE DATABASE 12.x ENVIRONMENT. EXCELLENT FOR ORACLE ANALYTIC APPLICATIONS DEVELOPERS, DATA SCIENTISTS, BIG DATA ARCHITECTS AND ENTERPRISE PERFORMANCE MANAGEMENT CONSULTANTS, ORACLE RETAIL BANKING, ORACLE UTILITIES AND EBS R12.x DATA WAREHOUSE CONSULTANTS; BUSINESS INTELLIGENCE AND DATA WAREHOUSE CONSULTANTS LOOKING TO CROSS TRAIN TO ORACLE DATA WAREHOUSE  MANAGEMENT ENVIRONMENT.

 

ALSO GOOD FOR ANALYSTS, IT DEVELOPERS/CONSULTANTS WHO WISH TO CROSS TRAIN/UPSKILL  FROM MICROSOFT SQL-SERVER, IBM DB2, SAP BW TO A ORACLE DATA WAREHOUSE ENVIRONMENT.

VERY GOOD HANDS-ON TRAINING MATERIAL WITH REAL-LIFE BASED TASKS, ACTIVITIES AND EXERCISES.


ORACLE DATABASE 12c: DATA WAREHOUSING FUNDAMENTALS SELF-STUDY CBT

How This Course Is Organised

This Oracle Database 12c: Data Warehousing Fundamentals training will teach you about the basic concepts of a data warehouse. Explore the issues involved in planning, designing, building, populating and maintaining a successful data warehouse.

The course begins with an introduction to fundamental concepts related to Data Warehousing, Business Intelligence, OLAP and Predictive Analytics / Data mining. You'll also explore the basics of Oracle’s Database partitioning architecture, identifying the benefits of partitioning. In addition, you will review the benefits of parallel operations to reduce response time for data-intensive operations. Learn how to extract, transform and load data (ETL) into an Oracle database warehouse using Oracle Data Integrator 11g..

Learn the benefits of using Oracle’s materialized views to improve the data warehouse performance. Instructors will give a high-level overview of how query rewrites can improve a query’s performance. Explore OLAP and Data Mining and identify some data warehouse implementations considerations.

The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.

Audience
Application Developers
Data Warehouse Administrator
Data Warehouse Analyst
Data Warehouse Developer
Developer
Functional Implementer
Project Manager
Support Engineer


Suggested Prerequisites
WebLearning Business Intelligence Fundamentals
WebLearning  Oracle Data Integrator 11g ETL Fundamentals
Knowledge of relational server technology


Course Objectives:
Upon completion of this Course, you should be able to:
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 11g 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



Course Topics

Introduction to Oracle Database12c
Oracle Database12c Options
Database Management Packs
Oracle Database 12c Related Products

Oracle Database12c Development Tools
Oracle SQL Developer
Navigate SQL Developer
Exploring Database Objects
SQL*Plus and SQL Workshop

Connecting to the  SQL*Plus Interface
Connecting to Databases
Configuring Database Environment

Introduction to Data Warehousing and Analytics Concepts
Understanding ETL and Data Warehousing
Understanding Business Intelligence
Understanding OLAP and Data Mining

BI and Warehouse Architecture Framework    
Data Sources    
Data Access, Transformation, Cleansing    
Staged Data    
Business Subject Data    
Multidimensional Data    
Backup, Archive Data    
Structured Query Language and OLAP Engine    
Business Intelligence Applications    
Administration, Automation, Operation, Control    
Metadata Repository    
Visualisation and Publishing

Oracle Data Warehouse Components
Data Warehouses, Business Intelligence, Data Marts, and OLTP
Typical Data Warehouse Components
Warehouse Development Approaches
Extraction, Transformation, and Loading (ETL)
The Dimensional Model and Oracle OLAP
Oracle Warehouse Builder
Oracle Data Integrator
Oracle Database OLAP Option
Oracle Data Mining
Oracle BIEE
Oracle BI Publisher

Data Warehouse Concepts and Terminology
Data Warehouse Definition and Properties
Data Warehouse Versus OLTP
Data Warehouses Versus Data Marts
Typical Data Warehouse Components
Data Warehousing Process Components

Data Warehousing and Modelling Concepts    
Data Warehousing Concepts    
Modelling for Analytics and Data Warehouses    
Normalisation    
3rd normal Form    
Dimensional Modelling    
Fact tables    
Types of Fact Tables    
Dimension Tables    
Star Schema    
Snowflake Models    
Conformed Dimensions    
Alternate Dimensions    
Degenerate Dimensions    
Junk Dimensions    
Slowly Changing Dimensions    
Surrogate keys
   
Data Warehousing Deployment Approaches
Warehouse Bus Architecture
Centralised Data Warehouse Approach
Hub and Spoke Approach
   
Approach to Oracle Data Warehouse and  ETL Projects
Strategy and Planning Phase
Discover Phase
Analyse Phase
Define Phase
Develop Phase
Deploy Phase

Oracle Data Warehouse Implementation Approach
Project Management
Requirements Specification or Definition
Logical, Dimensional, and Physical Data Models
Data Warehouse Architecture
ETL, Reporting, and Security Considerations
Metadata Management
Testing the Implementation and Post Implementation Change Management

Modelling the Data Warehouse:Logical Model
Business, Logical, Dimensional, and Physical Modeling
Data Warehouse Modeling Issues
Defining the Business Model
Defining the Logical Model
Defining the Dimensional Model

Modelling the Data Warehouse:Physical Model
Defining the Physical Model
Star, Snowflake, and Third Normal Form
Fact and Dimension Tables Characteristics
Translating Business Dimensions into Dimension Tables
Translating Dimensional Model to Physical Model

Database Sizing, Storage, Performance, and Security Considerations
Database Sizing and Estimating and Validating the Database Size
Oracle Database Architectural Advantages
Data Partitioning
Indexing
Optimizing Star Queries
Tuning Star Queries
Parallelism
Security in Data Warehouses
Oracle  Data Warehouse Security

The ETL Process: Extracting Data
Extraction, Transformation, and Loading (ETL) Process
ETL: Tasks, Importance, and Cost
Extracting Data and Examining Data Sources
Mapping Data
Logical and Physical Extraction Methods
Extraction Techniques and Maintaining Extraction Metadata
Possible ETL Failures and Maintaining ETL Quality
Oracle’s ETL Tools
Oracle Data Integrator
Data Oracle Warehouse Builder
SQL*Loader
Data Pump

The ETL Process: Transforming Data
Transformation
Remote and Onsite Staging Models
Data Anomalies
Transformation Routines
Transforming Data: Problems and Solutions
Quality Data: Importance and Benefits
Transformation Techniques and Tools
Maintaining Transformation Metadata

The ETL Process: Loading Data
Loading Data into the Warehouse
Transportation Using Flat Files, Distributed Systems, and Transportable Tablespaces
Data Refresh Models: Extract Processing Environment
Building the Loading Process
Data Granularity
Loading Techniques Provided by Oracle
Loading Techniques in Oracle Data Integrator 11g
Postprocessing of Loaded Data
Indexing and Sorting Data and Verifying Data Integrity

Refreshing the Warehouse Data
Developing a Refresh Strategy for Capturing Changed Data
User Requirements and Assistance
Load Window Requirements
Planning and Scheduling the Load Window
Capturing Changed Data for Refresh
Time- and Date-Stamping, Database triggers, and Database Logs
Applying the Changes to Data

Materialized Views
Using Summaries to Improve Performance
Using Materialized Views for Summary Management
Types of Materialized Views
Build Modes and Refresh Modes
Query Rewrite: Overview
Cost-Based Query Rewrite Process
Working With Dimensions and Hierarchies

Metadata  Management
Defining Warehouse Metadata
Metadata Users and Types
Examining Metadata: ETL Metadata
Extraction, Transformation, and Loading Metadata
Defining Metadata Goals and Intended Usage
Identifying Target Metadata Users
Choosing Metadata Tools and Techniques
Integrating Multiple Sets of Metadata
Managing Changes to Metadata



NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY TRAINING GUIDE, E-LEARNING OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE OR E-LEARNING OR TRAINING GUIDE FORMAT. PRICES DIFFER


What is Computer Based Training - CBT?
Computer Based Training - CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice..

Generally, CBT's tend to be more expensive. This Publisher's CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Training Guide Learning formats are delivered with FULL LICENCE KEY.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

NOTE: WebLearning Publishing CBT and Training Guide products are now delivered with FULL LICENCE KEY.


The WebLearning unique Methodology

All WebLearning® Training Guide courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. You need to register your product to qualify for FREE UPGRADES.

FACT:


TRY WEBLEARNING E-LEARNING DEMOS TODAY:: CLICK HERE

LOOKING FOR A TRAINING GUIDE DEMO? THEN CLICK HERE

LOOKING FOR A CBT DEMO? THEN CLICK HERE