Oracle 10g BI Discoverer Plus (O1037) Training Course

Training Course Objectives

This practical course covers Oracle Discoverer Plus and is applicable to 4i, 9i and 10g release 1 users.

Oracle Discoverer enables professionals and users without database skills to perform complex queries and in depth data analysis.

This one-day course provides a comprehensive insight into the Discoverer tool and the techniques required to use it to access and retrieve data.

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
• Renaming a Worksheet
• Rearranging Item Columns
• To Move Items in Table
• Worksheets
• Formatting the Item Header
• Formatting the Data

Manipulating Worksheets

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

Graphs

• Introduction
• Creating a Graph
• Editing the Graph
• Formatting the Graph
• Chart Types

Creating a New Workbook

• Introduction
• Editing a Worksheet
• Duplicating a Worksheet
• Drilling
• Drilling Up and Down

Manipulating Data

• Introduction
• Conditions
• Parameters
• Totals
• Percentages
• Calculation

Introduction to Discoverer

• Opening reports
• Formatting reports

Next Available Dates

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