Oracle 9i Discoverer Users (O350) Training Course

Training Course Objectives

This practical course covers the Oracle 9i Discoverer Desktop Edition. It enables professionals and users without database skills, to perform complex queries and in depth data analysis.

This friendly one-day course provides a comprehensive insight into the Discover tool and the techniques required to use it to access and retrieve data at the work-group.

Who Should Attend

• Data Administrators
• Support Technicians
• Data Analysis Technicians
• Data Retrievers
• Report Writers

Training Course Prerequisites

• PC Fundamentals
• View Learning Path

Training Course Duration

1 Day

Training Course Contents

Introduction

• Introduction to Discoverer
• An Introduction to Databases

Getting Started

• Accessing Discoverer
• Workbooks
• Opening Existing Workbooks
• Worksheets
• Workbook Window
• Printing your Worksheets
• Page Set Up
• Scheduling Workbooks

Formatting Worksheets

• Introduction
• Multiple Item Selection
• Renaming a Worksheet
• Resizing & Rearranging Item Columns
• To Move Items in Table Worksheets
• Editing Item Headings
• Formatting the Item Header
• Formatting the Data
• Creating and formatting the Title

Manipulating Worksheets

• Introduction
• Basic Table Sorting
• Group Sorting
• Sort Table Dialogue
• Copying Items between Worksheets
• Exporting Data to Other Applications

Drilling

• Introduction
• Drilling Up and Down
• Drilling To a Related Item
• Drill to Detail in another Worksheet
• Drilling Out
• Additional Drill Options

Creating A New Workbook

• Introduction
• Editing A Worksheet
• Duplicating a Worksheet

Manipulating Data

• Introduction
• Format Exceptions
• Conditions
• Parameters
• Totals
• Percentages
• Calculation

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.