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

Pages
378No of slides in the Manual
Exercises
16Total No of Exercises
Sections
18No 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
3Week 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:
3 days
1 (1 - Beginner, 2 - Experienced 3 - Advanced)
Yes
No
18
16
378
Oracle Essential SQL 9i Discoverer Desktop 9i
None
Contact us for the latest pricing

Index of Oracle Discoverer 9i Administrator Training Course

Section
Contents
Page


One
Introduction to Discoverer Administration
2

 
- What is Oracle Discoverer?
3

 
- What is Discoverer Administration ?
4

 
- How to run Discoverer Administration
6

 
- Who can perform the Administrator role?
8

 
- Understanding Discoverer Terminology
9

 
- Exercise One
18

Two
Discoverer Administrator Interface
30

 
- Connecting to Discoverer Administrator
31

 
- Discoverer Administrator Topography
34

 
- Discoverer Work Area
35

 
- Work Area Tabs
36

 
- Menu Bar
37

 
- Shortcut Bar
38

 
- Administration Task list
39

Three
The Discoverer End User Layer
40

 
- Introduction
41

 
- Privileges needed by the Discoverer Administrator
43

 
- Maintaining a Discoverer End User Layer
44

 
- Types of Discoverer End User Layers
45

 
- Discoverer End User Layer Gateway
47

 
- Creating Discoverer End User Layers
48

 
- Creating Discoverer Additional End User Layers
53

 
- Exercise Two
54

Four
Discoverer Business Areas
57

 
- Introduction to Discoverer Business Areas
58

 
- Creating Business Areas in Discoverer
60

 
- Attributes of Business Areas in Discoverer
69

 
- Description Attributes in Discoverer
70

 
- Viewing Business Areas in Discoverer
72

 
- Opening Business Areas in Administrator
73

 
- Business Area Properties
75

Five
Exporting and Importing
76

 
- Exporting in Discoverer Administrator
77

 
- Exporting the EUL
76

 
- Exporting Selected Business Areas
81

 
- Exporting Selected Objects
84

 
- Importing Export Files into Administrator
86

 
- Exercise Three
91

Six
Simple Folders
93

 
- Introduction
94

 
- Creating Additional Folders in Discoverer
95

 
- Simple Folder Properties
96

 
- Exercise Four
100

Seven
Security and Privileges
101

 
- Introduction
102

 
- Discoverer Security
103

 
- Using Roles in Discoverer Administrator
104

 
- Granting Access to Desktop Users
105

 
- Discoverer Administrator Privileges
108

 
- Granting Privileges to Desktop Users
109

 
- Types of Privileges in Discoverer Administrator
110

 
- Administration Privileges
111

 
- User Edition Privileges
112

 
- Query Governor in Discoverer
114

 
- Scheduled Workbooks in Discoverer
117

 
- Exercise Five
118

Eight
Item Properties
120

 
- Items in Discoverer Administrator
121

 
- Data Types in Discoverer Administrator
122

 
- Varchar2
123

 
- Number
125

 
- Date
126

 
- Float
127

 
- Long
128

 
- Large Objects
129

 
- Attributes
131

 
- Exercise Six
138

Nine
Developing Folders
142

 
- Adding Value to Discoverer Folders
143

 
- Creating Conditions in Discoverer
144

 
- Optional and Mandatory Conditions
146

 
- Creating Conditions in Administrator
147

 
- Viewing Conditions in Administrator
154

 
- Viewing Conditions in Desktop
155

 
- Properties of Conditions
157

 
- Calculations in Discoverer
160

 
- Derived Items in Discoverer
162

 
- Aggregate Calculations in Discoverer
163

 
- Derived Aggregates in Discoverer
164

 
- Creating Calculations in Discoverer
165

 
- Viewing Calculations in Discoverer
169

 
- Properties in Discoverer
170

 
- Exercise Seven
171

 
- Item Classes in Discoverer Administrator
176

 
- Creating LOVs in Discoverer Administrator
180

 
- Viewing LOVs in Discoverer Administrator
183

 
- Exercise Eight
185

Ten
Joins
186

 
- Joining Folders in Discoverer Administrator
187

 
- Types of Joins
189

 
- Creating Joins in Discoverer Administrator
191

 
- Join Options in Discoverer Administrator
193

 
- Viewing Joins in Discoverer Administrator
197

 
- Join Properties in Discoverer Administrator
198

 
- Fan Traps in Discoverer Administrator
199

 
- Multiple Join Path Detection in Discoverer Desktop
203

 
- Exercise Nine
204

Eleven
Complex Folders
208

 
- Creating Complex Folders in Discoverer
209

 
- Properties of Complex Folders
212

 
- Viewing Complex Folders in Discoverer
213

 
- Exercise Ten
214

