Description

Thanks to this practical course, you will be able to develop Web-type applications whose goal is to access and present data from the Oracle database. You will understand how the Oracle Application Express development environment, more commonly known as ApEx, works.

Who is this training for ?

For whom ?

Application developers and administrators.

Prerequisites

Training objectives

Discover APEX components Master APEX architecture Develop tailor-made RAD applications Implement APEX security Install external resources

Training program

• Introduction
  • Installation and configuration of Application Express.
  • Using database objects.
  • Presentation of the user interface.
  • Manage and maintain the application development process.
  • Workspace login page.
  • Workspace home page.
  • Practical work Taking control of the environment and creating a workspace.
• Application Builder
  • Creation of simple applications.
  • Creation of forms, regions.
  • Creation of reports based on queries.
  • Creation interactive states, personalization of presentations.
  • Definition of the authentication model.
  • Creation and management of a theme.
  • Choice of the theme and copy of shared components.
  • Practical work Creating an application with forms and reports.
• Event management
  • Process triggering.
  • Creation of graphs and interactivity of these graphs.
  • Implementation of session variables.
  • Setting up controls on forms.
  • Creating interactive reports based on dynamic queries.
  • Practical work Creating graphs and interactive reports.
• Dynamic actions
  • Programming input controls in APEX forms in JavaScript.
  • Read and write access to APEX form data from stored procedures.
  • Triggering techniques of PL/SQL calculations in the background.
  • Creation of dynamic trees based on Oracle views.
  • Definition of master-detail structures.
  • Cascading selection lists.
  • Programming controls, in PL/SQL, on tabular forms.
  • Practical work Creating master-detail reports and lists cascade selection.
• Workspace administration
  • Application Express organization.
  • Roles in Application Express.
  • Access in Application Express Administrator mode.
  • Creation of workspaces and editing of different parameters.
  • Increasing the size of a workspace.
  • Practical work Creating and managing workspaces work.