Top
Email
Bottom
Discoverer Desktop 10g
 
Name:
Company:
Email:
Telephone:
Training type:
Delegates:


Additional Information
 

Download our latest
Android and iPhone apps ...
Click on whichever one of our Apps you are interested in

Discoverer Desktop 10g course at a glance

Pages
365No of slides in the Manual
Exercises
12Total No of Exercises
Sections
20No of main topics, see index below
Public
NoPublic course in the UK and Ireland
On-Site
YesWe can come to your venue
Level
11 - Beginners
2 - Intermediate
3 - Advanced
Days
2Week days but we can put on weekend courses
Duration:
Minimum skill level required:
On-Site course:
Public course:
Sections:
No of exercises:
No of pages in the manual:
Pre-Requisite course(s):
Suggested further course(s):
Price guide:
2 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
20
12
365
None
Discoverer Administrator 10g Oracle Essential SQL 10g
Contact us for the latest pricing

Index of Oracle Discoverer 10g Desktop Training Course

Section
Contents
Page

One
Introduction
2

 
- What is Discoverer 10g?
3

 
- What is Discoverer 10g Desktop?
4

 
- Understanding Discoverer 10g Terminology
5

 
- How to run Discoverer 10g
15

Two
Discoverer 10g Desktop Interface
17

 
- Connecting to Discoverer 10g
18

 
- Anatomy of Discoverer 10g
19

 
- Menu Bar
20

 
- Shortcut Bars
21

 
- Toolbar
22

 
- Formatting Bar
24

 
- Analysis Bar
26

Three
Existing Workbooks
28

 
- Introduction
29

 
- Opening Workbooks in Discoverer 10g
31

 
- Write Permissions in Discoverer 10g
33

 
- Using Different Accounts
34

 
- Missing Items in Discoverer 10g
37

 
- Multiple EULs in Discoverer 10g
39

 
- Running the Query in Discoverer 10g
42

 
- Re- Sizing Items in Discoverer 10g
43

 
- Pivoting Items in Discoverer 10g
45

 
- Saving Workbooks in Discoverer 10g
51

 
- Using Parameters in Discoverer 10g
52

 
- Exercise One
55

Four
Simple Workbooks
62

 
- Creating Workbooks in Discoverer 10g
63

 
- Modifying Workbooks in Discoverer 10g
78

 
- Duplicating Worksheets in Discoverer 10g
79

 
- Counting Records in Discoverer 10g
80

 
- Exercise Two
81

Five
Formatting
87

 
- Introduction to Formatting in Discoverer 10g
88

 
- Formatting Data in Discoverer 10g
89

 
- Formatting Numbers in Discoverer 10g
94

 
- Formatting Dates in Discoverer 10g
95

 
- Formatting Text in Discoverer 10g
96

 
- Setting Column Headings in Discoverer 10g
97

 
- Specifying Backgrounds in Discoverer 10g
98

 
- Creating Titles in Discoverer 10g
100

 
- Sorting Records in Discoverer 10g
105

 
- Using Exceptions in Discoverer 10g
111

 
- Creating Exceptions in Discoverer 10g
117

 
- Managing Exceptions in Discoverer 10g
118

 
- Page Setup in Discoverer 10g
119

 
- Exercise Three
123

Six
Advanced Worksheets
135

 
- Introduction
136

 
- Page Items in Discoverer 10g
137

 
- Cross- Tabs in Discoverer 10g
139

 
- Exercise Four
144

Seven
Totals
149

 
- Using Totals in Discoverer 10g
150

 
- Creating Totals in Discoverer 10g
153

Eight
Percentages
158

 
- Introduction to Percentages in Discoverer 10g
159

 
- Creating Percentages in Discoverer 10g
161

 
- Exercise Five
164

Nine
Conditions
171

 
- Limiting Data in Discoverer 10g
172

 
- Administrator Conditions
174

 
- Creating Conditions in Discoverer 10g
178

 
- Advanced Conditions in Discoverer 10g
188

 
- Exercise Six
193

