Oracle Application Express 3.0: Developing Web Applications

Course Overview

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 utilising 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, Authorisation and Session State within your Application
• Utilise 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

Skills Gained

Delegates will learn to:

• Login to Oracle Application Express
• Develop a database-centric Web application
• Utilise 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 Outline

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 Authorisation 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

Oracle Application Express 3.0: Developing Web Applications / D49183GC20