Oracle 10g Discoverer for Administrators

Global Knowledge Canada
Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course provides hands-on experience with administration tasks for Oracle’s Graphical User Interface (GUI) based ad hoc query and data access tool: Discoverer.

What You’ll Learn


Define the Administrator’s Responsibilities
Create a Desktop layer
Grant Access Privileges
Create Folders
Create Items
Create Hierarchies
Create a Business Area
Synchronize a Business Area
Delete Objects
Create Calculations
Create Conditions
Create Joins
Course Outline


1. Introduction
Benefits of Discoverer
Components of Oracle Discoverer
Business Areas
The Role of the Discoverer Manager
2. Setting Up The Tutorial
Starting Oracle Discoverer Administrator
Grant access privileges to users
Granting business area access
3. Customizing the Tutorial
Customizing items
Lists of values (LOV)
Alternative sorts
Calculated items
Modifying content type
Designing complex folders
Creating and working with hierarchies
Create summary folders
4. Managing the End-User Layer (EUL)
Creating an EUL
Multiple EULs
Migrating between EUL releases
Setting the default EUL
EUL status workbooks
5. Building a New Business Area
Building the business area
Managing a business area
6. Access Privileges and Security
Using the privileges window
Using the security window
7. Item Classes and List of Values
Item classes
Lists of values
The Item Class Wizard
Creating an alternative sort class
Linking folders for drill-to-detail
8. Joins
Joins
Outer joins
Multi-item joins
Join properties
Fan traps
9. Calculations
Choosing items
Choosing SQL functions
10. Conditions
Mandatory conditions
Optional conditions
Choosing items for conditions
Compound/complex conditions
11. Hierarchies
Item hierarchies
Date hierarchies
Relating items and hierarchies
12. Folders
Creating a custom folder
Creating a complex folder
13. Summaries
Summary folders
Summary redirection
14. Advanced Options
Creating custom PL/SQL functions
Registering PL/SQL functions
The Command line interface
10gAS Discoverer Plus and Viewer
Registry settings
Labs


Administrator Components
Lab 1: Tutorial Setup
Lab 2: Tutorial Customization
Lab 3: Building an End User Layer
Lab 4: Building a New Business Area
Lab 5: Access Privileges and Security
Lab 6: Creating Item classes
Lab 7: Defining Joins
Lab 8: Creating Complex Calculations
Lab 9: Creating Optional and Mandatory Conditions
Lab 10: Creating Item and Date Hierarchies
Lab 11: Creating Custom and Complex Folders
Lab 12: Creating Summary Folders
Lab 13: Creating Custom Functions / Advanced Options ...''

Elements of this syllabus are subject to change.

Phone:1-800-COURSES

School Address:

Global Knowledge - Canada
535 Legget Drive
Suite 200
Kanata, ON K2K 3B8 Canada



Jobs & Resumes: Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg
Houses & Roommates: Calgary, Edmonton, Halifax, Montreal, Ottawa, Quebec City, Toronto, Vancouver, Winnipeg
Travel Agencies: Calgary, Montreal, Ottawa, Toronto, Vancouver, Winnipeg

Search other schools for Oracle 10g Discoverer for Administrators training resources.

BCM Boot Camp
BCM Configuration and Maintenance
Business Communications Manager 50 Rls. 3.0 Sales Engineering
Intelligent Contact Center for BCM
Nortel Converged Campus: ERS Solution
Nortel ERS 5000 & 4500 Advanced Configuration & Maintenance with Hands-in Labs
Nortel ERS 8600/8300/1600 Advanced Configuration and Maintenance
oracle 10g database administration
oracle 10g discoverer desktop
oracle 10g forms builder
oracle 10g pl/sql intermediate
oracle 10g release 2 business intelligence discoverer plus
oracle 10g reports builder
Oracle Application Server 10g
.net web developer
Advanced .NET Programming
Visual Studio.NET
Intermediate and Advanced .NET Programming

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.