Oracle Application Express 3.0: Developing Web Applications

Oracle University



Oracle Application Express 3.0: Developing Web Applications



4 Days


What you will learn

This course is designed to introduce the students to Oracle Application Express 3.0. The course covers various

Application Express components and wizards to build applications and database objects that are easy to deploy. The

students learn how to build forms and reports and incorporate different types of items and shared components. Creating

and utilizing various navigation components as well as session management and debugging are discussed. In addition,

students incorporate access control, and session protection to enforce application security. Once the application is

complete, students learn how to define their packaged application and export the application. Students will also use all

the Utilities and Report capabilities that Oracle Application Express provides to build a robust application.

Learn to:

Develop a database-centric Web application using the Application Builder

Manage Authentication, Authorization and Session State within your Application

Utilize and Manage Shared Components

Administer Application Express Workspaces

Manage Database Objects Using SQL Workshop

Deploy Your Application


Application Developers


Forms Developer

PL/SQL Developer

Reports Developer


Suggested Prerequisites

Basic knowledge of SQL, PL/SQL, and HTML

Course Objectives

Login to Oracle Application Express

Develop a database-centric Web application

Utilize and Manage Shared Components in an Application

Add Page Processing components

Manage database objects

Build queries of database objects and incorporate in an application

Deploy the Application as a Packaged Application

Manage users and groups

Manage Access Control by authorizing and authenticating users

Administer Oracle Application Express Workspaces

Load and Unload data or application components

Copyright © 2009, Oracle. All rights reserved. Page 1

Course Topics

Introducing Oracle Application Express

Explaining the General Concepts

Identifying the Main Components

Creating a Workspace and Workspace Administrator

Logging In to Oracle Application Express

Installing and Running a Sample Application

Installing a Packaged Application

Interacting with the Database by Using SQL Workshop

Browsing, Creating and Modifying Objects

Processing Ad Hoc SQL Statements

Managing Scripts

Creating, Running and Saving SQL Queries

Building an Application

Identifying the Components of an Application

Creating an Application from Scratch

Creating an Application from a Spreadsheet

Creating Reports

Generating Reports Using Wizards

Editing Report Attributes

Adding Links in Reports

Saving or Printing Reports in Different Formats

Creating Forms

Creating a Form on a Table With a Report

Creating a Tabular Form

Creating a Master-Detail Form

Editing Form Attributes

Working with Pages and Regions

Viewing Page Definitions

Editing Page Attributes

Creating a New Region

Viewing Region Attributes

Adding Comments

Adding Items and Buttons

Creating Items

Editing Item Attributes

Creating Buttons

Editing Button Attributes

Understanding Session State and Debugging

Implementing Session State

Setting a Session State Value

Clearing the Session State

Reviewing the Session State

Reviewing the Messages in Debug Mode

Including Page Processing

Explaining the Difference Between Page Rendering and Page Processing

Creating Computations

Validating Input Data

Process Data

Creating Application Branching

Adding Shared Components That Aid Navigation

Providing an Overview of Shared Components

Managing Parent and Standard Tabs

Managing Navigation Bars

Managing Lists

Managing Breadcrumbs

Adding Other Shared Components

Managing List of Values

Managing Trees

Accessing Shared Component Reports

Setting User Interface Defaults

Displaying Dynamic Content

Filtering Reports Using Dynamic Queries

Creating Charts Using a Wizard

Creating a Calendar

Working with Themes and Templates

Switching to a Different Theme

Viewing Existing Templates

Managing Templates

Adding a Logo

Referencing a Cascading Style Sheet

Changing a Field to Use a Class in the Referencing Stylesheet

Administering Oracle Application Express Workspaces

Managing Users

Requesting a Schema or Storage

Purging Session State

Monitoring Developer Activity Log

Monitoring Workspace Activity

Viewing Activity Reports

Implementing Security

Differentiating Between Authentication and Authorization

Providing an Authentication Scheme

Creating an Authorization Scheme Using Access Control

Enabling and Configuring Session State Protection

Deploying Your Application

Defining Supporting Objects

Exporting Your Application

Importing Your Application

Installing Supporting Objects

Using Utilities

Importing and Exporting Data

Generating Data Definition Language (DDL) Statements

Viewing Object Reports

Monitoring the Database




pearson vueISO 9001