Oracle 9i Data Warehouse Administration Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 5 Days

Course details

This course considers how to build, implement, tune and utilize data warehouses with Oracle technology. Logical data warehouse concepts are considered such as dimension tables, fact tables and star schemas. Implementing such logical concepts using the Oracle database is then presented including defining dimensions, hierarchies, measures and other objects. Physical implementation techniques are considered such as bitmap indexes, partitioned tables, materialized views, and others. Emphasis is placed on the parallel execution features of the database and how these can yield significant performance advantages. This course was formerly called "Build Oracle 9i Data Warehouses".

Prerequisites:

Introduction to Oracle 9i: SQL
Introduction to Oracle 9i: PL/SQL Language
Introduction to Oracle 9i: Advanced SQL

About Data Warehousing:

Understanding Warehouse Concepts and Terms
Contrast OLTP & Warehouse Databases

Using Materialised Views:

Enable Materialised Views & Query Rewrite
Create the Materialised View

Maintaining Materialised Views:

Maintenance Options
About the Types of Views
Altering and Dropping Views
Data Dictionary Storage

Refreshing Materialised Views:

Specifying the Default Refresh Options
Performing a Refresh on Demand
Implementing Fast Refresh

Monitor Query Rewrite with Explain Plan:

Generating the Execution Plan
Viewing the Execution Plan
Interpreting the Execution Plan

Controlling the Query Rewrite Facility:

Query Rewrite Optimiser Hints
Utilizing Constraints with Query Rewrite
Query Rewrite Integrity Levels
Query Rewrite Influences

Dimensions:

Creating & Maintaining Dimensions
Data Dictionary Storage
Dimension System-Supplied Packages

The Summary Advisor Tool:

The DBMS_OLAP() Package
Incorporating Workload Statistics
OEM Summary Advisor Wizard

Dimensional Analysis of Data:

Data Sampling Techniques
Aggregation Techniques
Building the Data Warehouse Cube

An Introduction to the Analytic Functions:

Ranking Functions
Understanding Function Execution

Incorporating Bitmap Indexes :

Star Queries & the Optimizer:

A Star Transormation Scenario
Encouraging Star Transformation

ETT Features (External Tables):

Creating & Accessing External Tables
Performance Considerations
Viewing & Altering Properties of External Tables

ETT Features (Table Functions):

Implementing a Pipelined Table Function

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Administration and Secretarial jobs in Ireland

Are you from Professional Training Solutions Ltd ? Claim your course!

Courses you can instantly connect with... Do an online course on Administration and Secretarial starting now.