Phone Seer Computing on +44-800-157-7519

Home > Oracle Discoverer 9i Desktop Training course

Oracle
training

SQL
training

PHP/MySQL
MariaDB training

JavaScript/CSS3/
Python 3 training

Java
training

Public or
on-site

Consultancy

Apps

Contact
Us

Opening up the world of Oracle

Seer Computing offers specialist Oracle training for diverse clients across the UK, Ireland and Europe.

Browse our list of popular Oracle training courses below, including SQL, PLSQL and SQL Developer

* Available as a Public course, these and all others available on-site throughout the UK, Ireland and the rest of the EU.

Sitemap of SeerComputing.com

Details of all Oracle training courses

About SQL ...

SQL, Structured Query Language, the building block to many relational Databases, each is slightly different from the other

MySQL / MariaDB Courses

Its a powerful, free to download Database, MySQL is now owned by Oracle it will undoubtedly become a
major player in the Database software market.

MariaDB is the new version produced by the originators of MySQL (they are almost identical,
use MySQL if you are interested in a public course)

Essential MySQL 8 *
Essential MySQL 5.7

Essential MariaDB 10

SQLite Course

The defacto Database for Android and IOS systems, SQLite is small on size but big on functionality.

Essential SQLite 3 *

Oracle / MySQL / MariaDB with PHP Courses

A series of Oracle / MySQL / MariaDB courses using PHP which helps Developers to see how the product can be used commercially on the Internet
as well as offer MySQL, MariaDB or Oracle with PHP as separate courses.

PHP 7.4 and MySQL 8 *

Other PHP Courses

PHP 7.4 and Oracle 19c

Oracle SQL

Essential SQL for Oracle 23ai *

Essential SQL for Oracle 21c

Essential SQL for Oracle 19c

Other Oracle SQL Courses

Using SQL with SQL Developer 23.1 *

Using SQL with SQL Developer 23.1 Part I

Using SQL with SQL Developer 23.1 Part II

Other SQL Developer courses.

* Available as a Public course, these and all others available on-site throughout the UK, Ireland and the rest of the EU.

PHP / Oracle / MySQL / MariaDB

PHP is one of the best programming languages for creating high quality websites, whether its just making decisions which HTML
to echo or reading the data for the site from XML files or Oracle / MySQL / MariaDB Databases.

PHP 8 is the latest manifestation, we have combined PHP with three SQL Databases both of which are used commercially on the Internet.

Other PHP and MySQL courses

About MySQL and MariaDB ...

What a product MySQL is, take it from Oracle Developers, we are still amazed that its free to download and use, but being a Database
its not an easy product to use unless you have the right training, that's where we come in,
using the techniques we used for nearly two decades teaching Oracle SQL and its relative products, our MySQL courses are designed
to give Delegates practical exercises and real insight into this powerful relational Database. The original creators of MySQL
have produced MariaDB as a rival to their own MySQL product, this is identical to the original but is available from us as a different course.

* Available as a Public course, these and all others available on-site throughout the UK, Ireland and the rest of the EU.

CSS3

CSS is the design behind the HTML and PHP, it dictates simple style like background colour right up to the overlay this menu is sitting in.

Essential CSS3 *

JavaScript

One of the essential languages to have under your belt when developing webpages,
JavaScript allows the creation of interactive User interfaces which make webpages stand out from the rest.

Essential JavaScript *

Python 3

The Essential Python 3 course is five day duration.
Designed for both beginners and seasoned programmers alike.

Essential Python 3 *

* Available as a Public course, these and all others available on-site throughout the UK, Ireland and the rest of the EU.

About Java ...

Java is one of the most popular programming languages in the world and is found in many different applications
from washing machines to smart phones.

Similar to C++, Java is an Object Orientated Language (Oops) and uses program classes to contain the code.

Most Developers and Companies use Eclipse software to create Java programs and it is this course we recommend,
however we can also teach you Java using the DOS command prompt.

Developers wishing to develop Android apps will need Java skills to fully utilise the functionality.

Java Swing is a GUI front end suite of code for Java, allowing the Developer to create intricate input screens and menu systems.

All of our Java courses are 5 days duration.

Java 17

Java 17 Programming with Eclipse 2021-12 *

Java 17 Swing with Eclipse 2021-12 *

See our other Java Courses.

