Oracle Application Express

Prerequisites:

A working knowledge of SQL and PL/SQL is required. Some knowledge of HTML would be beneficial but is not essential.

Course Description:

This course introduces the delegate to Oracle's Application Express software.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.

Apex version 4 includes all the features of Apex version 3.This course covers all the features of Apex version 3 and the new features introduced in version 4.The course is suitable for both Oracle Application Express version 4 and Oracle Application Express version 3 users.The course will be delivered using Apex version 4 software.

The delegate will practice:

• Developing a Web Application
• Creating Reports
• Creating Forms
• Managing Pages and Regions
• Using and Managing Shared Components in an Application
• Adding Page Processing Components
• Managing Database Objects
• Building Queries of Database Objects
• Deploying an Application as a Packaged Application
• Managing Users and Groups
• Authorising and Authenticating Users
• Administering APEX Workspaces
• Loading and Unloading Data or Application Components
• Deploying an Application

This course includes the following modules:

Introduction to 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

Dynamic Actions and Plug-In Components

• Understand Dynamic Actions
• Understand Plug-in Components
• Plug In a Component
• Create a Dynamic Action
• Use a Plug-in in a Dynamic Action

State and Debugging

• Understand 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
• Create a new Template
• Template subscription
• Add a Reference to a Cascading Style Sheet
• Add a reference to a Javascript file

Build a Websheet Application

• Websheet Components
• Create a Websheet Application
• Run a Websheet
• Add a Section to a Websheet
• Add a Page to a Websheet

Websheet Data Grids and Links

• Add a Data Grid to a Websheet using Copy & Paste
• Add a Data Grid from Scratch
• Link a Data Grid to a Websheet Page
• Link a File to a Websheet Page

Administer Apex Workspaces

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

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