Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Introduction To Application Express

Course Summary

The Introduction To Application Express training course is designed to demonstrate an introduction to Oracle Application Express (APEX) 5.0.

The course begins with an introduction into how to build a fully-functioning application from the ground-up.

Purpose
 Learn how to build an application using Oracle APEX 5.0, Oracle's premier Rapid Application Development tool.
Audience
 Software developers, database users, business analysts, application developers, database administrators, and IT managers.
Role
Business Analyst - Software Developer - Technical Manager
Skill Level
Intermediate
Style
Hack-a-thon - Learning Spikes - Workshops
Duration
5 Days
Related Technologies
Web Development

 

Productivity Objectives
  • Demonstrate how to create highly complex web-based applications
  • Create interactive reports that allow for full customization
  • Experiment with searching and sorting
  • Create control break reports
  • Perform highlighting to focus on specific rows or values
  • Add custom computations (including aggregations)
  • Apply charting and custom dashboards

What You'll Learn:

In the Introduction To Application Express training course, you'll learn:
  • 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 & 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 & 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
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.