icon icon

Programming in Oracle APEX. Creating web applications

icon

Training process

Training needs analysis

If you have specific requirements regarding the training programme, we will carry out a training needs analysis for you. This will guide us on which aspects of the programme should receive greater emphasis, so that the training programme meets your specific needs.

What will you gain?

icon

Build apps in APEX - You will learn how to create web applications in Oracle APEX using built-in wizards and developer tools, so you can deliver working business solutions faster and with less manual effort.

icon

Design pages and navigation - You will master Page Designer and learn how to structure pages, forms, reports, and navigation so your application stays clear, easy to use, and aligned with real user workflows.

icon

Work with database objects - You will learn how to create tables, views, sequences, and relationships in Oracle, giving you a solid data model for your application and a cleaner way to organize business data.

icon

Implement PL/SQL logic - You will use procedures, functions, validations, and dynamic actions inside the application to automate tasks, control data quality, and implement business rules without fragile workarounds.

icon

Use modern UI components - You will work with calendars, charts, dashboards, and interactive reports, allowing you to build more engaging interfaces that make analysis easier and improve day-to-day user productivity.

icon

Secure application access - You will learn to implement authentication, authorization, and access restrictions for pages and data, so you can protect the application properly and match permissions to user roles.

icon

Connect APIs and JSON - You will gain practical experience with RESTful Web Services, Web Source Modules, and JSON data, enabling you to integrate APEX applications with external systems and automate data exchange.

icon

Debug and improve quality - You will use diagnostic tools, performance tuning techniques, and coding standards, which will help you maintain applications more easily, troubleshoot faster, and keep development organized.

Training programme

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.

What are the prerequisites for participating in the training?

icon

Basic SQL skills - You should be comfortable reading simple SQL queries and understand data operations such as SELECT, INSERT, UPDATE, and DELETE to work effectively with Oracle databases.

icon

Relational database basics - You should understand tables, columns, primary keys, and relationships between data, because these concepts are essential when designing the structure of an application.

icon

Programming logic basics - You should understand conditions, variables, and simple program flow so you can move smoothly into validations, dynamic actions, and business logic in PL/SQL.

icon

Comfort with web tools - You should be able to navigate web applications and developer tools with ease, because the training expects you to work independently in the Oracle APEX interface.