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.

Audience: 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
Prerequisites:

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

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