Feedback

Feedback to trainingforit.co.uk

Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall
You are here: Find Courses/Tr... / Shropshire / StayAhead Training / Oracle Reports

Oracle Reports

Summary
Length:
4 days
Price:
1,795 GBP excl. VAT
Training Provider:
StayAhead Training plusStayAhead Training
Location:
London
Training Method:
Open / Scheduled
Startdate:  
London: 02/04/2012, 31/07/2012, 16/10/2012
arrow Request Information     arrow Course homepage     arrow Contact     arrow Save

About Oracle Reports

Oracle Reports Course Overview
This Oracle Reports course introduces the delegate to the main concepts of Oracle Reports Developer.  It is designed to give delegates practical experience in designing and creating Web and paper Reports using the Oracle Report Wizard, to add dynamic report data to static HTML pages and to publish reports on the Web.

Skills Gained
The delegate will practice:
  • 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
  • Using Cascading Stylesheets in Web Reports
  • 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
  • Adding dynamic web links to 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

Who will the Course Benefit?
The Oracle Reports course is designed for database administrators, software development and technical support personnel who need to create reports in a variety of styles and customize reports to meet their business requirements.

Course Objectives
To provide the skills needed to design and create Web and paper reports using the Report Wizard.

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

Pre-Requisite Courses
  • Oracle SQL


  • Oracle PL/SQL




Follow-On Courses
  • Oracle PL/SQL Stored Program Units


  • Oracle Forms - Part I


  • Oracle Database 10g DBA - Part I




NOTE: Course technical content is subject to change without notice.

Oracle Reports Training Course
Course Contents - DAY 1
Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE REPORTS DEVELOPER
  • Overview of Oracle Reports Developer
  • Oracle Reports Developer Basic Concepts
  • Paper and Web Reports
  • Key Features and Benefits
  • Oracle Application Server Reports Services
  • Designing Reports
  • Available Reports Styles

Session 2: CREATING A BASIC TABULAR PAPER REPORT
  • Invoke the Reports Builder
  • Use the Object Navigator
  • Designing a Report to Retrieve Data Efficiently
  • Use the Report Wizard to Build a Report
  • Use Query Builder to Create the Query
  • Apply an Appropriate Template
  • Reports Property Palette
  • Modify the Layout Model
  • Save the Report in an Appropriate Format
  • Exercise:   Create various tabular reports

Session 3: CREATE A WEB REPORT
  • Use JavaServer Page Technology to Build a Web Report
  • Testing a Report on the Web
  • Web Technology in Oracle Reports
  • Create a Web Report Using the Report Wizard
  • Examine the Source Code Using the Web Source View
  • Make Basic Enhancements to the Web Source Code
  • Create a Cascading Stylesheet for a Report
  • Preview a Report on the Web
  • Exercises:
    • Create a web report
    • Modify the web source code of a report

Session 4: MANAGING REPORT TEMPLATES
  • Modify a Predefined Template
  • Create a New Template
  • Configure the Report Builder Preferences
  • Exercise:   Create templates

Session 5: BREAK REPORT
  • Concepts of the Break Report
  • Data Model Objects: Report Groups
  • Formula Columns
  • Summary Columns
  • XML Settings
  • Repeating Frames
  • Use the Wizard to Create a Break Report
  • Modify the Data Model
  • Modify Field Properties
  • Customise the Web Source Field Tags
  • Display System Variables
  • Display Report Margins
  • Add Boilerplate Text and Images
  • Embed Report Variables in Boilerplate Text
  • Include Report Variables in the Web Source Code
  • Exercises:
    • Create various break reports
    • Add formula columns to a report
    • Customise the report with text, images & system data

Oracle Reports Training Course
Course Contents - DAY 2
Session 6: FORM REPORT
  • Design and Create a Form Report
  • Embed Data in Boilerplate Text
  • Flex and Confine Modes
  • Use the Arrange Objects tools in the Layout
  • Group Operations
  • External Queries
  • Exercise:
    • Create a form-style report and customise the layout
    • Use an external query in the report

Session 7: MASTER DETAIL REPORTS
  • Multi-Query Reports
  • Use Data Links in the Layout Model
  • Create a Master/Detail Report
  • Control the Pagination of Layout Objects
  • Use the Report Block Tool for a Customised Layout
  • Use the Report Block Tool in a Web Report
  • Exercise:
    • Create a Report Using Multiple Queries
    • Add an Additional Layout to a Report

Session 8: LAYOUT MODEL OBJECTS
  • Frames
  • Fields
  • Boilerplate
  • Anchors
  • Images
  • Sections
  • Displaying a file in a column
  • Exercises:
    • Display a file in a form-style report
    • Add a new section to a report

