يمكنك إضافة المزيد من الدورات التدريبية هنا.
سيتم حفظ القائمة.

الصفحة الرئيسية دورات أيرلندا دورات معتمدة من أوراكل Oracle9i Discoverer Desktop

تفاصيل الدورة

This course will teach students the purpose and capabilities of the Discoverer 9i Desktop tool. Users learn to create fully customized ad-hoc queries. They will also learn how to modify the display, drill to data at several levels, analyze the data graphically, and perform other various tasks such as scheduling, importing and exporting workbooks. Administrators should attend this course first.

Prerequisites:
The target audience for this course is end users and administrators of the Oracle 9i Discoverer Desktop tool.

There are no prerequisites to this course
Creating queries:
  • Starting discoverer desktop
  • Command line options
  • Online help
  • The workbook wizard
  • The results window
Query management:
  • Managing workbooks
  • Adding and duplicating workbooks
  • Moving/copying workbooks
  • Editing workbooks
  • Renaming and deleting workbooks
  • Managing items
Modifying the display:
  • Adding a report title
  • Page setup options
  • Formatting headings
  • Changing heading text
  • Modifying heading properties
  • Formatting data
  • Changing default column size
  • Displaying images in background
  • Modifying data display properties
  • Printing the report
Working with conditions and parameters:
  • Viewing, applying, displaying conditions
  • Creating new conditions
  • Using the new condition dialog
  • Multiple and nested formula conditions
  • Subqueries
  • Create conditions using the Analysis bar
  • Editing conditions
  • Working with parameters
  • Viewing, applying and disabling parameters
  • Creating new parameters
  • Executing the query with the parameter wizard
Working with exceptions and calculations:
  • How exceptions are used
  • Viewing, applying and disabling exceptions
  • Creating and editing exceptions
  • Working with calculations
  • Viewing, displaying and hiding calculations
  • Creating calculations using the edit calculation dialog
  • Creating calculations using the analysis bar
  • Editing calculations
Working with sorts, totals and percentages:
  • Creating column sorts
  • Creating group sorts
  • The sort table dialog
  • Working with totals
  • Viewing, displaying, hiding tools
  • Creating/editing totals using the total dialog
  • Working with percentages
  • Viewing, displaying, hiding percentages
  • Creating/editing percentages
  • Using the percentage dialog
  • Using the analysis bar to create percentages
Drilling the data:
  • Using the drill dialog
  • Specifying drill options
  • Drilling to a related item
  • Drilling to details in another sheet
  • Drilling to external applications
Graphing data:
  • Creating a graph
  • Selecting a graph type
  • The graph window
  • Customizing the graph
  • 3D view properties
  • Scale and numbers
  • Editing the graph
Workbook maintenance :
Scheduling workbooks • Schedule workbook dialog • Scheduling manager • Opening scheduled workbooks • Exporting discoverer output • Using the export dialog • Sending workbooks via e-mail
Working with SQL and setting options:
  • Viewing, exporting and importing SQL
  • The SQL inspector and plan display
  • Setting discoverer options
  • General options
  • Query governor options
  • Table/crosstab options
  • Format options
  • Cache options
  • Advanced options
  • EUL options
  • Connection options
Using SQL functions in discoverer :
  • Function categories
  • Types of functions
  • String functions
  • Numeric functions
  • Numeric comparison and presentation functions
  • Date functions
  • Nesting a function
تحديث بتاريخ 08 November, 2015

الموقع

عرض الخريطة الموقع Westland Square Pearse St Dublin 2 Ireland

نبذة عن معهد 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.
عرض الجميع دورات Professional Training Solutions Ltd
اسأل ليمون
View more Courses
عرض جميع الوظائف المتاحة حالياً في مجال دورات معتمدة من أوراكل في أيرلندا
Are you from Professional Training Solutions Ltd ? Claim your course!
دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Oracle ابتداءً من الآن. See all courses
عرض جميع الدورات التدريبية

هل هذه الدورة التدريبية الاختيار المناسب لك؟

لم تجد ما كنت تبحث عنه؟

جرب البحث عنه!
أو
استعراض الدورات التدريبية ذات الصلة

لست واثقًا أي الدورات التدريبية تحضر؟ دعنا نرشدك