Oracle Application Express Workshop II Ed 2

Duration : 3 Days (24 Hours)

Oracle Application Express Workshop II Ed 2 Course Overview:

The Oracle Application Express Workshop II Ed 2 course is an advanced training that builds upon the knowledge from Workshop I. It covers topics such as using collections, dynamic actions, plug-ins, and working with RESTful Web Services. The course objectives include spreading applications using collections, implementing dynamic actions, customizing plug-ins, creating and consuming RESTful Web Services, making applications accessible, modifying themes, and creating a main application and corporate theme. Additionally, the course covers integrating jQueryUI ThemeRoller themes into mobile applications, ensuring application security, organization, and maintenance, and enhancing application performance.

Intended Audience:

  1. Participants who completed Oracle Application Express Workshop I course.
  2. Developers and IT professionals.
  3. Individuals interested in using collections, dynamic actions, plug-ins, and RESTful Web Services in Oracle Application Express.
  4. Those interested in spreading applications using collections, dynamic application, and plug-ins.
  5. Participants wanting to learn about making and practicing RESTful Web Services.
  6. Developers interested in making applications accessible and modifying themes and templates.
  7. IT professionals involved in creating main applications and corporate themes.
  8. Individuals looking to integrate jQueryUI ThemeRoller themes into mobile applications.
  9. Participants focused on securing, organizing, and maintaining applications.
  10. Developers and IT professionals aiming to enhance Oracle Application Express application performance.

Learning Objectives of Oracle Application Express Workshop II Ed 2:

Oracle Express Workshop II aims to facilitate application development and improve understanding of confirming the availability of APEX applications. It provides guidance on selecting the appropriate theme based on the desired application type (desktop, mobile, or responsive) and demonstrates how to modify templates for customization.

 Module 1: Course Overview
  • Course Objectives
  • Lesson Schedule
  • Course Environment: Products Installed
  • Course Environment: Workspace Details
  • Accessing the Labs Directory
  • 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
  • What is a Collection?
  • Create a collection on an interactive report
  • Adding Dynamic Actions
  • Authentication/Authorization Plug-in Capability
  • Using and Customizing the CSS Bar Chart Plug-In
  • 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
  • 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
  • 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
  • Application Types: Desktop, Mobile, Responsive – Explain what they are and what criteria determines which application to creat
  • 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
  • What is ThemeRoller?
  • Create a theme using the ThemeRoller
  • 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
  • Application Components
  • Things to consider
  • Backups
  • Application Performance Considerations
  • Managing Services
  • Monitoring Activity
  • Database Configuration Considerations
  • Monitoring Application Performance
  • 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

Oracle Application Express Workshop II Ed 2 Course Prerequisites:

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

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.