Ten
Calculations
198

 
- Creating Additional Items in Discoverer 10g
199

 
- Oracle Functions in Discoverer 10g
205

 
- Exercise Seven
150

Eleven
Parameters
215

 
- Creating Parameters in Discoverer 10g
216

 
- Disabling Parameters in Discoverer 10g
225

 
- Advanced Parameters in Discoverer 10g
226

 
- Exercise Eight
230

Twelve
Aggregation
234

 
- Totalling Values in Discoverer 10g
235

 
- Example of Aggregation in Discoverer 10g
236

 
- Data Points in Discoverer 10g
240

 
- Date Hierarchies in Discoverer 10g
243

 
- Exercise Nine
246

Thirteen
Drilling
251

 
- Drilling Through Data in Discoverer 10g
252

 
- Using Hierarchies in Discoverer 10g
253

 
- Types of Drilling in Discoverer 10g
254

 
- Using Drilling in Discoverer 10g
257

 
- Drill Dialog in Discoverer 10g
259

 
- Drilling Up and Down in Discoverer 10g
262

 
- Drilling to a Related Item in Discoverer 10g
263

 
- Drill to Detail in Another Sheet in Discoverer 10g
264

 
- Drill to an External Application (Hyper Drill)
265

 
- Exercise Ten
266

Fourteen
Graphs
271

 
- Graphically Representing Data in Discoverer 10g
272

 
- Incorporating Graphs in Discoverer 10g
273

 
- Graphs Wizard in Discoverer 10g
274

 
- Graph Window in Discoverer 10g
279

 
- Modifying Graphs in Discoverer 10g
259

Fifteen
Summaries
289

 
- Purpose of Summaries in Discoverer 10g
290

Sixteen
Worksheet Options
292

 
- Introduction
293

 
- General
294

 
- Query Governor
295

 
- Table
297

 
- Crosstab
299

 
- Aggregation
300

 
- Formats
301

 
- Cache
302

 
- Connection
303

 
- Advanced
304

 
- EUL
305

 
- Additional
306

Seventeen
Additional Features
307

 
- Exporting Data from Discoverer 10g
308

 
- Copy and Paste
310

 
- Excel Direct
311

 
- Sharing Workbooks in Discoverer 10g
312

 
- Deleting a Workbook in Discoverer 10g
314

 
- Scheduling a Workbook in Discoverer 10g
315

 
- Managing a Workbook in Discoverer 10g
321

Eighteen
Line Commands
327

 
- Using Line Commands Discoverer 10g
328

 
- DOS
329

 
- Options
337

 
- Exercise Eleven
342

Nineteen
Complex Queries
343

 
- Creating a Worksheet Using SQL
344

 
- Subqueries in Discoverer 10g
347

 
- Creating a Subquery in Discoverer 10g
348

 
- Alternative Subquery Creation
349

Twenty
Help
350

 
- Introduction
351

 
- Help Topics
352

 
- Using Help
353

 
- About Discoverer 10g
354

 
- Exercise Twelve
355

 
 
 

Sections of Oracle Discoverer 10g Desktop course

One
Introduction

Two
Discoverer 10g Desktop Interface

Three
Existing Workbooks

Four
Simple Workbooks

Five
Formatting

Six
Advanced Worksheets

Seven
Totals

Eight
Percentages

Nine
Conditions

Ten
Calculations

Eleven
Parameters

Twelve
Aggregation

Thirteen
Drilling

Fourteen
Graphs

Fifteen
Summaries

Sixteen
Worksheet Options

Seventeen
Additional Features

Eighteen
Line Commands

Nineteen
Complex Queries

Twenty
Help

Synopsis for Oracle Discoverer 10g Desktop Training Course

