Application Express: Advanced Workshop

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 discussed.

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

Audience: Application Developers
Database Administrators
Developer

Prerequisites: PL/SQL & Oracle Application Express 3.0: Developing Web Applications

Next Course:

Relevant Certification:

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
• Extend your application to add binary large object (BLOB) data, send email notifications, use Web services, and integrate with
• 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:

Managing Application Navigation
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