Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
Business Analysis
Business Intelligence
Business Objects
Business Skills
C++ programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Datawarehousing
DB2
Desktop Application Software
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Discoverer 10g: Develop An EUL
Oracle Training Overview

This Oracle 10g courseware training guide book will teach how to create and customize the End User Layer, how to create business areas and folders, and define analytical facilities for end users. Students also learn about the different types of connection mechanisms supported by OracleAS Discoverer and how to control the user access to the End User Layer. Students learn how to use materialized views and automated summary management. In addition, students learn how to use Oracle Enterprise Manager 10g Application Server Control to configure OracleAS Discoverer.

Oracle Training Audience

  • Business Analysts
  • Data Warehouse Administrators
  • Data Warehouse Analysts
Oracle Training Prerequisites

The course Oracle AS Discoverer 10g: Create Queries & Reports

Oracle Training Suggested Next Courses

The course Oracle Reports 10g: Build Reports

Oracle Training Course Objectives

  • Optimize query performance, using summaries
  • Manage and configure Discoverer, using Application Server Control
  • Describe the Single Sign On Option supported by Discoverer
  • Register Discoverer as a portlet provider with OracleAS Portal
  • Add Discoverer portlets to a portal page
  • Design, create, and maintain the End User Layer
  • Implement and administer Discoverer
  • Control user access to and Customize the End User Layer
Oracle Training Course duration

3 Days

Oracle Training Course outline

INTRODUCTION TO DISCOVERER DESKTOP AND WEB INTERFACES DISCOVERER END USER TOOLS
  • DEVELOPING REPORTS
  • WORKBOOK MAINTENANCE
  • USING CONDITIONS
  • DRILLING THE DATA
CREATING AND MANAGING BUSINESS AREAS
  • DISCOVERER COMPONENTS
  • INSTALLING THE EUL
  • STARTING ORACLE10G DISCOVERER ADMINISTRATOR
  • USING THE CREATE EUL WIZARD
  • DELETING AN END USER LAYER
  • CREATING A BUSINESS AREA USING THE LOAD WIZARD
  • THE WORK AREA
  • MANAGING BUSINESS AREAS
  • OPENING A BUSINESS AREA
  • CLOSING BUSINESS AREAS
  • ADDING BUSINESS AREAS
  • DELETING BUSINESS AREAS
  • BUSINESS AREA PROPERTIES
  • ONLINE HELP
WORKING WITH FOLDERS AND JOINS
  • WORKING WITH FOLDERS
  • ADDING FOLDERS WITH THE LOAD WIZARD
  • MANAGING FOLDERS
  • DELETING FOLDERS
  • CREATING CUSTOM FOLDERS
  • ADDING AN EMPTY COMPLEX FOLDER
  • CREATING COMPLEX FOLDERS
  • WORKING WITH JOINS
  • CREATING JOINS
  • EDITING JOINS
  • DELETING JOINS
  • JOIN PROPERTIES
  • SORTING FOLDERS
WORKING WITH ITEMS AND ITEM CLASSES
  • WORKING WITH ITEMS
  • CREATING CALCULATED ITEMS
  • EDITING ITEMS
  • DELETING ITEMS
  • SORTING ITEMS
  • REGISTERING PL/SQL FUNCTIONS
  • ITEM CLASSES
  • CREATING ITEM CLASSES WITH THE ITEM CLASS WIZARD
  • THE ITEM CLASSES TAB
  • THE EFFECT OF THE ITEM CLASS
  • EDITING ITEM CLASSES
  • DELETING ITEM CLASSES
  • ITEM CLASS PROPERTIES
WRITING AND REGISTERING A PL/SQL FUNCTION
  • THE NEED FOR PL/SQL FUNCTIONS
  • WRITING THE FUNCTION
  • REGISTERING THE FUNCTION
  • USING THE FUNCTION
WORKING WITH CONDITIONS AND HIERARCHIES
  • WORKING WITH CONDITIONS
  • CREATING CONDITIONS
  • EDITING CONDITIONS
  • DELETING CONDITIONS
  • CONDITION PROPERTIES
  • WORKING WITH HIERARCHIES
  • CREATING ITEM HIERARCHIES WITH THE HIERARCHY WIZARD
  • CREATING DATE HIERARCHIES WITH THE HIERARCHY WIZARD
  • THE HIERARCHIES TAB
  • THE EFFECT OF THE DATE HIERARCHY
  • EDITING HIERARCHIES
  • DELETING HIERARCHIES
  • HIERARCHY PROPERTIES
HIERARCHICAL QUERIES (CONNECT BY PRIOR)
  • USING HIERARCHICAL RELATIONSHIPS
  • ONE TO MANY (1:N) HIERARCHY
  • MANY TO MANY (M:N) HIERARCHY
ADVANCED HIERARCHICAL QUERIES
  • EXPANDING DISPLAYS FOR HIERARCHICAL QUERIES
  • ONE TO MANY HIERARCHY - ANY LEVEL
  • MANY TO MANY HIERARCHY - ANY LEVEL
  • CREATING THE BOM QUERY IN DISCOVERER DESKTOP
SECURITY AND PRIVILEGES
  • BUSINESS AREA SECURITY
  • USER PRIVILEGES
DISCOVERER SUMMARIES/MATERIALIZED VIEWS
  • SUMMARIES AND MATERIALIZED VIEWS
  • CREATING AND MAINTAINING SUMMARIES
  • CREATING SUMMARIES WITH THE SUMMARY WIZARD
  • CREATING SUMMARIES USING QUERY PERFORMANCE STATISTICS
  • REGISTERING AN EXTERNAL SUMMARY TABLE
  • THE SUMMARIES TAB
  • EDITING AND REFRESHING SUMMARIES
  • DELETING SUMMARIES
  • SUMMARY PROPERTIES
  • WHAT IS AUTOMATED SUMMARY MANAGEMENT?
  • ACCESSING THE UNDERLYING MATERIALIZED VIEW
BUSINESS AREA MAINTENANCE
  • EXPORTING
  • IMPORTING
  • MANAGE SCHEDULED WORKBOOKS
  • REFRESHING A BUSINESS AREA
  • SETTING THE DEFAULT EUL
USING EUL STATUS WORKBOOKS
  • WHAT ARE EUL STATUS WORKBOOKS?
  • THE DISCOVERER V5 EUL BUSINESS AREA
  • SETUP FOR EUL STATUS WORKBOOKS
  • USING EUL STATUS WORKBOOKS
USING THE COMMAND LINE INTERFACE
  • WHAT IS THE DISCOVERER COMMAND-LINE INTERFACE
  • USING THE DISCOVERER ADMIN COMMAND-LINE INTERFACE
  • USING THE DISCOVERER DESKTOP COMMAND-LINE INTEFRACE
ADMINISTERING DISCOVERER USING ENTERPRISE MANAGER SERVER CONTROL
  • DISCOVERER APPLICATION SERVER ARCITECTURE/OVERVIEW
  • MONITORING AS APPLICATION COMOPNENTS
  • MONITORING DISCOVERER COMPONENTS
  • CUSTOMIZE DISCOVERER PLUS LOOK AND FEEL
  • CUSTOMIZE DISCOVERER VIEWER LOOK AND FEEL
DISCOVERER DEBUG TRACE
  • REASONS FOR CREATING A DEBUG TRACE
  • SETTING UP THE DEBUG TRACE
  • GENERATING THE DEBUG TRACE
  • ABOUT THE DEBUG TRACE LOG FILE
  • USING METALINK


 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy