Oracle Application Express Workshop I

Course DateLocationDaysPriceRegister
Oct 2, 2017Montreal5 $4,825Register
Sep 25, 2017Ottawa5 $4,825Register
Aug 21, 2017Quebec5 $4,825Register
Nov 6, 2017Quebec5 $4,825Register
Sep 25, 2017Toronto5 $4,825Register
Nov 27, 2017Toronto5 $4,825Register
Jan 29, 2018Toronto5 $4,825Register
Mar 19, 2018Toronto5 $4,825Register
May 28, 2018Toronto5 $4,825Register


Course DateLocationDaysPriceRegister
Aug 28, 2017Live Virtual - 10:00 am Eastern5 $4,600Register
Sep 18, 2017Live Virtual - 11:00 am Eastern5 $4,600Register
Oct 30, 2017Live Virtual - 9:00 am Eastern5 $4,600Register
Sep 17, 2017Live Virtual - 9:30 pm Eastern5 $4,600Register


Course DateLocationDaysPriceRegister
Self-Paced Learning5 $4,250Register


Oracle Application Express Workshop I

Description: 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.

Duration: 5 Days

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.

Audience:

  • Application Developers
  • Project Manager
  • Database Administrators
  • Web Administrator
  • System Analysts
  • Business Intelligence Developer
  • Forms Developer

Course Objectives:

  • 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

Required Prerequisites:

  • Basic knowledge of SQL, PL/SQL, and HTML

Topics: 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

Course DateLocationDaysPriceRegister
Oct 2, 2017Montreal5 $4,825Register
Sep 25, 2017Ottawa5 $4,825Register
Aug 21, 2017Quebec5 $4,825Register
Nov 6, 2017Quebec5 $4,825Register
Sep 25, 2017Toronto5 $4,825Register
Nov 27, 2017Toronto5 $4,825Register
Jan 29, 2018Toronto5 $4,825Register
Mar 19, 2018Toronto5 $4,825Register
May 28, 2018Toronto5 $4,825Register


Course DateLocationDaysPriceRegister
Aug 28, 2017Live Virtual - 10:00 am Eastern5 $4,600Register
Sep 18, 2017Live Virtual - 11:00 am Eastern5 $4,600Register
Oct 30, 2017Live Virtual - 9:00 am Eastern5 $4,600Register
Sep 17, 2017Live Virtual - 9:30 pm Eastern5 $4,600Register


Course DateLocationDaysPriceRegister
Self-Paced Learning5 $4,250Register