Master advanced Oracle APEX features for dynamic, secure applications
Gain hands-on experience with real-world Oracle APEX projects
Develop expertise in optimizing APEX performance and securing applications
Learn from certified instructors with real-world Oracle APEX expertise
Earn a recognized certification that boosts your credibility in Oracle APEX
Enjoy flexible learning options that fit your busy schedule
Convenient and hassle-free payment plans
What you will learn:
Upcoming sessions
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 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
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
Upon finishing the training, you will:
1
Master dynamic actions and plug-ins to elevate the functionality and interactivity of Oracle APEX applications
2
Design robust, secure applications by integrating Table APIs and RESTful Web Services
3
Apply advanced performance optimization strategies to enhance the speed and efficiency of APEX applications
4
Create tailored, user-friendly interfaces by developing custom themes using ThemeRoller
5
Learn industry best practices for securing, deploying, and maintaining high-performing Oracle APEX applications
Overall ratings by our students
Our Oracle Application Express Workshop II course in South Africa is a technical development training course aimed at helping developers improve their skills in Oracle APEX. Some of the core topics include dynamic actions, plug-ins, integration with RESTful Web Services, and building custom themes with ThemeRoller. The course also focuses on performance optimization and security best practices, which will benefit those seeking to build advanced, secure web applications.
Completion of Oracle Application Express Workshop I—or proof of equivalent hands-on APEX knowledge in the field—is highly encouraged. Workshop II continues from basics like page layout, validations, and processes, then into dynamic actions, advanced custom plug-ins, and REST integration. Skipping the prerequisite will create knowledge gaps that hinder your pace through the intense labs and performance-tuning components.
Professionals can get jobs such as:
More senior graduates will find themselves in Technical Lead or APEX Practice Manager roles within major consultancies.
You will create end-to-end APEX applications: a service-desk ticketing solution and a sales-pipeline dashboard. These capstone projects will have you apply dynamic actions, secure REST endpoints, use performance diagnostics, and create a custom theme—all directly applicable skills in the workplace.
Yes, our workshop corresponds with the Oracle APEX Cloud Developer Professional exam. Each module corresponds to exam topics like APEX architecture, security, and data integration, providing you with focused practice questions and study guides to enhance exam preparedness.
A degree in information technology, computer science, or engineering forms a good base. Many professionals have other academic backgrounds—commerce, mathematics, or even humanities—if they have real-world SQL and basic programming skills. The hands-on labs of the course neutralize academic disparities by emphasizing practical problem-solving and not theory.
Learn now, pay later
Dive into your course now and pay in installments

