Develop Intelligence
Introduction To Application Express
To introduce database users and administrators to Oracle APEX 5.0, Oracle’s premier Rapid Application Development tool.

The Introduction To Application Express training course provides a complete, hands-on introduction to Oracle APEX 5.0, Oracle’s premier Rapid Application Development tool.

With this revolutionary tool, you can, quickly and efficiently, create highly complex web-based applications that will run on any operating system environment, including smart phones.

In this class, you will build a fully-functioning application from the ground-up. If you are a database user wanting to explore rapid application development, this class is for you. This course requires completion of five-day Oracle 11g or 12c SQL course or equivalent experience, and completion of five-day Oracle 11g or 12c PL/SQL course or equivalent experience.

After this course, you will be able to:

  • Completely understand how to create highly complex web-based applications
  • Create interactive reports that allow for full customization, including:
    • 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
This course will be delivered in 5 Days

DI will work with you and your team to define the most appropriate delivery structure, schedule and dates. Structure, schedule and dates will be determined by project schedule, team availability and classroom availability. And of course, it will also be determined by DI’s instructor availability.

In the Introduction To Application Express training course you’ll learn:

  • Chapter 1 – Introduction To APEX
    • Overview Of The Class
    • History Of APEX
    • APEX Instance Options
    • Tools
      • Web Browser Selection
      • SQL*Plus
      • SQL Developer
  • Chapter 2 – 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
  • Chapter 3 – 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
  • Chapter 4 – Our Real World Problem
    • Needed Database Objects
    • Designing For APEX
    • APEX And PLSQL
    • The “Parse As” Schema
  • Chapter 5 – Initial Object Design
    • Needed Database Objects
      • Tables
      • Views
      • Triggers
      • Sequences
      • Comments
    • Generating Application Documentation
  • Chapter 6 – Object Design II
    • Loading Data
    • Creating Lookup Tables
    • Loading And Running Scripts
    • User Interface Defaults
  • Chapter 7 – Creating & 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
  • Chapter 8 – Basic Forms And Reports
    • Forms On Tables
    • Forms On Procedures
    • Master-Detail Forms And Reports
    • Creating Searchable Reports
    • Using Declarative BLOBs
  • Chapter 9 – Advanced Forms And Reports
    • Creating Tabular Forms
    • Interactive Reports
    • User Help For Interactive Reports
    • Subscribing To Reports
    • Creating Calendars
    • Creating Charts
  • Chapter 10 – Programmatic Components
    • Using Conditions
    • Using Required Values
    • Using Validations
    • Creating Computations
    • Creating Processes
    • Using PL/SQL Regions
    • Using Dynamic SQL
  • Chapter 11 – Dynamic Actions
    • Understanding Dynamic Actions
    • Implementing Dynamic Actions
    • Using Multiple Triggering Elements
    • Using PL/SQL
    • Using JavaScript
  • Chapter 12 – APEX Security
    • Integrating User Security
    • Creating Needed Database Objects
    • Security Model Implementation
    • Authentication
    • Conditional Security
    • Controlling Data Access
    • Protecting Session State
  • Chapter 13 – Websheets
    • The Structure Of A Websheet
    • Navigating Websheets
    • Websheet Help
    • Markup Syntax
    • Authenticating & Authorizing Users
    • Sections In Websheets
    • Using Annotations
  • Chapter 14 – Creating A Websheet Application
    • Creating The Database Objects
    • Websheet Creation And Configuration
    • Creating Websheet Content
  • Chapter 15 – Bundling And Deployment
    • Application Component Identification
    • Including Supporting Objects
    • Importing An Application
  • Chapter 16 – 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
  • Chapter 17 – Workspace Management
    • The APEX Administration Interface
    • Service Management
    • Metadata Management
    • User / Group Management
    • Monitoring Activity And Dashboards
  • Chapter 18 – APEX Team Development
    • The Team Development Interface
    • Features
    • Milestones
    • To-Do Items
    • Bugs
    • Feedback
    • Team Actions
    • Available User Roles

Call us at (877) 629-5631