Session 9: LETTERS AND MAILING LABELS
  • The Mailing Label Report Style
  • The Form-Letter Report Style
  • Exercise:
    • Create Report consisting of a letter with mailing
    • Labels to the recipients

Oracle Reports Training Course
Course Contents - DAY 3
Session 10: MATRIX REPORTS
  • Introduction to Matrix Reports
  • The Matrix Data Model
  • To Create a Single Query Matrix Report
  • Matrix Summaries
  • Multi-Level and Break Matrices
  • Child dimension in matrix reports
  • Exercise:   Create various matrix reports

Session 11: PARAMETERS
  • System Parameters in Reports
  • Using Bind Parameters in Reports
  • The Use of Lexical Parameters
  • Lists of Parameter Values
  • The Parameter Form Screen
  • Creating Parameter HTML Extensions
  • Exercise:   Create reports with bind and lexical parameters

Session 12: PL/SQL AND TRIGGERS IN REPORTS
  • PL/SQL in Oracle Reports
  • Report Level Triggers
  • Group Filters
  • Use Parameters and Placeholders in a Report
  • External and Internal PL/SQL Procedures
  • PL/SQL in Oracle Reports Builder
  • Create, attach and use PL/SQL Libraries
  • Oracle Reports PL/SQL Packages
  • Report Level PL/SQL
  • Creating Reports using Ref Cursor Queries
  • Enhance the Web source code with triggers
  • Use JSP in the web source code instead of triggers
  • The SRW Package
  • Create dynamic web links using PL/SQL functions
  • Exercises:
    • Add triggers to existing reports
    • Create a report with a ref cursor query

Session 13: REPORT DISTRIBUTION
  • Report Distribution and distribution files
  • Distribute Paper Report sections
  • Burst a Paper Report to multiple destinations
  • Exercises:   Burst a report to multiple destinations

Oracle Reports Training Course
Course Contents - DAY 4
Session 14: WEB REPORTING
  • Build Reports for the Web
  • Use JSP in Oracle Reports
  • HTML and PDF in Reports Builder
  • Web Links for HTML Output
  • Style Sheets
  • Add a Bookmark to a Paper Report
  • Add a Hyperlink to a Paper Report
  • Add Dynamic Content to a Web Page
  • Create an HTML file from a report
  • Create a delimited file from a report
  • Add Report Data to a HTML File
  • Prepare a Paper Based Report for the Web
  • Add Web Links to Paper Based Reports
  • HTML Special Characters
  • Exercises:
    • Create report output in different formats
    • Add a dynamic hyperlink to a report

Session 15: XML AND PLUGGABLE DATA SOURCES
  • Storing Reports as XML files
  • Generating XML Output from a Report
  • Reports based on an XML Pluggable Data Source
  • Reports based on Text Pluggable Data Source
  • Exercises:   Create reports based on XML and text pluggable data sources

Session 16: USING GRAPHICS IN A REPORT
  • Oracle Graphics Objects
  • Create and Embed a Graph using the Graph Wizard
  • Add a Graph to a Web report
  • Customise a Graph in a Report
  • Exercises:
    • Create and embed a graph in a report
    • Exercise:   Add the graph to the web report

Session 17: USING ORACLE APPLICATION SERVER REPORTS SERVICES
  • Report Request Methods
  • Oracle Application Server Reports Services
  • Architecture Report Request Methods
  • JSP Runtime Architecture
  • Servlet Runtime Architecture
  • Viewing and Scheduling Reports
  • Monitoring and Managing Reports Services
  • Exercise:   Create a web page to run reports

Session 18: PERFORMANCE ISSUES
  • Designing Efficient Reports
  • Monitor the Performance of Reports
  • Investigate Performance Issues
  • Exercise:   Use Report Monitoring Tools
  • Conclusion
  • Appendices:
    • Supported File Types
    • Reports Executables
    • JSP Tags used in Web Reports
    • The SRW Packaged Procedures
    • Glossary

Continuing studies

Follow on courses: Oracle PL/SQL Stored Program Units, Oracle Forms - Part I, Oracle Database 10g DBA - Part I

Expenses

£1,795.00

About StayAhead Training

technical it training

SQL, Oracle, UNIX and Linux experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

unix, linux, oracle, sql, javaSpecialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

specialist it training


plus Show all courses with StayAhead Training

Request information - obligation free

Get more information from StayAhead Training by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from StayAhead Training, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116
www.stayahead.com


More Information
Request Information
To request information from Oracle Reports, please fill out the following details:

What happens now?
Write a course review
Have you studied » Oracle Reports at » StayAhead Training? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk
Find Courses/Training
Discussion forum
Blog
Course advice
Quote request

Training Providers

About Us

About Us About Us
Training Quote Training Quote
Contact Us Contact Us
Partners Partners
User guide to Findcourses.co.uk User guide to Findcourses.co.uk
Press Press
Link to us Link to us