Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle Discoverer Training Class

Discoverer Administration & Management

An intensive 5-day Oracle Discoverer training course

This Oracle Discoverer course is taught at your Company site with up to 20 students. 

Click here for on-site course prices



Key Features

* Understand Workflow and the Discoverer viewer.

* Get started fast with Oracle Discoverer reporting

* Understand the End-User Layer.

* Create and manipulate Discoverer workbooks and worksheets.

* See tips for creating robust data warehouse schemas

* Understand OLAP and ROLAP in Plain English

* Learn how to get the most from your Oracle Data Warehouse



Course Description

This is an intensive 5-day Oracle Discoverer training course.  This Discoverer class covers both Discoverer End-user layer (EUL) (2-days) and Discoverer administration (3-days). 


Book Recommended

  Oracle Discoverer 10g Handbook

Michael Armstrong-Smith
Oracle Press

ISBN: 0072262141


This Oracle Discoverer training course is designed for practicing Oracle professionals who have basic experience with Oracle databases and wish to understand the use of Oracle discoverer for ad-hoc reporting, data aggregation and report creation.

Curriculum Design

This Oracle Discoverer training course was designed by Donald K. Burleson with many respected leaders in Oracle Discoverer technology. Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle Discoverer training.

(See also Oracle Discoverer for end-users - A fun class in ad-hoc reporting with Oracle Discoverer)

Oracle Discoverer


An intensive 5-day Oracle Forms Training course
© 2007-2016 by Donald K. Burleson



Introduction to Oracle Discoverer

·        Benefits of Discoverer

·        Components of Oracle Discoverer

·        Introducing the PUBS database

Using Discoverer Viewer

Lesson 1            Connect to a relational data source OracleBI Discoverer Viewer
Lesson 2           
Pivoting and Sorting Worksheet Items
Lesson 3           
Formatting Worksheet Items
Lesson 4           
Lesson 5            A
nalyzing Data with Graphs
Lesson 6           
Printing and Exporting a Worksheet


Using Discoverer Plus to Create Ad Hoc Queries

Lesson 1            Open an workbook
Lesson 2           
Create ad hoc queries and save workbook
Lesson 3            Create worksheet
Lesson 4            Add new worksheet
Lesson 5            Sort table data

Lesson 6            Sort crosstab data


Using Discoverer Plus to Create Ad Hoc Queries

Lesson 1            Format Data
Lesson 2            Create Totals
Lesson 3            Create Subtotals
Lesson 4            Create Percentages
Lesson 5            Drill to related item
Lesson 6            Drill up


Using Discoverer Plus to Create Advanced Ad Hoc Queries, continued

Lesson 1            Advanced drill
Lesson 2            Drill to link
Lesson 3            Using graphs

Creating a Business Area Using Discoverer Administrator

Lesson 4            Create an End User Layer
Lesson 5            Create a Business Area
Lesson 6            Exploring the Business Area


Creating a Business Area Using Discoverer Administrator, continued

Lesson 1            Access privileges
Lesson 2            Complex folders
Lesson 3            Calculations and Hierarchies
Lesson 4            Summary Management
Lesson 5            Creating summaries
Lesson 6            Testing the Business Area using Discoverer Viewer


BC is a leader in Oracle Discoverer training.



Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational