Training

How We're Different

Course Summaries

Course Logistics

Client-site Classes

Virtual Classes

Request Information

Course Surveys

Overview

Give your technical staff that competitive edge with this Oracle Discoverer Workshop.  This course introduces students to the querying and analytical capabilities of Oracle Discoverer using either the Desktop and/or web interfaces Discoverer Plus and Viewer. Students will learn to create, modify, run, and refine ad hoc queries. They will learn to view, chart, and analyze multidimensional data. They will also learn to produce individual ad hoc reports.

Course Objectives

The attendees will learn how to find the poorly-performing components of PL/SQL routines, use Oracle’s newer DEBUG routines to find problems in PL/SQL logic and how to use the latest features of the PL/SQL language such as the new optimizing compiler and collections.

Attendees Receive the Following:

• Study guide with presentations and relevant white papers
• Opportunity to ask the tough Oracle questions
• A hands-on opportunity to learn more about Oracle Discoverer

Topics Covered in the Course Include:

• Introduction
• Creating Queries
• Query Management
• Modifying the Display
• Working with Conditions and Parameters
• Working with Exceptions and Calculations
• Working with Sorts, Totals, and Percentages
• Drilling the Data
• Graphing Data
• Workbook Maintenance
• Working with SQL and Setting Options
• Using SQL Functions in Discoverer

Lectures and topics are enhanced with live illustrations and hands-on exercises.

Prerequisites

Delivery Options