Oracle Application Express: Advanced Workshop

Oracle University |

Oracle Application Express: Advanced Workshop


3 Days


What you will learn

Students attending this workshop enhance their skills in Oracle Application Express. Students examine topics on using

application navigation to build site maps and dashboards. In addition, students learn about AJAX and Javascript and

how these can be used in an APEX application.

Students learn to build a Custom Tabular Form that uses collections and validation, develop their own themes and

templates and extend the application in the areas of PDF printing, email notifications, web services, and integrating with

other Oracle products such as SQL Developer, Application Server LDAP and SSO. Examining some of the other APIs

that are available as well as monitoring and managing your application using custom activity monitoring is also


Learn To:

Include application navigation techniques such as Database-Driven report generation, Site Maps, Dashboards and

Interactive Report Regions in APEX applications

Build custom tabular forms that contain validations and use collections

Incorporate JavaScript and AJAX into APEX applications

Extend applications using email notifications, using declarative support, incorporating web services and utilizing

integration with SQL Developer

Print reports within APEX using report queries and report layouts utilizing BI Publisher

Integrate APEX application with LDAP and SSO as well as prevent vulnerabilities associated with SQL Injection and

Cross-Site Scripting attacks


Application Developers

Database Administrators



Required Prerequisites

Oracle Application Express 3.0: Developing Web Applications

Oracle Database 11g: SQL and PL/SQL Fundamentals

Course Objectives

Monitor and manage your application by using custom reports

Manage application navigation by using hierarchical lists with images, database-driven navigation, site maps, and dashboards

Build custom tabular forms that use collections and validations

Manage application content dynamically by using JavaScript and AJAX

Copyright © 2009, Oracle. All rights reserved. Page 1

Extend your application to add binary large object (BLOB) data, send email notifications, use Web services, and integrate with SQL Manipulate application content through templates, themes, and style sheets

Create reports declaratively and use the print APIs

Secure your application by using LDAP and SSO and prevent SQL injection attacks and cross-site scripting and usage of Session

Course Topics

Build a Hierarchical List with Images

Build a Database Driven Navigation Report

Build a Site Map

Adding a Dashboard

Incorporate Security into Navigation

Manipulate Interactive Reports

Building Custom Tabular Forms

Build a Custom Tabular Form

Add Validations to your Tabular Form

Manage Changes to the Tabular Form using Collections

Using Javascript and AJAX Techniques

Incorporating some JavaScript examples into your APEX Application

Incorporating some AJAX examples into your APEX Application

Extending your Application

Adding BLOB Data to your Application

Sending Email Notifications

Incorporating Web Services into your Application

Accessing APEX Application objects in SQL Developer

Customizing Themes and Templates

Copying and Modifying a template

Creating and modifying a theme

Using a variety of styles in a template

Utilizing Application Express Printing

Printing a Standard Report with Derived Output

Creating a PDF Report with Multiple Queries

Including Dynamic Images in your Report

Creating a Report with a Custom XML and XSL

Sending a Report as an Email Attachment

Creating a Report with a Dynamic Layout Selection

Securing your Application

Authenticating Users Using LDAP

Configuring your Application for Single-Sign On

Preventing SQL Injection Attacks

Preventing Cross-Site Scripting

Using Session State Protection

Monitoring and Managing your Application

Using Prepackaged Monitoring Capabilities

Monitoring Activity of your Application

Monitoring Performance of your Application

Tuning your Application


Managing Application Navigation





pearson vueISO 9001