About this Course

Tech Type Essentials
Duration 3 Days

This Oracle Application Express Workshop II will help you extend your skills with Oracle Application Express. Learn to extend your applications using collections, dynamic applications and plug-ins.

Learn To:

  • Generate Form based on Methods on Tables utility.
  • Create and use RESTful Web Services.
  • Customize themes and templates.
  • Create a master application and custom theme.
  • Migrate an existing application to a responsive theme.
  • Incorporate interactivity in your application.
  • Build tabs based on a static list.
  • Secure your application.
  • Deploy and maintain your applications.
  • Optimize your application performance.

Benefits to You:

Because Oracle APEX resides within the Oracle Database and can easily integrate with authentication schemes (like Oracle Access Manager, SSO and LDAP) you can learn to build secure applications that can scale to meet your largest user communities. Attending this workshop will help you build on what you learned in the 5-day Oracle Application Express Workshop I course.

Gain Hands-On Experience:

Enrolling in this workshop helps you explore how to use collections, add dynamic actions, use powerful plug-ins to extend functionality in your applications and create and consume a RESTful Web Service. Themes and Templates used in Oracle Application Express (Apex) are also discussed, along with responsive design, which is a recent user interface design principle used in Apex. You'll learn how interactivity can be included in your applications by creating tooltips, scrolling regions and displaying a modal window initiated from a report. This course is 50% lecture and 50% hands-on practices.

Target Audience:

  • Forms Developer
  • Web Administrator
  • Business Intelligence Developer
  • Database Administrators
  • System Analysts
  • Application Developers
  • Project Manager


  • Basic knowledge of SQL, PL/SQL, and HTML
  • Oracle Application Express Workshop I

Delegates will learn how to

At the end of this course you will be able to:

  • Create and use RESTful Web Services
  • Generate Form based on Methods on Tables utility
  • Make your application accessible
  • Customize themes and templates
  • Incorporate Interactivity in your application
  • Build tabs based on a static list
  • Extend your applications using collections, dynamic applications, and plug-ins
  • Secure your application
  • Deploy and maintain your applications


Course Overview

  • Course Objectives
  • Lesson Schedule
  • Course Environment: Products Installed
  • Course Environment: Workspace Details
  • Accessing the Labs Directory

Introducing and Review

  • Quick Review of What You Already Know
  • Packaged Application Used in this course
  • Additional Resources

Using Collections

  • What is a Collection?
  • Create a collection on an interactive report

Generating and Using Table APIs

  • What is a Table API?
  • Generate a Table API
  • Modify the Table API
  • Add a Form to an Application that shows how to add the process that will insert or update the database using the Table API

Extending Your Application: Dynamic Actions

  • Process a Modal Window using Dynamic Actions
  • Delete a Row in a Report using Dynamic Actions

Extending Your Application: Plug-ins

  • Import and use region type plug-ins, such as Big Value List, CSS Bar Chart
  • Optimize the performance of your plug-ins

Creating and Using RESTful Web Services

  • What is a RESTful Web Service?
  • Components of a RESTful Web Service
  • An Example: RESTful Web Service
  • Creating a new RESTful Web Service
  • Consuming a RESTful Web Service in an APEX Application

Using Themes and Template

  • Application Types: Desktop, Mobile, Responsive
  • Theme Overview: Which ones are for which type of Application
  • Review the layout of a Page template
  • Using Substitution Strings in Templates
  • Review a page that contains a report and review the region template and then the report template
  • Create and modify a theme
  • Switch to the Custom Theme

Making Your Application Accessible

  • What is Web Accessibility?
  • Accessibility Modes
  • About VPAT
  • Areas in an Application that need to be accessible
  • Testing Application to identify accessibility issues
  • Show an example of an accessible app and what features make it so

Incorporating Interactivity in Your Application

  • Tooltip
  • Scrolling Region
  • Modal Region

Building Tab Drop Down as Dynamic/Static List

  • Show how to create the Tab structure using a List

Securing Your Application

  • What Is a Directory?
  • Oracle Internet Directory
  • Technical Architecture: Overview
  • Authenticating Users by Using LDAP
  • SQL Injection
  • Cross-Site Scripting
  • Application Level security
  • Restricted Characters - at the item level

Deploying and Maintaining Your Application

  • Application Components
  • Things to consider
  • Backups

Optimizing Your APEX Application

  • Application Performance Considerations
  • Managing Services
  • Monitoring Activity
  • Database Configuration Considerations
  • Monitoring Application Performance

3 Days

Delivery Method

Delivery method


Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0113 220 7150 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.