Discoverer 10g: Discoverer for Administrators (3 day)

Scheduled Dates Locations filtered. Show all UK course locations.

Course Overview

This course is designed for personnel responsible for the configuration and management of Oracle Discoverer with a relational datasource.

Audience

Personnel responsible for the configuration and management of Oracle Discoverer

Skills Gained

By the end of this course, the successful delegate will be able to:

• Create the Maintain the End User Layer
• Create and Maintain Business Areas
• Grant and Control User Access
• Understand the relationship between Application Server and Discoverer Components
• Configure Discoverer for the Web

Examinations

N/A

Prerequisites

Attendance on the Pre-Requisite courses or similar knowledge. Practical experience of Oracle Application Server Administration would be an advantage.

Prerequisite Courses

• 10g Discoverer Plus for End Users
• SQL

Course Outline

Topics Covered:

• Introduction to Discoverer Concepts
• Creating and Maintaining the EUL
• Creating Business Areas
• Managing and Developing a Business Area
• Granting Access to a Business Area
• Granting End User Privileges
• Simple, Complex and Custom Folders
• Managing Folders
• Managing Folder Items
• Importing and Exporting from the EUL
• Creating and Using Joins
• Creating and Using Calculations
• Using Custom PL/SQL Functions
• Working with Conditions
• Creating Date and Item Hierarchies
• Using Summary Folders
• Using the Automated Summary Management Feature (ASM)
• EUL Status Workbooks
• Introduction to Application Server and Discoverer
• Starting and Stopping Discoverer Services
• Managing Discoverer Connections
• Monitoring Discoverer
• Discoverer and Oracle Web Cache
• Managing Discoverer Preferences
• Discoverer URL Parameters
• Security and Discoverer

Establishing a Multiple Machine Environment

Follow On Courses

• Oracle 10g Application Server Administration
• PL/SQL
• SQL Advanced

Discoverer 10g: Discoverer for Administrators (3 day) / ODM