Oracle Application Express 3.0: Developing Web Applications

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
Audience
 Application Developers
Developer
Forms Developer
PL/SQL Developer
Reports Developer

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

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