1. Introduction to Oracle APEX
Oracle Application Express is presented as a platform for developing database-driven web applications within the Oracle ecosystem. The training explains its architecture and key capabilities, then familiarizes participants with the user interface and the main elements of the development environment.
- what is Oracle Application Express?
- architecture and APEX capabilities,
- user interface and development environment.
2. Web application development
Building pages in Oracle APEX combines rapid development with deliberate interface design. The section covers wizard-based application creation, forms, reports, and interactive grids, then shows how Page Designer is used to organize navigation and arrange the overall page layout.
- fast application development (wizard-based),
- forms, reports, interactive grids,
- navigation and application layout (Page Designer).
3. Working with the Oracle database
A solid application starts with a well-structured Oracle database model. Participants create tables, views, and sequences, define relationships and foreign keys, and use SQL Workshop for everyday data management tasks that support further application development in APEX.
- creating tables, views, sequences,
- relations and foreign keys,
- SQL Workshop and data management.
4. Business logic in PL/SQL
Implementing business rules in Oracle APEX often relies on PL/SQL executed close to the data layer. This section covers database procedures and functions, the use of PL/SQL on application pages, and the link between server-side logic, validations, and dynamic actions in APEX.
- procedures and functions in the database,
- dynamic actions and validations in APEX,
- use of PL/SQL code on application pages.
5. Advanced interface components
Calendars, charts, and dashboards expand an application beyond basic data entry screens. Alongside interactive reports and dynamic components, the training explains how event handling and user-triggered reactions shape responsive interfaces and support more efficient work with information.
- calendars, charts, dashboards,
- interactive reports and dynamic components,
- event handling and user reactions.
6. Security and access control
Access to pages and data must be controlled consistently across the whole application. Participants work with authentication and authorization mechanisms, learn how to define users and roles, and configure restrictions that protect both navigation paths and underlying business information.
- authentication and authorization mechanisms,
- restricting access to pages and data,
- creating roles and users.
7. Integration with external systems
When an APEX application needs to exchange data with other platforms, integration patterns become essential. This part focuses on RESTful Web Services, Web Source Modules, JSON processing, and practical API communication used to read, transform, and present external data inside the application.
- RESTful Web Services and Web Source Modules,
- working with JSON data,
- communication with API.
8. Debugging and good practices
Efficient troubleshooting in Oracle APEX requires using diagnostic and debugging tools together with a structured review of application behavior. The section also addresses performance tuning, coding conventions, versioning practices, and UX choices that improve maintainability and everyday work with the codebase.
- diagnostic and debugging tools,
- optimization of application performance,
- coding styles, versioning, UX.