Small logo
Hamburger sub menu
More
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           

Oracle Discoverer Desktop for End Users

 A hands-on two-day course with free pre-course online skills testing 
Home Quick Course Finder Oracle Oracle Developer Skills
Oracle Discoverer Desktop for End Users
SEARCH    Search

ORACLE® DISCOVERER DESKTOP FOR END USERS

Quality, flexible Developers Oracle training

We feel we provide the best oracle developer training courses you can find, so ask us if you need help

COURSE OUTLINE

Full details of modules and topics covered in this two-day course

DURATION

This is a two-day training course structured into 15 modules


COURSE AIMS

The Oracle Discoverer Desktop for End Users training course provides the skills needed to use the Oracle Discoverer Tool for processing workbooks. It introduces the concept of the Oracle Discoverer End User Layer (EUL) and how, by building and manipulating workbooks, they can perform analysis of the data sources at their disposal.

TARGET AUDIENCE

Anyone who wishes to use Oracle Discoverer to analyse data. Delegates must be able to use a Windows interface.

MODULE 1:  What Is Oracle Discoverer?
Topics covered:
  • Overview of Oracle Discoverer
  • Oracle Discoverer Components
  • Connecting to Oracle Discoverer
  • Workbooks and Worksheets
MODULE 2:  Workbook Basics
Topics covered:
  • The Discoverer Workbook Window
  • The Button Bars
  • Displaying Data
  • Selecting Worksheet Sections
  • Viewing Pages
MODULE 3:  Workbook Formatting
Topics covered:
  • Re-Ordering and Resizing Columns
  • Formatting Headings and Data
  • Using Graphic Bars
  • Worksheet Titles
MODULE 4:  Creating a Workbook
Topics covered:
  • Overview of Workbook Creation
  • Adding a Table Layout Worksheet
  • Adding a Crosstab Layout Worksheet
  • Page-Detail Worksheets
  • Duplicating Sheets
  • Worksheet Management
MODULE 5:  Conditions
Topics covered:
  • Creating and Editing a Condition
  • Creating and Using Parameters
  • Advanced Conditions
MODULE 6:  Counts and Calculations
Topics covered:
  • Creating COUNTS on a worksheet
  • Creating and Editing Calculations
  • Introduction to Oracle functions
MODULE 7:  Graphing Your Data
Topics covered:
  • Overview of Graphs in Oracle Discoverer Worksheets
  • The Graph Tool Bar
  • Creating a Graph
  • Modifying a Graph
  • Reference Lines and Pull-Outs
  • Rotating a Graph
MODULE 8:  Workbook Manipulation
Topics covered:
  • Pivoting Data
  • Drilling into Data
  • Sorting Data
MODULE 9:  Data Analysis Tools
Topics covered:
  • Overview of the Data Analysis Tools
  • Creating and Editing a Total
  • Creating and Editing a Percentage
  • Formatting Exceptions
MODULE 10:  Reports
Topics covered:
  • Printed Reports
  • Scheduled Reports
  • Using the Scheduling Manager
MODULE 11:  Advanced Features
Topics covered:
  • Subqueries
  • Correlating a Subquery
  • Setting Oracle Discoverer Options
MODULE 12:  Analytical Functions
Topics covered:
  • Introduction - Analytical Functions and their Purpose
  • Examples of Analytical Functions
  • Creating Calculations using Analytical Functions
MODULE 13:  Discoverer and The Web
Topics covered:
  • Overview of Discoverer on the Web
  • Discoverer on the Web components
  • Accessing Oracle Discoverer Workbooks
  • Running Oracle Discoverer Plus for the first time
  • Maintaining Discoverer Preferences
MODULE 14:  Discoverer and The Web Using 10GAS
Topics covered:
  • Accessing the connections page
  • Creating Private Connections
  • Using Oracle Discoverer Plus
  • Using Oracle Discoverer Viewer
MODULE 15:  Discoverer and The Web Using 9LAS
Topics covered:
  • Accessing the connections page
  • Creating Private Connections
  • Using Oracle Discoverer Plus
  • Using Oracle Discoverer Viewer
Click to REQUEST MORE INFORMATION
RELATED COURSES
Oracle Application Express - APEX

[Duration: four day]

