Application Express Workshop I

Course Fees: $5365.00 excl. GST
Printed Manual: $150.00 excl. GST
Course Duration: 5 days
Course Manual


10 Feb - 14 Feb


16 Mar - 20 Mar
In the Oracle Application Express Workshop I, discover how to develop database-centric web applications quickly using Oracle Application Express. Learn from expert Oracle University instructors through interactive learning, which includes hands-on exercises.

Learn To:
  • Create a database application for both desktop and mobile interfaces.
  • Add various components like new pages, reports regions, items and other components required to enhance an application.
  • Create processes and validations within an application.
  • Create shared components for an application.
  • Implement security in an application.
  • Manage application navigation in an application.
  • Extend application by adding more components using some built-in wizards.

Benefits To You:

  • By investing in this course, you'll discover how Oracle Application Express allows you to create database applications using desktop and mobile interfaces. You'll also learn how to enhance your application by adding various components like reports, forms, items, dynamic actions, calendars, charts, plug-ins and other shared components required in an application.
  • Application Developers
  • Business Intelligence Developer
  • Database Administrators
  • Forms Developer
  • Project Manager
  • System Analysts
  • Web Administrator
Basic knowledge of SQL, PL/SQL, and HTML
Application Express Wkshp 2; Application Express Administration
  • Log in to an Oracle Application Express Workspace
  • Create and Run Database Applications using desktop and mobile interfaces
  • Create Reports and Forms in an application
  • Create Pages and Regions in an Application
  • Create Page and Application Items and Buttons
  • Create Page Processes and Validations
  • Implement Security
  • Manage Application Navigation
  • Extend an Application
  • Create Themes and Templates
  • Create Shared Components such as Tabs, Lists, and Breadcrumbs
  • Add Dynamic Actions
  • Import and Use Plug-Ins
  • Create and Use Calendars and Trees
  • Utilize Application Express Printing methods
  • Manage Application feedback
Course Overview
  • Course Objectives
  • Lesson Schedule
  • Order Management Database Application
  • Course Environment : Products Installed
  • Course Environment: Workspace Details
  • Accessing the Labs Directory
Introducing Oracle Application Express
  • Application Express Overview
  • Application Express Terms and Concepts
  • Using Application Express
Creating a Database Application
  • Application Builder Overview
  • Introducing Database Applications
  • Creating Database Applications
Using and Creating Interactive Reports
  • Introducing Reports
  • Using Interactive Reports
  • Creating and Customizing an Interactive Report
Creating Classic, Wizard and Mobile Reports
  • Creating Classic Reports
  • Creating Wizard Reports
  • Creating Reports for a Mobile Application
Creating Forms
  • Using Forms
  • Creating Forms
  • Modifying Forms
  • Creating a Form in a Mobile Application
Working with Pages and Regions
  • Introducing Page Definition
  • Working with Page Regions
  • Working with Pages
Adding Items and Buttons
  • Introducing Items
  • Using Items
  • Creating List of Value (LOV) Type of Items
  • Using Buttons
Understanding Session State
  • Understanding Session State in Oracle Application Express
  • Using Session State in Oracle Application Express
Including Page Processing
  • Introducing Page Processing
  • Including Computations
  • Including Processes
  • Including Validations
  • Including Branches
Validating and Debugging Your Application
  • Using the Advisor
  • Managing Your Attribute Dictionary
  • Debugging Your Application
Adding Shared Components That Aid Navigation
  • Introducing Shared Components
  • Creating Tabs
  • Creating Lists
  • Creating Breadcrumbs
  • Creating a Navigational Bar
Working with Themes, Templates and Files
  • Using Themes
  • Using Templates
  • Using Files
Implementing Security
  • Securing an Application
  • Using Authentication Schemes
  • Using Authorization Schemes
  • Using Session State Protection
Managing Application Navigation
  • Building a Hierarchical List with Images
  • Building a Database-Driven Navigation Report
  • Building a Site Map
  • Enforcing Authorization on Your Site Map
  • Linking Interactive Reports using a Declarative Filter
Extending Your Application
  • Creating Data Load Wizard Pages
  • Creating an Upload and Download Page
  • Adding BLOB Data to an Existing Application
  • Sending Email from an Application
Creating and Editing Charts
  • Creating and Using Charts
  • Enhanced Charting Example
Adding Calendars and Trees
  • Using Calendars
  • Using Trees
Using Dynamic Actions and Plug-Ins
  • Using Dynamic Actions
  • Using Plug-Ins
Utilizing Application Express Printing
  • Printing a Standard Report with Derived Output
  • Creating a PDF Report with Multiple Queries
Managing Application Feedback
  • What is Team Development?
  • Managing Feedback