* Available as a Public course, these and all others available on-site throughout the UK, Ireland and the rest of the EU.

Public Courses

Click on the location nearest to you for the list of courses and their dates.

Public training courses are held throughout the UK and Ireland at regular intervals throughout the year.

Delegate numbers are restricted to a minimum of one and a maximum of six people per course.

Each Delegate has their own individual workstation and a set of manuals which are supplied with solutions CDs as part of the course.

Courses are generally held in City centre based conference facilities with ample parking and public transport access,
buffet lunch is provided as well as tea and coffee throughout the day.

Courses start at 9am and finish at 4.30pm with ample comfort breaks during the course.

Each course has a number of exercises built into the course for the Delegate to practice the techniques set out in the presentations.

On-Site Training - Have wheels will travel

If you have two or more delegates or not located near any of our training centres,
ask about on-site training - we come to you ! all we need is a suitable room for our Consultant and delegates to work in.

On-Site training can take place on commencement dates and start times of your choosing.

On-Site training can be held anywhere in the UK, Ireland and the rest of the EU. Read more...

One on One Training

We can offer one on one training when you need urgent training or over weekends. Contact us for details.

Project Management

Our Project Managers can provide independent, full-time or occasional professional assistance for your IT Projects.

Advice from the outset of your Project or help you regain control of the timescales, we can be there to assist.

We can mediate between you and your clients, gather vital progress information or manage your resources.

Oracle Consultancy

If you're looking for expert help in building or maintaining your Oracle database or system, Seer Computing can help.

Seer Computing are specialists in the design, construction and maintenance of Oracle Systems.

Our in-depth knowledge of Oracle means our consultancy service delivers best practice solutions that help you and your company succeed. Whether implementing new Oracle programming projects or improving an existing system.

Data Consultancy

Your Data is our Business. Seer Computing can build, advise and de-construct your Data, read our humorous take on Data Management ... Data is for the life of your business, not just for Christmas !

You spend lots of time, money and resource collecting it. You store it,You use it. It's your company's lifeline, You base projections on it, make business decisions on the basis of it. But, do you know the condition of it and what it could really achieve for you?

Data Coach

We have a team of specialist consultants who help businesses realise the full potential and true value of their business information systems and management information. Drawing together a Company's data-flow, we specify and develop usage and future performance strategies, help to restore confidence in the quality of your data, and tell you how it can make more effective business decisions and increase fiscal success. Whether you're working with a legacy system or need a complete data re-focus read how we can help you.

Discoverer Consultancy

When it comes to tackling the complexities of Oracle Discoverer, Oracle's in-house ad-hoc query software, Seer Computing is here to help. From Administrators to End Users, we provide resources, training and practical guidance to help you get the most out of your product.

Seer Computing App Development

The Papers and Periodicals App

The PAPA project is a template App created on Android and iOS platforms to enable small to medium Enterprises to publish their news on Apps ...

Ana Chidzoy's A-Z of Yoga

Over 150 Yoga poses fully illustrated and explained with a
breakdown of workouts Further details (Android and iPhone) ...

Apps for Productivity

Seer Computing has released a number of Apps to increase Developer productivity.
Available for both iPhone and Android platforms
These Apps are designed to aid Developers when using Oracle, PHP and MySQL languages

Oracle SQL Functions

The complete breakdown of functions available in an Oracle Database
Android version ...
iPhone version ...

PHP Functions

Functions and techniques listed alphabetically with explanations and examples.
Android version ...
iPhone version ...

MySQL Functions

Alphabetical functions, with explanations and working examples.
Android version ...
iPhone version ...

MariaDB Functions

Easy to understand breakdown of MariaDB functions
Android and iPhone versions ...

Bespoke Apps

A guide to having a successful Android and Apple App

Let us build you App for you

About Seer Computing

Seer Computing is a UK-based training and data consultancy that specialises in providing you with independent, leading edge computer consultancy and training courses across the UK and Europe.

About our website

We have to made the pages as accessible as possible, course pages have an 'at a glance' section to give you quick information of duration, knowledge needed and pre-requisite courses, they also include the contents of the course in its entirety.

About our training courses

Each delegate receives a copy of our in-depth course manuals, which becomes a valuable reference guide following the course.

Each training course has a tutor led learning framework with lots of demonstrations and practical exercises.