COURSE OUTLINE

  • Introduction to Oracle Application Express
  • Sql Workshop
  • Build a Database Application
  • Create Reports
  • Pages and Regions
  • Introduction to Shared Components
  • Create Forms
  • Items and Buttons
  • Page Processing
  • Add Shared Navigation Components
  • Other Shared Components
  • Display Dynamic Content
  • Dynamic Actions and Plug-In Components
  • Session State and Debugging
  • Themes and Templates
  • Build a Websheet Application
  • Websheet Data Grids and Links
  • Administer Apex Workspaces
  • Implement Security
  • Deploy An Application
  • Utility Programs

 
Oracle Forms - Part I

[Duration: five day]

COURSE OUTLINE

  • Introduction
  • Getting Started
  • The Form Builder Interface
  • Building a Form
  • Triggers
  • Introducing Standard Built-Ins
  • More Interface Objects
  • Program Units
  • Canvases and Windows
  • Re-Using Components
  • Introduction to Calling Other Forms
  • Debug Facilities
  • Oracle Forms Services
  • Getting Started
  • Configuring Forms Services
  • Dealing With Icons and Images
  • Other Configuration Issues
  • Performance Considerations

 
Oracle Forms - Part II

[Duration: three day]

COURSE OUTLINE

  • An Introduction
  • Mouse and Key Triggers
  • Timers
  • Record Groups
  • Data Block Relationships
  • Multi-Form Applications
  • Creating Custom Menus
  • Handling Database Objects
  • Using Other Data Sources
  • Using Oracle Database Features
  • Reusable Components
  • Including Charts and Reports

 
Oracle Reports

[Duration: four day]

COURSE OUTLINE

  • Introduction to Oracle Reports Developer
  • Creating a Basic Tabular Paper Report
  • Create a Web Report
  • Managing Report Templates
  • Break Report
  • Form Report
  • Master Detail Reports
  • Layout Model Objects
  • Letters and Mailing Labels
  • Matrix Reports
  • Parameters
  • PL/SQL and Triggers In Reports
  • Report Distribution
  • Web Reporting
  • XML and Pluggable Data Sources
  • Using Graphics In a Report
  • Using Oracle Application Server Reports Services
  • Performance Issues

 

MORE INFORMATION FOR
ORACLE DISCOVERER DESKTOP FOR END USERS

General Information

All Oracle Developer Skills training courses use the latest content, qualified and experienced trainers, and provide delegates with the best learning experience. Training is interactive and classroom-based, and the ability to ask questions reinforces knowledge acquisition during the class.

Class Sizes

Maximum class sizes vary, but there is always adequate time for delegates to ask questions of the instructor.

How to book
Course, dates and delegate numbers
Decide on the Oracle Developer Skills course you want, the date(s) you can attend, and the number of delegates involved
Call us
if at any time you want help or advice, or you want to book on the telephone, just call us on 0333 6000 111 to speak to one of our friendly training advisors

Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.

Also note: If you are a private individual you must pay by credit card at the time of booking.

The confirmation process
Course places allocated
Your place is allocated, along with workbooks (and lunches if it's at our centre)
Booking confirmation
You receive an official confirmation, with joining instructions (and directions if it's at our centre)
Training invoice
You receive a VAT invoice

Note: Please allow 1 - 2 working days for your confirmation and invoice.

What happens on the day

If you are coming to our centre, dress code is smart casual.   The timetable is as follows:

9:15

ARRIVAL TIME

9:30

TRAINING STARTS

11:00

MID-MORNING BREAK



1:00

ONE HOUR LUNCH BREAK

3:15

MID-AFTERNOON BREAK

4:30

WRAP UP

Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !

What you get

With your Oracle Developer Skills training course from Activia, you get a free workbook, so you can review and revise afterwards to reinforce your knowledge.

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

ORACLE® DISCOVERER DESKTOP FOR END USERS

We can enhance your skills with Developers Oracle® training at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our oracle developer courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering oracle discoverer desktop for end users all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of training courses in Oracle Developer to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in certification course for Oracle Developer.

Why not contact us today to see how we can help with providing your certification course for Oracle Developer ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:    0333 6000 777



Back to top
Quick Links
More on This Page
We do not have classes for Oracle Discoverer Desktop for End Users scheduled at present but contact us to see how you can schedule your own

OK