Oracle APEX Version 4.2.5

Course Number:


This course provides a complete, hands-on introduction to Oracle APEX 4.2.5, a premier rapid application development tool. It allows developers to efficiently create complex web-based applications to run on any operating system environment, including smart phones. Interactive reports can be created and customized by:

  • Searching and sorting,
  • Creating control break reports,
  • Performing highlighting to focus on specific rows or values,
  • Adding custom computations including aggregations,
  • Charting and custom dashboards.

In this class, students will learn by building a fully functioning application from the ground up.


This course is appropriate for any database user wanting to explore rapid application development, including end users, business analysts, application developers, database administrators and IT management.
Course Duration:
5 days


Students attending this course should have completed our five-day Oracle 11g or 12c SQL course or have equivalent experience.

Course Objectives:
Course Outline:
  • Introduction to APEX
    • Overview of the Class
    • History of APEX
    • APEX Instance Options
    • Tools
      • Web Browser Selection
      • SQL*Plus
      • SQL Developer
  • APEX Installation
    • Removing the Old Version
    • Installing the New Version
    • APEX ADMIN Setup
    • Configuring RESTful Services
    • Configuring the Embedded PL/SQL Gateway
    • Creating a Workspace
  • The APEX Workspace
    • Roles for APEX Users
    • Anatomy of an Application
    • Overview of APEX Modules
      • Application Builder
      • SQL Workshop Interface
      • SQL Commands Interface
      • SQL Scripts Interface
      • Utilities Interface
    • Team Development / Administration
  • Our Real-World Problem
    • Needed Database Objects
    • Designing For APEX
    • APEX And PLSQL
    • The “Parse As” Schema
  • Initial Object Design
    • Needed Database Objects
    • Tables
      • Views
      • Triggers
      • Sequences
      • Comments
    • Generating Application Documentation
  • Object Design II
    • Loading Data
    • Creating Lookup Tables
    • Loading and Running Scripts
    • User Interface Defaults
  • Creating and Navigating Apps
    • Using the Create Application Wizard
    • Understanding Websheets
    • Creating Applications from Spreadsheets
    • Creating Applications from Scratch
      • Regions
      • Public Pages / Global Pages
      • Navigation Bar Entries
      • Breadcrumbs / Lists / LOVs
  • Basic Forms and Reports
    • Forms on Tables
    • Forms on Procedures
    • Master-Detail Forms and Reports
    • Creating Searchable Reports
    • Using Declarative BLOBs
  • Advanced Forms and Reports
    • Creating Tabular Forms
    • Interactive Reports
    • User Help for Interactive Reports
    • Subscribing to Reports
    • Creating Calendars
    • Creating Charts
  • Programmatic Components
    • Using Conditions
    • Using Required Values
    • Using Validations
    • Creating Computations
    • Creating Processes
    • Using PL/SQL Regions
    • Using Dynamic SQL
  • Dynamic Actions
    • Understanding Dynamic Actions
    • Implementing Dynamic Actions
    • Using Multiple Triggering Elements
    • Using PL/SQL
    • Using JavaScript
  • APEX Security
    • Integrating User Security
    • Creating Needed Database Objects
    • Security Model Implementation
    • Authentication
    • Conditional Security
    • Controlling Data Access
    • Protecting Session State
  • Websheets
    • The Structure of a Websheet
    • Navigating Websheets
    • Websheet Help
    • Markup Syntax
    • Authenticating and Authorizing Users
    • Sections in Websheets
    • Using Annotations
  • Creating a Websheet Application
    • Creating the Database Objects
    • Websheet Creation and Configuration
    • Creating Websheet Content
  • Bundling and Deployment
    • Application Component Identification
    • Including Supporting Objects
    • Importing an Application
  • Additional Developer Tools
    • Understanding Page Locks
    • Application Groups / Page Groups
    • The APEX Data Dictionary
    • Monitoring APEX Applications
    • The APEX Advisor
    • APEX Build Options
    • Using Page-Specific Utilities
  • Workspace Management
    • The APEX Administration Interface
    • Service Management
    • Metadata Management
    • User / Group Management
    • Monitoring Activity and Dashboards
  • APEX Team Development
    • The Team Development Interface
    • Features
    • Milestones
    • To-Do Items
    • Bugs
    • Feedback
    • Team Actions
    • Available User Roles
Share on facebook
Share on twitter
Share on linkedin
Share on email

Related Posts

About Us

IT Training, Agile Ways of Working and High Impact Talent Development Strategies

Let Us Come to You!

Classes recently delivered in: Atlanta, Boston, Chicago, Columbus, Dallas, Detroit, Indianapolis, Jerusalem, London, Milan, New York, Palo Alto, Phoenix, Pittsburgh, Portland, Raleigh, San Antonio, San Diego, San Francisco, San Jose, Seattle, Springfield, Mass., St. Louis, Tampa and more!