Oracle Application Express (APEX)

This 3-day ABIS course explains the basic characteristics of application development with APEX and practices them in a structured manner. Highly suitable for future professional and ahhoc APEX developers. Classroom presentation, interactive! Prior knowledge of SQL as well as PL/SQL is recommended.

This course provides students with product knowledge and skills needed to develop database driven web applications with Oracle Application Express (APEX).

At the end of the course, students will:

  • understand the APEX architecture (instance - workspace - application);
  • be able to use the ''SQL Workshop & Utilities'' component of APEX;
  • be able to develop data(base)-centric web applications - focusing on the development of new, full-functioning APEX applications;
  • be able to build and use application components to be integrated in APEX applications;
  • be able to build and use navigation components integrated in APEX - including the use of Shared Components in an APEX application;
  • understand workspace management - manage workspace users and groups; import/export workspaces and applications.

Schedule a training?

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

This course is intended for web application developers in an Oracle APEX context who want to build data(base) driven websites. 

Background

Before attending this course, students must have a working knowledge of relational databases and SQL (see SQL and relational databases fundamentals); some experience with PL/SQL might come in handy. For more advanced topics —typically beyond the scope of this text— it is recommended, that students have basic knowledge of HTML and CSS.

You can test for yourself to see whether you have sufficient SQL background by filling out the online self-test "SQL fundamentals".

Main topics

  • Introducing APEX
    • Architecture: instance - workspace - application
    • Managing Workspaces - managing users
    • Starting with Oracle APEX
  • Building an Application
    • Basics of APEX application development
    • From scratch - (From Spreadsheet - Building WebSheets)
    • Import and Export (Workspaces, Applications)
    • About Pages and Regions:
    • Pages: Page Definition, Page rendering and Page processing, Page manipulations, Page Zero
    • Regions: Region Definition
    • About Themes and Templates - and overruling settings and attributes
  • Application components (I) - Creating Reports
    • Creating reports from scratch
    • Creating distinct report ''types'' (classic, interactive, subtype and special reports)
    • Report headers - report templates - break formatting - column formatting
  • Navigation and Layout
    • The APEX List Manager: Lists, List regions, Trees
    • Application Navigation Interface
    • Breadcrumbs
  • Session management - State management
  • Application components (II) - Creating Forms & Items
    • Creating forms from scratch
    • Creating distinct form ''types'' (procedure, table, master detail, interactive grid, SQL based, ...)
    • Editing form attributes - form specifics
    • Items
  • Buttons
    • Buttons
  • Shared components
    • List of Values - Types of LOVs
    • Lists
    • (substitution) variables

Training method

Live instructor-led training, with plenty of opportunities for hands-on exercises and discussion

Certificate

At the end of the session, the participant receives a 'Certificate of participation'.

Duration

3 days.

Course leader

Kris Van Thillo (ABIS).

Reviews

Excellent

 
  (, )

Zeer goed, zeer duidelijk

 
  (, )

Cours très bien présenté par le formateur, accessible pour tous niveaux.

 
  (, )

Heeft zeker aan de verwachtingen voldaan. Namelijk de mogelijkheden van APEX leren kennen en essentiële programmatie.

 
  (, )

Een goede instapcursus om snel met APEX aan de slag te kunnen gaan

 
  (, )

SESSION INFO AND ENROLMENT