On-Site training (at your venue)

All that we require is a private room with tables and chairs, that is large enough to comfortably hold your delegates and a tutor, we provide each delegate with an individual laptop and all other equipment that is required.

Public training

If you prefer instead of delivering on site we can deliver the course off site at Seer House, Swansea or we will be happy to arrange a neutral venue that is convenient for you (please be aware this will incur additional costs).

Flexible training

Many of our courses can be delivered on weekends or split in two parts

Customised training

If a particular course is not entirely suitable for your company requirements we offer the service of creating bespoke training packages. We can either customise this training to your exact company requirements or work with you to build a completely new one (please be aware this will incur additional costs).

Consultancy

We specialize in Databases and Project Management, we can help you run your Project and indeed build areas for you including the Database and the front end.

Apps

We are looking for partners who need Android and iPhone Apps for them, we provide the technical expertise, you provide the idea or concept.

Home > Oracle Discoverer 9i Desktop Training course

Discoverer Desktop 9i course at a glance

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

Course PDFs

Course Index

Exercise Example

Example Pages

Content Highlights

Oracle Discoverer 9i Desktop Training course
Contents highlights

Creating Calculated Items in Discoverer
Limiting Records in Discoverer using Conditions
Making Discoverer Worksheets generic using Parameters
Aggregating Data in Discoverer using Drilling and Hierarchies
Creating Graphs in Oracle Discoverer
Sharing worksheets
Exporting data in Discoverer
Discoverer interfacing with Microsoft Excel

Exercise Highlights

Oracle Discoverer 9i Desktop Training course
Exercise highlights

Creating rudimentary Discoverer worksheets
Sorting Discoverer Worksheets
Totals and sub-totalling in Discoverer
Highlighting exceptions in Discoverer
Aggregating and Drilling through data hierachies in Discoverer
Scheduling Workbooks in Discoverer

Course Index

Index of Oracle Discoverer 9i Desktop Training course

Section

Contents

Page

One

Introduction

- What is Discoverer 9i?

- What is Discoverer 9i Desktop?

- Understanding Discoverer 9i Terminology

- How to run Discoverer 9i

Two

Discoverer 9i Desktop Interface

- Connecting to Discoverer 9i

- Anatomy of Discoverer 9i

- Menu Bar

- Shortcut Bars

- Toolbar

- Formatting Bar

- Analysis Bar

Three

Existing Workbooks

- Introduction

- Opening Workbooks in Discoverer 9i

- Write Permissions in Discoverer 9i

- Using Different Accounts

- Missing Items in Discoverer 9i

- Multiple EULs in Discoverer 9i

- Running the Query in Discoverer 9i

- Re- Sizing Items in Discoverer 9i

- Pivoting Items in Discoverer 9i

- Saving Workbooks in Discoverer 9i

- Using Parameters in Discoverer 9i

- Exercise One

Four

Simple Workbooks

- Creating Workbooks in Discoverer 9i

- Modifying Workbooks in Discoverer 9i

- Duplicating Worksheets in Discoverer 9i

- Counting Records in Discoverer 9i

- Exercise Two

Five

Formatting

- Introduction to Formatting in Discoverer 9i

- Formatting Data in Discoverer 9i

- Formatting Numbers in Discoverer 9i

- Formatting Dates in Discoverer 9i

- Formatting Text in Discoverer 9i

- Setting Column Headings in Discoverer 9i

- Specifying Backgrounds in Discoverer 9i

- Creating Titles in Discoverer 9i

100

- Sorting Records in Discoverer 9i

105

- Using Exceptions in Discoverer 9i

111

- Creating Exceptions in Discoverer 9i

117

- Managing Exceptions in Discoverer 9i

118

- Page Setup in Discoverer 9i

119

- Exercise Three

123

Six

Advanced Worksheets

135

- Introduction

136

- Page Items in Discoverer 9i

137

- Cross- Tabs in Discoverer 9i

139

- Exercise Four

144

Seven

Totals

149

- Using Totals in Discoverer 9i

150

- Creating Totals in Discoverer 9i

153

Eight

Percentages

158

- Introduction to Percentages in Discoverer 9i

159

- Creating Percentages in Discoverer 9i

161

- Exercise Five

164

Nine

Conditions

171

- Limiting Data in Discoverer 9i

