Oracle9i Discoverer Desktop

Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 2 Days
Call: +971 4 5490356

Course details

This course will teach students the purpose and capabilities of the Discoverer 9i Desktop tool. Users learn to create fully customized ad-hoc queries. They will also learn how to modify the display, drill to data at several levels, analyze the data graphically, and perform other various tasks such as scheduling, importing and exporting workbooks. Administrators should attend this course first.

Prerequisites:

The target audience for this course is end users and administrators of the Oracle 9i Discoverer Desktop tool.

There are no prerequisites to this course

Creating queries:

Starting discoverer desktop
Command line options
Online help
The workbook wizard
The results window

Query management:

Managing workbooks
Adding and duplicating workbooks
Moving/copying workbooks
Editing workbooks
Renaming and deleting workbooks
Managing items

Modifying the display:

Adding a report title
Page setup options
Formatting headings
Changing heading text
Modifying heading properties
Formatting data
Changing default column size
Displaying images in background
Modifying data display properties
Printing the report

Working with conditions and parameters:

Viewing, applying, displaying conditions
Creating new conditions
Using the new condition dialog
Multiple and nested formula conditions
Subqueries
Create conditions using the Analysis bar
Editing conditions
Working with parameters
Viewing, applying and disabling parameters
Creating new parameters
Executing the query with the parameter wizard

Working with exceptions and calculations:

How exceptions are used
Viewing, applying and disabling exceptions
Creating and editing exceptions
Working with calculations
Viewing, displaying and hiding calculations
Creating calculations using the edit calculation dialog
Creating calculations using the analysis bar
Editing calculations

Working with sorts, totals and percentages:

Creating column sorts
Creating group sorts
The sort table dialog
Working with totals
Viewing, displaying, hiding tools
Creating/editing totals using the total dialog
Working with percentages
Viewing, displaying, hiding percentages
Creating/editing percentages
Using the percentage dialog
Using the analysis bar to create percentages

Drilling the data:

Using the drill dialog
Specifying drill options
Drilling to a related item
Drilling to details in another sheet
Drilling to external applications

Graphing data:

Creating a graph
Selecting a graph type
The graph window
Customizing the graph
3D view properties
Scale and numbers
Editing the graph

Workbook maintenance :

Scheduling workbooks • Schedule workbook dialog • Scheduling manager • Opening scheduled workbooks • Exporting discoverer output • Using the export dialog • Sending workbooks via e-mail

Working with SQL and setting options:

Viewing, exporting and importing SQL
The SQL inspector and plan display
Setting discoverer options
General options
Query governor options
Table/crosstab options
Format options
Cache options
Advanced options
EUL options
Connection options

Using SQL functions in discoverer :

Function categories
Types of functions
String functions
Numeric functions
Numeric comparison and presentation functions
Date functions
Nesting a function

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current Oracle jobs in UAE