\ SAGE Computing Services
Application Express Workshop Version 3.1
Dates: 29th – 31st October.
Location: Perth, Western Australia
The course is designed to provide the student with the skills and knowledge required to develop a complete application using Oracle’s Application Express product. The student will develop web interfaces including forms, reports and charts, add validation and customise the formatting to create a small application.
No experience is required.
Basic PL/SQL , HTML and JavaScript skills are an advantage but are not essential.
Enrolment
In order to enrol please complete and return this enrolment form to PO box 220, Hillarys, Perth 6025 or fax it to (08) 9243 4335. If you have any queries whatsoever please contact Penny Cookson on 0419 904 458 or at
Attendee...... Job / Role......
Email ......
Attendee...... Job / Role......
Email ......
Attendee...... Job / Role......
Email ......
Company Name......
Address......
Signed...... Name ......
Position......
Telephone Number...... Email ......
Address......
Telephone...... PO Number.....……......
Cost per attendee $2,250 (Ex GST)
Course Contents
Product OverviewTarget audience
Product Features
Development Approach
Product architecture
Concepts – Workspaces and Applications
The Development Environment
Navigating in the Product
Help
Running an Application
SQL Workshop
The Object Browser
Creating and Browsing Database Objects
Query Builder
Executing SQL commands
Creating, Running and Saving Scripts
Creating Database Objects
Defining User Interface Defaults
Building an Application
Creating an Application Based on a Spreadsheet
The Create Application Wizard
Setting Developer Preferences
Reviewing and Editing Application Objects
The Developer Toolbar
Managing Page Locks
The Application Definition
Pages
Creating a Page
Creating a SQL Report
The Page Definition
Page Rendering and Processing Overview
Create a Form and Associated Report
Creating a Page Group
Assigning Pages to Groups
Page Attributes
Alternative Page Views
Forms and Reports
Creating an Interactive Report
Manipulating Interactive Reports
Report Controls
Linking to a Single Record
Column Groups
Form Wizard
Editing the Page
Creating a Form and Associated Report
Regions
Region Types
Creating a Region
The Region Definition
The Region Wizards
Editing a Region
Conditionally Displaying Regions
Customising Queries
Report Attributes
Downloading the Report to a CSV File
Printing a Report
Report Queries and Layouts
Items
Creating Items
The Item Source
Modifying an Item
Item Display Types
Creating Buttons
Button Functionality
Submitting and Branching
On Load Computations
Shared Components
Application Items
Application Computations
Application Processes
Lists
Breadcrumbs
Lists of Values
Trees
Tabs
Navigation Bars
Processes
Items
Shortcuts
Webservices
Page Processing
Computations
Adding Validation
Processes
Automatic Row Processing
Conditional Processing
Branching
Calling a Page – URL syntax
Using Substitution Strings
Session State
Getting Session State
Setting Session State
Viewing a Page in Debug Mode
Viewing Page Events
Themes and Templates
Themes
The Theme Repository
Managing templates
Page Templates
Region Templates
Other Templates
Subscribing to a Template
Cascading Style Sheets
Other Page and Region Types
Creating Charts
Creating Calendars
Creating Trees
Creating a Wizard
Application Utilities and Reporting
Translations
Managing CSS, JavaScript and Image Files
Exporting and Importing Pages and Components
Object Reports
Deleting and Copying an Application
Advanced Development Techniques
Creating an Application – Standards
Creating a Template Application
Authentication
Authorisation
Access Control Wizard
Cross Site Scripting
Session State Protection
Using Page 0
Using JavaScript
Using AJAX
Advanced Techniques for Interactive Reports
The Application Express API
Recommendations
Application Builds
Administration and Utilities
Application Packaging
Managing Application Express
Provisioning Workspaces
Managing Workspaces
User Administration
Purging Logs
Purging Session State
Manage Application Models
Workspace Preferences
Importing and Exporting Data
The Database Monitor
Generating DDL
Schema Comparison