172

- Administrator Conditions

174

- Creating Conditions in Discoverer 9i

178

- Advanced Conditions in Discoverer 9i

188

- Exercise Six

193

Ten

Calculations

198

- Creating Additional Items in Discoverer 9i

199

- Oracle Functions in Discoverer 9i

205

- Exercise Seven

150

Eleven

Parameters

215

- Creating Parameters in Discoverer 9i

216

- Disabling Parameters in Discoverer 9i

225

- Advanced Parameters in Discoverer 9i

226

- Exercise Eight

230

Twelve

Aggregation

234

- Totalling Values in Discoverer 9i

235

- Example of Aggregation in Discoverer 9i

236

- Data Points in Discoverer 9i

240

- Date Hierarchies in Discoverer 9i

243

- Exercise Nine

246

Thirteen

Drilling

251

- Drilling Through Data in Discoverer 9i

252

- Using Hierarchies in Discoverer 9i

253

- Types of Drilling in Discoverer 9i

254

- Using Drilling in Discoverer 9i

257

- Drill Dialog in Discoverer 9i

259

- Drilling Up and Down in Discoverer 9i

262

- Drilling to a Related Item in Discoverer 9i

263

- Drill to Detail in Another Sheet in Discoverer 9i

264

- Drill to an External Application (Hyper Drill)

265

- Exercise Ten

266

Fourteen

Graphs

271

- Graphically Representing Data in Discoverer 9i

272

- Incorporating Graphs in Discoverer 9i

273

- Graphs Wizard in Discoverer 9i

274

- Graph Window in Discoverer 9i

279

- Modifying Graphs in Discoverer 9i

259

Fifteen

Summaries

289

- Purpose of Summaries in Discoverer 9i

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 9i

308

- Copy and Paste

310

- Excel Direct

311

- Sharing Workbooks in Discoverer 9i

312

- Deleting a Workbook in Discoverer 9i

314

- Scheduling a Workbook in Discoverer 9i

315

- Managing a Workbook in Discoverer 9i

321

Eighteen

Line Commands

327

- Using Line Commands Discoverer 9i

328

- DOS

329

- Options

337

- Exercise Eleven

342

Nineteen

Complex Queries

343

- Creating a Worksheet Using SQL

344

- Subqueries in Discoverer 9i

347

- Creating a Subquery in Discoverer 9i

348

- Alternative Subquery Creation

349

Twenty

Help

350

- Introduction

351

- Help Topics

352

- Using Help

353

- About Discoverer 9i

354

- Exercise Twelve

355

Sections of Oracle Discoverer User 9i Desktop

One

Introduction

Two

Discoverer 9i 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

Course Synopsis

Synopsis for Oracle Discoverer 9i Desktop Training course

Oracle Discoverer 9i Desktop 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.

Opening up the world of Oracle

SQL

PLSQL

Discoverer Administration

SQL Developer

Discoverer Desktop / Plus

Application Express 20

Forms

Reports

About SQL ...

MySQL / MariaDB Courses

SQLite Course

Oracle / MySQL / MariaDB with PHP Courses

Oracle SQL

PHP / Oracle / MySQL / MariaDB

About MySQL and MariaDB ...

CSS3

JavaScript

Python 3

About Java ...

Java 17

Public Courses

On-Site Training - Have wheels will travel

One on One Training

Project Management

Oracle Consultancy

Data Consultancy

Data Coach

Discoverer Consultancy

Seer Computing App Development

The Papers and Periodicals App

Ana Chidzoy's A-Z of Yoga

Apps for Productivity

Oracle SQL Functions

PHP Functions

MySQL Functions

MariaDB Functions

Bespoke Apps

About Seer Computing

About our website

About our training courses

On-Site training (at your venue)

Public training

Flexible training

Customised training

Consultancy

Apps

Discoverer Desktop 9i course at a glance

Oracle Discoverer 9i Desktop Training courseContents highlights

Oracle Discoverer 9i Desktop Training courseExercise highlights

Index of Oracle Discoverer 9i Desktop Training course

Sections of Oracle Discoverer User 9i Desktop

Synopsis for Oracle Discoverer 9i Desktop Training course

Oracle Discoverer 9i Desktop Training course
Contents highlights

Oracle Discoverer 9i Desktop Training course
Exercise highlights