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
Oracle AS Discoverer 10g Create Queries and Reports
Oracle Training Overview

This Oracle 10g courseware training guide book will teach students the purpose and capabilities of the Discoverer 10g AS tool. Thereafter each user can learn to apply this knowledge to the company's internal data model

Oracle Training Audience

This courseware is delivered as printed materials to teach end users and administrators in two different environments:
  • For students learning in a client/server desktop environment, please select the "Desktop" option from the store
  • For students learning in a web environment (Discoverer Plus/Viewer), please select the "Web" option from the store
Oracle Training Prerequisites

The course Oracle Database 10g: Introduction to SQL - Complete Library

Oracle Training Suggested Next Courses

The course: Oracle Discoverer 10g: Develop An EUL

Oracle Training Course duration

2 Days

Oracle Training Course outline

DATA ANALYSIS REVIEW
  • WHAT IS DATA ANALYSIS
  • INTRODUCTION TO ORACLE10G DISCOVERER
  • DISCOVERER COMPONENTS
  • IMPORTANT TERMINOLOGY
  • THE TRAINING ENVIRONMENT
CREATING QUERIES
  • STARTING DISCOVERER AS
  • ONLINE HELP
  • THE WORKBOOK WIZARD
  • THE RESULTS WINDOW
QUERY MANAGEMENT
  • MANAGING WORKBOOKS
  • SAVING WORKBOOKS
  • OPENING WORKBOOKS
  • DELETING WORKBOOKS
  • SHARING WORKBOOKS
  • MANAGING WORKSHEETS
  • MOVING/COPYING WORKSHEETS
  • EDITING WORKSHEETS
  • RENAMING AND DELETING WORKSHEETS
MODIFYING THE DISPLAY
  • ADDING A REPORT TITLE
  • ADDING A REPORT FOOTER
  • PRINT PREVIEW/PAGE SETUP OPTIONS
  • PAGE SETUP OPTIONS
  • FORMATTING HEADINGS
  • MODIFYING HEADING PROPERTIES
  • FORMATTING DATA
  • CHANGING DEFAULT COLUMN SIZE
  • MODIFYING DATA DISPLAY PROPERTIES
  • SETTING HEADING AND DATA FORMAT DEFAULTS
WORKING WITH CONDITIONS AND PARAMETERS
  • WORKING WITH CONDITIONS
  • VIEWING, APPLYING, DISABLING CONDITIONS
  • CREATING NEW CONDITIONS
  • USING THE NEW CONDITION DIALOG
  • MULTIPLE AND NESTED FORMULA CONDITIONS
  • 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
  • EDITING PARAMETERS
WORKING WITH CONDITIONAL FORMATS AND CALCULATIONS
  • WORKING WITH CONDITIONAL FORMATS
  • HOW CONDITIONAL FORMATS ARE USED
  • VIEWING, APPLYING, DISABLING EXCEPTIONS
  • CREATING AND EDITING CONDITIONAL FORMATS
  • WORKING WITH CALCULATIONS
  • VIEWING, DISPLAYING, HIDING CALCULATIONS
  • CREATING CALCULATIONS USING THE EDIT CALCULATION DIALOG
  • CREATING CALCULATIONS USING THE TOOL BAR
  • EDITING CALCULATIONS
WORKING WITH SORTS, TOTALS, AND PERCENTAGES
  • WORKING WITH SORTS
  • 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 TOOL BAR TO CREATE PERCENTAGES
  • DRILLING THE DATA
  • USING DRILLS IN DISCOVERER
  • DRILLING FROM THE WORKBOOK WINDOW
  • USING THE DRILL DIALOG
  • SPECIFYING DRILL OPTIONS
  • DRILLING TO EXTERNAL APPLICATIONS
GRAPHING DATA
  • CREATING A GRAPH
  • SELECTING A GRAPH TYPE
  • THE GRAPH WINDOW
WORKBOOK MAINTENANCE
  • SCHEDULING WORKBOOKS
  • SCHEDULE WORKBOOK DIALOG
  • SCHEDULING MANAGER
  • OPENING SCHEDULED WORKBOOKS
  • EXPORTING DISCOVERER OUTPUT
  • USING THE EXPORT DIALOG
WORKING WITH SQL AND SETTING OPTIONS
  • VIEWING, EXPORTING, AND IMPORTING SQL
  • THE SQL INSPECTOR/PLAN DISPLAY
  • SETTING DISCOVERER OPTIONS
  • GENERAL OPTIONS
  • QUERY GOVERNOR OPTIONS
  • SHEET OPTIONS
  • FORMAT OPTIONS
  • ADVANCED OPTIONS
  • EUL OPTIONS
USING SQL FUNCTIONS IN DISCOVERER
  • USING FUNCTIONS IN DISCOVERER
  • FUNCTION CATEGORIES
  • TYPES OF FUNCTIONS
  • STRING FUNCTIONS
  • CHARACTER STRING FORMATTING FUNCTIONS
  • CHARACTER STRING MANIPULATION FUNCTIONS
  • NUMERIC FUNCTIONS
  • NUMERIC COMPARISON AND PRESENTATION FUNCTIONS
  • DATE FUNCTIONS
  • DATE RECALCULATION FUNCTIONS
  • NESTING FUNCTIONS
  • USING ANALYTIC FUNCTIONS
INTRODUCTION TO DISCOVERER VIEWER
  • WHAT IS DISCOVERER VIEWER
  • STARTING DISCOVERER VIEWER
  • USING DISCOVERER VIEWER
  • DIFFERENCES BETWEEN DISCOVERER PLUS AND DISCOVERER VIEWER
INTRODUCTION TO DISCOVERER DESKTOP INTERFACES (OPTIONAL)
  • DISCOVERER DESKTOP
  • USING DISCOVERER DESKTOP
  • COMPARE/CONTRAST PLUS AND DESKTOP
  • PREPARING FOR PRACTICE EXERCISES
  • WORKSHOP SYSTEM REQUIREMENTS
  • EXTRACTING THE STUDENT FILES
  • PREPARING TO RUN THE SQL SCRIPTS
  • CREATING STUDENT ACCOUNTS
  • CREATING THE CAMP_SRC SCHEMA
  • BUILDING THE END USER LAYER AND BUSINESS AREA
  • SETTING SECURITY AND PRIVILEGES
  • REGISTERING THE SALES_TAX() FUNCTION
  • COPYING THE SAMPLE WORD DOCUMENT
  • TESTING THE SETUP

 
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