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

  • what is Oracle Application Express?
  • architecture and APEX capabilities,
  • user interface and development environment.

2. Web application development

  • fast application development (wizard-based),
  • forms, reports, interactive grids,
  • navigation and application layout (Page Designer).

3. Working with the Oracle database

  • creating tables, views, sequences,
  • relations and foreign keys,
  • SQL Workshop and data management.

4. Business logic in PL/SQL

  • 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, dashboards,
  • interactive reports and dynamic components,
  • event handling and user reactions.

6. Security and access control

  • authentication and authorization mechanisms,
  • restricting access to pages and data,
  • creating roles and users.

7. Integration with external systems

  • RESTful Web Services and Web Source Modules,
  • working with JSON data,
  • communication with API.

8. Debugging and good practices

  • 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.