About this Course

Course Code TPD79659GC20
Duration 3 Days

Students attending the Oracle Application Express Workshop II workshop will build on the knowledge they learned in the 5-day Oracle Application Express Workshop I course. Students examine topics such how to use collections, add dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service in this course.Learn To:Extend Your applications using collections, dynamic application, and plug-ins.Create and use RESTful Web Services.Make your application accessible.Customize themes and templates.Establish a master application and corporate theme.Migrate an existing application to a new theme.Incorporate a jQueryUI ThemeRoller theme into your mobile application.Secure your application.Deploy and maintain your applications.Optimize your application performance.Benefits to YouStudents will benefit as they learn to ensure that the APEX application is accessible. A good portion of time will be spent on determining which theme to use based on the type of application students want to build (Desktop, Mobile or Responsive), how to customize the templates and build a Corporate Theme that many applications can use.You will learn how to setup a Master (Template) Application that contains common regions that are used as a starting point as well as learn how to build a landing pad page that helps to navigate throughout the application. You learn some considerations when upgrading your APEX applications to a reponsive theme and also how to incorporate a new jQueryUI ThemeRoller theme into your existing Mobile Application. Students will examine how to secure applications, determine deployment and backup strategies of an application. And finally, you will review some techniques to optimize the performance of your application.Live Virtual Class FormatA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Delegates will learn how to

  • 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
  • Extend Your applications using collections, dynamic applications, and plug-ins


Course Overview

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

Introducing Course Persona

  • Quick Review of What You Already Know
  • Securing Database Applications
  • What is a Packaged Application?
  • Components of Team Development
  • Workspace Administration
  • Other Components
  • Packaged Application Used in this course
  • Additional Resources

Using Collections

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

Extending Your Application: Dynamic Actions

  • Adding Dynamic Actions

Extending Your Application: Plug-ins

  • Authentication/Authorization Plug-in Capability
  • Using and Customizing the CSS Bar Chart Plug-In

Incorporating Interactivity in Your Application

  • Tooltip
  • Scrolling Region
  • Add buttons with conditions in the report page to display report based on the conditions
  • Add a procedure in AJAX to refresh a page region periodically
  • Configuring Oracle Application Express to send email

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

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 Templates

  • Application Types: Desktop, Mobile, Responsive - Explain what they are and what criteria determines which application to create
  • Theme Overview: Which ones are for which type of Application
  • Review the layout of a Page template
  • Include using CSS to customize the template
  • Using Substitution Strings in Templates
  • Utilize new page attributes - files/inline styles
  • Create and modify a theme
  • Establishing a Master Application and a Corporate Theme

Developing a New Theme for Your Application Using ThemeRoller

  • What is ThemeRoller?
  • Create a theme using the ThemeRoller

Securing Your Application

  • What Is a Directory?
  • Oracle Internet Directory
  • Technical Architecture: Overview
  • Authenticating Users by Using LDAP
  • SQL Injection
  • Cross-Site Scripting
  • Browser Security
  • Application Level Security

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

Globalization and Translation

  • Understanding Application Translation and Globalization Support
  • Specifying the Primary Language for an ApplicationLoading a New Language
  • Translating an Application
  • Translating the Data the Application Uses
  • Localization
  • Switching Languages

3 Days


This is a QA approved partner course

Delivery Method

Delivery method

Virtual learning

Recreates a classroom experience online, enabling full interactions with the learning professional leading the course.

Find dates and prices

The course is available on 1 different dates.

Trusted, awarded and accredited

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

All third party trademark rights acknowledged.