Oracle Application Express — A 3-Day Course

 Open Public Course Closed In-House Course

Synopsis

This course introduces the delegate to Oracle Application Express. It is designed to give delegates practical experience in using this tool for building user applications for the Web. By the end of the course delegates will be able to use the Oracle Application Express development environment for functional application development for the Web. They will gain practical experience in building and deploying applications for the Web, in using Application Express to manage database objects and in administering the Oracle Application Express environment.

Objectives

On completion of this course, delegates will be able to:

• Develop a Web Application
• Create Reports
• Create Forms
• Manage Pages and Regions
• Use and Manage Shared Components in an Application
• Add Page Processing Components
• Manage Database Objects
• Buildg Queries of Database Objects
• Deploy an Application as a Packaged Application
• Manage Users and Groups
• Authorise and Authenticating Users
• Administer APEX Workspaces
• Load and Unload Data or Application Components
• Deploy an Application

Suitable For

This course is intended for:

• Application Designers/Developers, Software Developers, Web Developers and Oracle Forms and Reports Developers who are required to develop interactive applications on the Web for end users.

Prerequisites

• A working knowledge of SQL and PL/SQL is required. This can be gained by attending the Oracle SQL and PL/SQL courses
• Some knowledge of HTML would be beneficial but is not essential

Publicly scheduled dates, locations, and prices

Outline Course Contents

Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Introduction of Oracle Application Express

• APEX Concepts
• APEX Main Components
• Create a Workspace
• Workspace Administrator
• Log into APEX
• Run an Application

SQL Workshop

• Browse, Create and Modify Objects
• Process Ad Hoc SQL Statements
• Manage Scripts
• Create, Run and Save SQL Queries

Build an Application

• Application Components
• Create an Application
• Create an Application from a Spreadsheet

Create Reports

• Create Reports Using Wizards
• Edit Report Attributes
• Add Links to Reports
• Save Reports in Different Formats
• Print Reports in Different Formats

Pages and Regions

• View Page Definitions
• Edit Page Definitions
• Create a New Region
• View Region Attributes
• Add Comments
• Add a Title
• Add a logo

Create Forms

• Create a Form on a Table with Report
• Create Forms of Different Types
• Add a List of Values to a Form

Items and Buttons

• Create Items
• Edit Item Attributes
• Create Buttons
• Edit Button Attributes

Page Processing

• Page Rendering and Page Processing
• Create Computations
• Validate Input Data
• Process Data
• Create Application Branching

Add Shared Navigation Components

• Shared Components Overview
• Parent and Standard Tabs
• Navigation Bars
• Lists
• Breadcrumbs

Other Shared Components

• Lists of Values
• Trees
• Shared Component Reports
• User Interface Defaults

Display Dynamic Content

• Filter Reports with Dynamic Queries
• Create Charts with a Wizard
• Create a Calendar

Session State and Debugging

• Implement Session State
• Set a Session State Value
• Clear the Session State
• Review the Session State
• Review the Messages in Debug Mode

Themes and Templates

• Switch to a Different Theme
• View Existing Templates
• Manage Templates
• Add a Reference to a Cascading Style Sheet

Administer APEX Workspaces

• Manage Users
• Request a Schema or Storage
• Purge Session State
• Monitor Developer Activity Log
• Monitor Workspace Activity
• View Activity reports

Administer APEX Workspaces

• Manage Users
• Request a Schema or Storage
• Purge Session State
• Monitor Developer Activity Log
• Monitor Workspace Activity
• View Activity reports

Implement Security

• Authentication and Authorization
• Provide an Authentication Scheme
• Create an Authorization Scheme Using Access Control
• Enable and Configure Session State Protection

Deploy an Application

• Define Supporting Objects
• Package an Application
• Export an Application
• Import an Application
• Install Supporting Objects

Utility Programs

• Import and Export Data
• Generate DDL Statements
• View Objects Reports
• Monitor the Database