One of the modern day problems with having a database is not populating it, feeds can be taken from a variety of different sources; online input, importing from other Databases, legacy conversions etc. The major headache is giving enough people access to the system, without compromising the data or risking SQL injection, access to the Database isn’t as simple as just providing privileges it's about controlling how that access is used, step up Discoverer, this tool was designed to give access to an Oracle database without the User needing a degree in Computer Science, it also means that following initial setup the Discoverer End User Layer can be rolled out to as many Users as necessary without the usual security concerns.

The Discoverer front end has been styled to have the look and feel of a Microsoft Excel spreadsheet with the added advantage that the data is live, central for everyone and above all incorruptible, oh and it's easy to use … once you've had training from Seer Computing of course !! We mentioned an End User Layer earlier, this is where someone with a knowledge of your business Database will need to get involved, the Discoverer Administrator will need to create this EUL for others to get access and guess what, we do a course in that too !!! In fact we are so good we offer consultancy in Discoverer at very reasonable rates, ask our training support for further details.

This particular course is the Discoverer Desktop version 10, it's called Desktop as it needs to be installed on a User's personal machine, there is a sister interface called Plus, this is accessed via a browser and is also available as a training course from Seer Computing.

This Discoverer Desktop 10 course is one of over 150 courses we can perform onsite at your premises, at our premises or at a location convenient to your offices or for your delegates to find it easy to attend.

When we perform onsite training all we need is a room with enough 'room' for all of the Delegates to be comfortable in, that means good air conditioning or windows that open, blinds that shade from the sun, lots of elbow room, padded seats and a large bowl of jelly beans in assorted flavours … oh we can but hope for the jelly beans but the rest is a good idea for your delegates to work and enjoy the course. We provide the machines, comprehensive manuals and a very experienced Consultant, your Delegates will learn and enjoy.

The Desktop 10 course is not the latest Discoverer course, if you need the latest (Discoverer 11c) we do this too, have a look at our menu system and find the latest there, there's even a splash image for you to click on to take you right there.

Getting in touch with us couldn’t be easier, we have a Freephone number which you can see at the top and bottom of this page as well as an enquiry form within the page, we also provide a PDF quotation for any training you require, you then have 182 days to decide, get a Purchase Order organised, round up your Delegates and agree a start date with us

Nothing could be simpler

Request for detailsClick for the contact form for the Discoverer Desktop 10g training course
Public Courses
Oracle Essential SQL 21c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 21c
Days
3
Pages
384
Exercises
13
Sections
25
Public
Yes
On-Site
Yes
Public Courses
Using SQL with Oracle SQL Developer 19.2
Days
4
Pages
884
Exercises
18
Sections
37
Public
Yes
On-Site
Yes
Public Courses
Essential JavaScript
Days
4
Pages
660
Exercises
16
Sections
31
Public
Yes
On-Site
Yes
Public Courses
Essential CSS 3
Days
4
Pages
800
Exercises
15
Sections
30
Public
Yes
On-Site
Yes
Public Courses
Essential SQLite 3
Days
3
Pages
550
Exercises
12
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential MySQL 8
Days
4
Pages
533
Exercises
16
Sections
24
Public
Yes
On-Site
Yes
Public Courses
Essential Python 3
Days
5
Pages
955
Exercises
17
Sections
41
Public
Yes
On-Site
Yes
Public Courses
Oracle Application Express 20
Days
0
Pages
0
Exercises
0
Sections
0
Public
Yes
On-Site
Yes
Public Courses
PHP 8 and MySQL 8
Days
5
Pages
870
Exercises
23
Sections
38
Public
Yes
On-Site
Yes
Public Courses
Java 17 Programming with Eclipse 2021-12
Days
5
Pages
788
Exercises
23
Sections
44
Public
Yes
On-Site
Yes
Public Courses
Java 17 Swing with Eclipse 2021-12
Days
5
Pages
756
Exercises
19
Sections
35
Public
Yes
On-Site
Yes
Click on the course name to see full details, left and right to view other courses