Top
Email
Bottom
Discoverer User 3.1
 
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 User 3.1 course at a glance

Pages
362No 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
362
None
Discoverer Administrator 9i Oracle Essential SQL 9i
Contact us for the latest pricing

Index of Oracle Discoverer 3.1 User Training Course

Section
Contents
Page

One
Introduction
2

 
- What is Discoverer 3.1
3

 
- What is Discoverer 3.1 User
4

 
- Understanding Discoverer 3.1 Terminology
5

 
- How to run Discoverer 3.1 User
15

Two
Discoverer 3.1 User Interface
17

 
- Connecting to Discoverer 3.1
18

 
- Anatomy of Discoverer 3.1
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 3.1
31

 
- Write Permissions in Discoverer 3.1
33

 
- Using Different Accounts
34

 
- Missing Items in Discoverer 3.1
37

 
- Multiple EULs in Discoverer 3.1
39

 
- Running the Query in Discoverer 3.1
42

 
- Re-Sizing Items in Discoverer 3.1
43

 
- Pivoting Items in Discoverer 3.1
45

 
- Saving Workbooks in Discoverer 3.1
51

 
- Using Parameters in Discoverer 3.1
52

 
- Exercise One
55

Four
Simple Workbooks
62

 
- Creating Workbooks in Discoverer 3.1
63

 
- Modifying Workbooks in Discoverer 3.1
78

 
- Duplicating Worksheets in Discoverer 3.1
79

 
- Exercise Two
80

Five
Formatting
86

 
- Introduction to Formatting in Discoverer 3.1
87

 
- Formatting Data in Discoverer 3.1
88

 
- Formatting Numbers in Discoverer 3.1
93

 
- Formatting Dates in Discoverer 3.1
94

 
- Formatting Text in Discoverer 3.1
95

 
- Setting Column Headings in Discoverer 3.1
96

 
- Specifying Backgrounds in Discoverer 3.1
97

 
- Creating Titles in Discoverer 3.1
99

 
- Sorting Records in Discoverer 3.1
104

 
- Using Exceptions in Discoverer 3.1
110

 
- Creating Exceptions in Discoverer 3.1
116

 
- Managing Exceptions in Discoverer 3.1
117

 
- Page Setup in Discoverer 3.1
118

 
- Exercise Three
122

Six
Advanced Worksheets
134

 
- Introduction
135

 
- Page Items in Discoverer 3.1
136

 
- Cross-Tabs in Discoverer 3.1
138

 
- Exercise Four
143

Seven
Totals
148

 
- Using Totals in Discoverer 3.1
149

 
- Creating Totals in Discoverer 3.1
152

Eight
Percentages
157

 
- Introduction to Percentages in Discoverer 3.1
158

 
- Creating Percentages in Discoverer 3.1
160

 
- Exercise Five
163

Nine
Conditions
170

 
- Limiting Data in Discoverer 3.1
171

 
- Administrator Conditions
173

 
- Creating Conditions in Discoverer 3.1
177

 
- Advanced Conditions in Discoverer 3.1
187

 
- Exercise Six
192

Ten
Calculations
197

 
- Creating Additional Items in Discoverer 3.1
198

 
- Oracle Functions in Discoverer 3.1
204

 
- Exercise Seven
207

Eleven
Parameters
214

 
- Creating Parameters in Discoverer 3.1
215

 
- Disabling Parameters in Discoverer 3.1
224

 
- Advanced Parameters in Discoverer 3.1
225

 
- Exercise Eight
229

Twelve
Aggregation
233

 
- Totalling Values in Discoverer 3.1
234

 
- Example of Aggregation in Discoverer 3.1
235

 
- Data Points in Discoverer 3.1
239

 
- Date Hierarchies in Discoverer 3.1
242

 
- Exercise Nine
245

Thirteen
Drilling
250

 
- Drilling Through Data in Discoverer 3.1
251

 
- Using Hierarchies in Discoverer 3.1
252

 
- Types of Drilling in Discoverer 3.1
253

 
- Using Drilling in Discoverer 3.1
256

 
- Drill Dialog in Discoverer 3.1
258

 
- Drilling Up and Down in Discoverer 3.1
261

 
- Drilling to a Related Item in Discoverer 3.1
262

 
- Drill to Detail in Another Sheet in Discoverer 3.1
263

 
- Drill to an External Application (Hyper Drill)
264

 
- Exercise Ten
265

Fourteen
Graphs
270

 
- Graphically Representing Data in Discoverer 3.1
271

 
- Incorporating Graphs in Discoverer 3.1
272

 
- Graphs Wizard in Discoverer 3.1
273

 
- Graph Window in Discoverer 3.1
278

 
- Modifying Graphs in Discoverer 3.1
279

Fifteen
Worksheet Options
288

 
- Introduction
289

 
- General
290

 
- Query Governor
291

 
- Table
293

 
- Crosstab
295

 
- Formats
296

 
- Cache
297

 
- Advanced
298

 
- EUL
299

 
- Additional
300

Sixteen
Additional Features
301

 
- Exporting Data from Discoverer 3.1
302

 
- Copy and Paste
304

 
- Excel Direct
305

 
- Sharing Workbooks in Discoverer 3.1
306

 
- Deleting a Workbook in Discoverer 3.1
308

 
- Scheduling a Workbook in Discoverer 3.1
309

 
- Managing Scheduled Workbooks in Discoverer 3.1
315

Seventeen
Line Commands
321

 
- Using Line Commands Discoverer 3.1
322

 
- DOS
323

 
- Options
331

 
- Exercise Eleven
336

Eighteen
Complex Queries
337

 
- Creating a Worksheet Using SQL
338

 
- Subqueries in Discoverer 3.1
341

 
- Creating a Subquery in Discoverer 3.1
342

 
- Alternative Subquery Creation
343

Nineteen
Help
344

 
- Introduction
345

 
- Exercise Twelve
352

 
 
 

Sections of Oracle Discoverer User 3.1

One
Introduction

Two
Discoverer 3.1 User 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
Worksheet Options

Sixteen
Additional Features

Seventeen
Line Commands

Eighteen
Complex Queries

Nineteen
Help

Synopsis for Oracle Discoverer 3.1 User Training Course

Oracle Discoverer 3.1 User is an easy to use business intelligence tool that gives end users with no SQL knowledge the ability to create ad hoc database queries, analyse information, produce reports and publish information on the web.
Request for detailsClick for the contact form for the Discoverer User 3.1 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