Business solutions enabling people and technology

Oracle Training Courses

Navigo runs scheduled Oracle training in the major capital cities. We can also arrange training on-site.
Contact us to arrange a training time.

Discoverer

Oracle Discoverer 10g Training

Audience

This course is designed for new users of Oracle Discoverer whom have never used Oracle Discoverer previously.

Overview

By the end of this session attendees will be able to create Discoverer Reports to help gather useful information from your Oracle database and increase productivity.

Pre-requisite

No pre-requisites

Duration

1 day (8 hours)

Topics Covered

  • Why Discoverer
  • Creating your First Ad Hoc Report
  • Joining Tables in Reports
  • Formatting and Sorting
  • Parameters and Conditional Formatting
  • Page Items
  • Counts, Totals, Min and Max Values
  • Calculations

Format

This session will be held in a computer lab where each participant will be provided with their own PC.

The session instructor will use PowerPoint and will demonstrate live using Oracle Discoverer. Participants will then be given the opportunity to undertake hands on learning using Oracle Discoverer.

Max Attendees

8 people

Return to top


Discoverer 10g Administrator and Advanced Reporting Techniques

Audience

This course is designed for experienced Discoverer users and will explain advanced Discoverer techniques including how to customise the End User Layer via Discoverer Administrator and how to create advanced Discoverer Report using complex calculations and PL/SQL functions.

Overview

By the end of this session attendees will be able to create more advanced Discoverer Reports and have the ability to manage the End User Layer from Discoverer Administrator.

Pre-requisite

It is assumed participants have prior knowledge of:

  • Basic Discoverer Reports Development
  • Basic knowledge of calculations, parameters and other Discoverer features

Duration

1 day (8 hours)

Topics Covered

  • Introducing the Discoverer End User Layer
  • Creating custom Business Areas
  • Creating Folders
  • Custom and Complex Folders
  • Joining Folders
  • Registering PL/SQL functions from Discoverer Administrator to be used from Discoverer calculations
  • Custom folders that use complex PL/SQL packages
  • Creating smart workbooks with the ability to link worksheets

Format

This session will be held in a computer lab where each participant will be provided with their own PC.

The session instructor will use PowerPoint and will demonstrate live using Discoverer and Discoverer Administrator. Participants will then be given the opportunity to undertake hands on learning using Oracle Discoverer and Administrator.

Max Attendees

8 people

Return to top