ORACLE 10g / 11g DISCOVERER Administrator
Course: ORDSCA
Duration: 2 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/ORDSCA.html
Course Summary
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.
Topics Covered In This Course
INTRODUCTION
- Benefits of Discoverer
- Components of Oracle Discoverer
- Business Areas
- The Role of the Discoverer Manager
SETTING UP THE TUTORIAL
- Starting Oracle Discoverer Administrator
- Grant Access Privileges to Users
- Granting Business Area Access
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
MANAGING THE END USER LAYER
- Creating an EUL
- Multiple EULs
- Migrating Between EUL Releases
- Setting The Default EUL
- EUL Status Workbooks
BUILDING A NEW BUSINESS AREA
- Building the Business Area
- Managing a Business Area
ACCESS PRIVILEGES AND SECRITY
- Using the Privileges Window
- Using the Security Window
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
JOINS
- Joins
- Outer Joins
- Multi-Item Joins
- Join Properties
- Fan Traps
CALCULATIONS
- Choosing Items
- Choosing SQL Functions
CONDITIONS
- Mandatory Conditions
- Optional Conditions
- Choosing Items For Conditions
- Compound/Complex Conditions
HIERARCHIES
- Item Hierarchies
- Date Hierarchies
- Relating Items and Hierarchies
FOLDERS
- Creating a Custom Folder
- Creating a Complex Folder
SUMMARIES
- Summary Folders
- Summary Redirection
ADVANCED OPTIONS
- Creating Custom PL/SQL Functions
- Registering PL/SQL Functions
- The Command Line Interface
- 10gAS Discoverer Plus and Viewer
- Registry Settings
What You Can Expect
On successfully completing this course, participants will be able to:
- 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
Who Should Take This Course
Oracle Discoverer Administrators, Support Staff, Analysts.
Recommended Prerequisites
Participants should have taken our Oracle Discoverer For End Users, or have equivalent experience. In addition, familiarity with Windows 98/NT/2000/XP, and understanding of Relational Databases is helpful.
Training Style
Short lecture sessions (60%) along with hands-on lab sessions (40%).
Related Courses
Code |
Course Title |
Duration |
Level |
|
ORDSCD |
ORACLE 10g/11g DISCOVERER DESKTOP For End Users |
2 Days |
I |
Details |
ORDSCP |
ORACLE 10g / 11g BI DISCOVERER PLUS for End Users |
2 Days |
I |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.