Course details
This course gives participants hands-on experience with administration tasks for Oralce`s Graphical User Interface (GUI) based ad hoc query and data access tool - Discoverer.
Prerequisites:
Oracle Discoverer 4i Desktop, familiarality with Windows 95/98 or Windows NT. Understanding of Relational Databases helpful.
Introduction:
- Benefits of Discoverer
- Components of Oracle Discoverer
- Business Areas
- The role of the discoverer administrator
Setting up the Tutorial:
- Starting Oracle Discoverer Administration edition
- Grant access privileges to the users
- Granting business area access
- Customise Items
- Lists of values (LOV)
- Alternative sorts
- Calculated items
- Designing complex folders
- Creating and working with Hierarchies
- Create summary folders
- Content type
Building a New Business Area:
- Building the business area
- Managing a business area
Access Privilages and Secrity:
- Using the privileges window
- Database Security
Item Classes and List of Values:
- Item Classes
Joins:
- Joins
- Fan traps
Calculations:
- Calculations
Conditions:
- Conditions
- Compound/complex conditions
Hierarchies:
- Item Hierarchies
- Date Hierarchies
Summaries:
- Summary tables
Advanced Options:
- Registering PL/SQL functions
- Command line options
Course Location
About Professional Training Solutions Ltd
Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
See all Professional Training Solutions Ltd coursesAdministration and Secretarial Related Questions
Are you from Professional Training Solutions Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on Administration and Secretarial starting now.
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Become an ORACLE Developer eduCBAAED 99
AED 451Duration: Upto 181 Hours - Administrator Study 365AED 88Duration: 3 Hours
