Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle9i Discoverer Desktop
Oracle Training Overview

This class 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.

This class will present a thorough knowledge of the Discoverer Desktop tool. Thereafter each user can learn to apply this knowledge to the company's internal data model.

NOTE: Administrators are required to attend this 2-day session first!

Oracle Training Prerequisites

None.

Suggested Next Courses

The course Oracle 9i Discoverer Administrator

Oracle Training Audience

End users and Administrators using Discoverer on the Desktop

Oracle Training Course duration

2 Days

Oracle Training Course outline

CREATING QUERIES

  • STARTING DISCOVERER DESKTOP
  • COMMAND LINE OPTIONS
  • ONLINE HELP
  • THE WORKBOOK WIZARD
  • THE RESULTS WINDOW
QUERY MANAGEMENT
  • MANAGING WORKBOOKS
  • ADDING AND DUPLICATING WORKSHEETS
  • MOVING/COPYING WORKSHEETS
  • EDITING WORKSHEETS
  • RENAMING AND DELETING WORKSHEETS
  • 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, DISABLING 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, DISABLING EXCEPTIONS
  • CREATING AND EDITING EXCEPTIONS
  • WORKING WITH CALCULATIONS
  • VIEWING, DISPLAYING, HIDING CALCULATIONS
  • CREATING CALCULATIONS USING THE EDIT CALCULATION DIALOG
  • CREATING CALCULATIONS USING THE ANALYSIS BAR
  • EDITING CALCULATIONS
WORKING WITH SORTS, TOTALS, PERCENTAGES
  • CREATING COLUMN SORTS
  • CREATING GROUP SORTS
  • THE SORT TABLE DIALOG
  • WORKING WITH TOTALS
  • VIEWING, DISPLAYING, HIDING TOTALS
  • 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
  • DRILLING UP AND DOWN
  • DRILLING FROM THE WORKBOOK WINDOW
  • 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 EMAIL
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
INTRODUCTION TO ANALYTIC FUNCTIONS (OPTIONAL)


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy