Training

How We're Different

Course Summaries

Course Logistics

Client-site Classes

Virtual Classes

Request Information

Course Surveys

Discoverer for Administrators Workshop

Overview

Give your technical staff that competitive edge with this Oracle Discoverer Workshop.  This course gives students hands-on experience with setting up Oracle Discoverer. Students will practice administrative tasks using Discoverer’s Administration Edition tool. Students will learn to create an End User Layer and create and manage business areas. They will learn how to hide the complexity of the data source and provide a user-friendly view of the data for end users.

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.

Topics Covered in the Course Include:

• Introduction to the Discoverer Administrator Interface
• Create/Manage End User Layer (EUL)
• Create/Manage Business Areas
• Create Custom Folders
• Create Data Hierarchies
• Maintaining Security and Permissions
• Import/Export Business Areas
• Import/Register PL/SQL Routines
• Creating Joins and Calculated Items
• Creating Data Points
• Parameter Passing
• Introduction to the Command-line Interface
• Working with the Generated SQL
• Setting Debug Trace
• Installation tips for the end user Web interfaces

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

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

Prerequisites

None

Delivery Options

For more information about scheduling this course or other offerings, please call us at: 1 (800) 887-4513, or e-mail us at: info@perftuning.com