Loading...

Oracle 9i Discoverer Users

Course code: O350

1 days

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.

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

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.

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
Contact us for more information