Home > Training Course Catalogue > IT Vendor Courses > Oracle Developer Training Courses > Reports

Perpetual Solutions
Tuition House
27-37 St Georges Road, London
SW19 4DS

+44 (0)20 7620 0033
+44 (0)20 7620 0055

 

Training Course Outline

IT Vendor CoursesIT Vendor Courses   Oracle Developer Training CoursesOracle Developer Training Courses


Course outline for ReportsReports


View course dates


Course Duration: 4 days


Course Code: OR


Course Description:


This course is aimed at database administrators, software developers and technical support personnel who need to create reports in a variety of styles and customise reports to meet their business requirements.

 

By the end of this course, delegates will understand the main concepts of Oracle Reports Developer.  The course is designed to give delegates practical experience in designing and creating web and paper reports using the Report Wizard.  They will also be able to add dynamic report data to static HTML pages and publish reports on the web.  


Prerequisites:

A working knowledge of SQL*Plus and PL/SQL is required. T his can be obtained by attendance on the pre-requisite courses. Familiarity with basic XML and HTML would be an advantage.


Prerequisite courses:

SQL*Plus

PL/SQL


This course includes the following modules:

Course topics:

  • Creating paper and web reports
  • Defining report queries
  • Building reports in various different formats
  • Applying queries, groups, calculations and summaries to a report
  • Editing and manipulating boilerplate and layout objects
  • Editing and enhancing the Web source code
  • Building master/detail and matrix reports
  • Building and using report templates
  • Using PL/SQL to base reports on ref cursor queries
  • Using PL/SQL trigger code for validating and formatting reports
  • Using XML and text pluggable data sources in reports
  • Using Parameters in Reports
  • Adding graphics to a report
  • Distributing and bursting reports
  • Tuning reports
  • Maximizing report performance using Oracle AS Reports Services
  • Publishing reports on the Web
  • Adding dynamic data to an HTML page

 

Location

Duration

RRP

Jan

Feb

Mar

Apr

May

Jun

Click on course date to make a booking, check availability, or find out about available discounts.

London

4 days

£1495

 

 

 

14 - 17

 

 


<< Previous 6 Months

Next 6 Months >>

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.


Save as PDFSave as PDF

PrintPrint this course



© Perpetual Solutions Ltd 2008.   Perpetual Solutions, Tuition House, 27-37 St Georges Road, London, SW19 4DS. +44 (0)20 7620 0033 +44 (0)20 7620 0055