Top
Email
Bottom
Discoverer Plus 4i
 
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 Plus 4i course at a glance

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

Index of Oracle Discoverer 4i Desktop Training course

Section
Contents
Page


One
Introduction
2

 
- What is Discoverer 4i
3

 
- What is Discoverer 4i User
4

 
- Understanding Discoverer 4i Terminology
5

 
- How to run Discoverer 4i User
15

Two
Discoverer 4i User Interface
17

 
- Connecting to Discoverer 4i
18

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

 
- Write Permissions in Discoverer 4i
33

 
- Using Different Accounts
34

 
- Missing Items in Discoverer 4i
37

 
- Multiple EULs in Discoverer 4i
39

 
- Running the Query in Discoverer 4i
42

 
- Re-Sizing Items in Discoverer 4i
43

 
- Pivoting Items in Discoverer 4i
45

 
- Saving Workbooks in Discoverer 4i
51

 
- Using Parameters in Discoverer 4i
52

 
- Exercise One
55

Four
Simple Workbooks
62

 
- Creating Workbooks in Discoverer 4i
63

 
- Modifying Workbooks in Discoverer 4i
78

 
- Duplicating Worksheets in Discoverer 4i
79

 
- Exercise Two
80

Five
Formatting
86

 
- Introduction to Formatting in Discoverer 4i
87

 
- Formatting Data in Discoverer 4i
88

 
- Formatting Numbers in Discoverer 4i
93

 
- Formatting Dates in Discoverer 4i
94

 
- Formatting Text in Discoverer 4i
95

 
- Setting Column Headings in Discoverer 4i
96

 
- Specifying Backgrounds in Discoverer 4i
97

 
- Creating Titles in Discoverer 4i
99

 
- Sorting Records in Discoverer 4i
104

 
- Using Exceptions in Discoverer 4i
110

 
- Creating Exceptions in Discoverer 4i
116

 
- Managing Exceptions in Discoverer 4i
117

 
- Page Setup in Discoverer 4i
118

 
- Exercise Three
122

Six
Advanced Worksheets
134

 
- Introduction
135

 
- Page Items in Discoverer 4i
136

 
- Cross-Tabs in Discoverer 4i
138

 
- Exercise Four
143

Seven
Totals
148

 
- Using Totals in Discoverer 4i
149

 
- Creating Totals in Discoverer 4i
152

Eight
Percentages
157

 
- Introduction to Percentages in Discoverer 4i
158

 
- Creating Percentages in Discoverer 4i
160

 
- Exercise Five
163

Nine
Conditions
170

 
- Limiting Data in Discoverer 4i
171

 
- Administrator Conditions
173

 
- Creating Conditions in Discoverer 4i
177

 
- Advanced Conditions in Discoverer 4i
187

 
- Exercise Six
192

Ten
Calculations
197

 
- Creating Additional Items in Discoverer 4i
198

 
- Oracle Functions in Discoverer 4i
204

 
- Exercise Seven
207

Eleven
Parameters
214

 
- Creating Parameters in Discoverer 4i
215

 
- Disabling Parameters in Discoverer 4i
224

 
- Advanced Parameters in Discoverer 4i
225

 
- Exercise Eight
229

Twelve
Aggregation
233

 
- Totalling Values in Discoverer 4i
234

 
- Example of Aggregation in Discoverer 4i
235

 
- Data Points in Discoverer 4i
239

 
- Date Hierarchies in Discoverer 4i
242

 
- Exercise Nine
245

Thirteen
Drilling
250

 
- Drilling Through Data in Discoverer 4i
251

 
- Using Hierarchies in Discoverer 4i
252

 
- Types of Drilling in Discoverer 4i
253

 
- Using Drilling in Discoverer 4i
256

 
- Drill Dialog in Discoverer 4i
258

 
- Drilling Up and Down in Discoverer 4i
261

 
- Drilling to a Related Item in Discoverer 4i
262

 
- Drill to Detail in Another Sheet in Discoverer 4i
263

 
- Drill to an External Application (Hyper Drill)
264

 
- Exercise Ten
265

Fourteen
Graphs
270

 
- Graphically Representing Data in Discoverer 4i
271

 
- Incorporating Graphs in Discoverer 4i
272

 
- Graphs Wizard in Discoverer 4i
273

 
- Graph Window in Discoverer 4i
278

 
- Modifying Graphs in Discoverer 4i
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 4i
302

 
- Copy and Paste
304

 
- Excel Direct
305

 
- Sharing Workbooks in Discoverer 4i
306

 
- Deleting a Workbook in Discoverer 4i
308

 
- Scheduling a Workbook in Discoverer 4i
309

 
- Managing Scheduled Workbooks in Discoverer 4i
315

Seventeen
Line Commands
321

 
- Using Line Commands Discoverer 4i
322

 
- DOS
323

 
- Options
331

 
- Exercise Eleven
336

Eighteen
Complex Queries
337

 
- Creating a Worksheet Using SQL
338

 
- Subqueries in Discoverer 4i
341

 
- Creating a Subquery in Discoverer 4i
342

 
- Alternative Subquery Creation
343

Nineteen
Help
344

 
- Introduction
345

 
- Exercise Twelve
352

 
 
 

Sections of Oracle Discoverer User 4i Desktop

One
Introduction

Two
Discoverer 4i 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 4i Desktop Training course

Oracle Discoverer 4i Plus 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 Plus 4i training course
Public Courses
Oracle Essential SQL 19c
Days
2
Pages
340
Exercises
8
Sections
15
Public
Yes
On-Site
Yes
Public Courses
Oracle Essential PLSQL 19c
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 7.4 and Oracle 19c
Days
5
Pages
917
Exercises
21
Sections
38
Public
Yes
On-Site
Yes
Public Courses
Java 14 Programming with Eclipse 2020-03
Days
5
Pages
788
Exercises
23
Sections
44
Public
Yes
On-Site
Yes
Public Courses
Java 14 Swing with Eclipse 2020-03
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