Twelve
Custom Folders
219

 
- Custom Folders in Discoverer
220

 
- Creating Custom Folders in Discoverer
221

 
- Viewing Custom Folders
223

 
- Properties of Custom Folders
224

 
- Developing Custom Folders
225

 
- Labelling Selected Folders
226

 
- Joining Tables in an SQL Statement
229

 
- Problems with Joining Tables in SQL
234

 
- Methods of Joining Tables in SQL
236

 
- Using Ansi SQL/86 to Join Tables
237

 
- Ansi SQL/86 and Outer Joins
238

 
- Ansi SQL/92 Standards (Natural Joins)
241

 
- Ansi SQL/92 Standards (Cross Joins)
242

 
- Ansi SQL/92 Standards (Joins/Using)
243

 
- Ansi SQL/92 Standards (On)
244

 
- Ansi SQL/92 Standards (Multiple On)
245

 
- Ansi SQL/92 Standards (Left Outer Joins)
246

 
- Ansi SQL/92 Standards (Right Outer Joins)
247

 
- Ansi SQL/92 Standards (Full Outer Joins)
248

 
- Merging Tables in SQL
249

 
- Using Union to Merge Tables in SQL
250

 
- Using Union all to Merge Tables in SQL
251

 
- Using Intersect to Merge Tables in SQL
252

 
- Using Minus to Merge Tables in SQL
253

 
- Knowledge Check
254

 
- Using the Merge Syntax in SQL
259

 
- Using Metadata in the End User Layer
260

 
- Using the Merge Syntax in SQL
259

 
- Tree Walking in Discoverer
262

 
- Syntax for Tree Walking in Discoverer
264

 
- Example of Tree Walking in Discoverer
265

 
- Ordering Siblings in Tree Walks
266

 
- Using Sys_Connect_By_Path
268

 
- Exercise Eleven
270

Thirteen
Alternative Sorts
278

 
- Alternative Sorting in Discoverer
279

 
- Creating Alternative Sorts
282

 
- Using Alternative Sorts
291

 
- Sorting on the Same Table
292

 
- Exercise Twelve
293

Fourteen
Aggregation
296

 
- Aggregating Data in Discoverer
297

 
- Data Points in Discoverer
302

 
- Aggregating Dates in Discoverer
305

Fifteen
Drilling and Hierarchies
308

 
- Drilling Data in Discoverer
309

 
- Creating Hierarchies in Discoverer
313

 
- Date Hierarchies in Discoverer
314

 
- Creating Date Hierarchies in Discoverer
316

 
- Viewing Date Hierarchies in Discoverer
320

 
- Creating Item Hierarchies in Discoverer
321

 
- Viewing Item Hierarchies in Discoverer
325

 
- Editing Item Hierarchies in Discoverer
326

 
- Using Item Hierarchies in Discoverer
327

 
- Creating Hyperdrills in Discoverer
328

 
- Editing Hyperdrills in Discoverer
333

 
- Using Hyperdrills in Discoverer Desktop
334

 
- Setting Hyperdrills in Discoverer
335

 
- Exercise Thirteen
336

Sixteen
Scheduling
340

 
- Administrating Scheduling in Discoverer
341

 
- Specifying Scheduled Workbook Limits
345

 
- Processing
347

 
- Scheduling a Workbook
349

 
- Scheduling Manager
350

 
- Exercise Fourteen
352

Seventeen
Summaries
353

 
- Summary Creation in Discoverer
354

 
- ASM Creating in Discoverer
358

 
- Creating Manual Summaries in Discoverer
361

 
- Creating Summaries based on EUL Items
362

 
- Creating Summaries based on Query Statistics
369

 
- Using External Summary Tables in Discoverer
371

 
- Viewing Summary Folders in Discoverer
375

 
- Refreshing Summary Folders in Discoverer
376

 
- Editing Summary Folders in Discoverer
377

 
- Viewing Redirection in Discoverer Desktop
378

 
- Summary Redirection in Discoverer
379

 
- Potential Error
381

Eighteen
Materialized Views
382

 
- An Alternative to Summaries
383

 
- Syntax for Creating Materialized Views
384

 
- Refreshing Materialized Views
386

 
- Building Materialized Views
392

 
- Removing Materialized Views
394

 
- Miscellaneous
395

 
- Exercise Fifteen
396

Nineteen
Maintaining the EUL
399

 
- Refreshing the End User Layer
400

 
- Folder Maintenance in Discoverer
407

 
- Deleting Folders in Discoverer
409

 
- Deleting Business Areas in Discoverer
410

 
- Using the Command Line
411

 
- Using a Shortcut to Run Discoverer
432

 
- Exercise Sixteen
434

Twenty
Miscellaneous Discoverer Usage
435

 
- Registering PL/SQL Functions in Discoverer
436

 
- Importing PL/SQL Functions in Discoverer
438

 
- Registering PL/SQL Functions Manually
442

 
- PL/SQL Functions Rules
444

 
- Registering Packages in Discoverer
445

 
- 8i Objects in Discoverer Administrator
447

Twenty One
Help Facility
448

 
- Exercise Thirteen
455

 
 
 

Sections of Oracle Discoverer 9i Administrator course

One
Introduction to Discoverer Administration

Two
Discoverer Administrator Interface

Three
The Discoverer End User Layer

Four
Discoverer Business Areas

Five
Exporting and Importing

Six
Simple Folders

Seven
Security and Privileges

Eight
Item Properties

Nine
Developing Folders

Ten
Joins

Eleven
Complex Folders

Twelve
Custom Folders

Thirteen
Alternative Sorts

Fourteen
Aggregation

Fifteen
Drilling and Hierarchies

Sixteen
Scheduling

Seventeen
Summaries

Eighteen
Materialized Views

Nineteen
Maintaining the EUL

Twenty
Miscellaneous Discoverer Usage

Twenty One
Help Facility

Synopsis for Oracle Discoverer 9i Administrator Training Course

Oracle Discoverer 9i Administrator governs the environment that Discoverer Users exist and operate in.

It is used to perform mandatory tasks such as creating and granting access to Business Areas.

It is also used to perform tasks such as maintaining the End User Layer and setting default item names and table characteristics.
Request for detailsClick for the contact form for the Discoverer Administrator 9i 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