Audience
This course is aimed at developers and database personnel who require the skills to use Oracle's Application Express product.
NOTE:This course can be tailored to any release version - please confirm your release when booking.
Prerequisites
Familiarity with Oracle and basic programming experience are assumed.
Duration
3 days. Hands on.
This course is available on site only. Please call for details.
Course Objectives
Oracle Application Express is a Web-based application development tool, integrated within Oracle from v 10g onwards. It enables anyone with limited programming experience and a Web browser to rapidly develop scalable Web applications that can be quickly deployed to tens, hundreds or thousands of users.
Upon completion of this course delegates will be able to
- Describe the major components of an APEX application
- Build Reports and Forms using data from an Oracle database
- Apply authentication and authorization policies to an APEX application
- Export and import applications
- Manage workspaces and users
Course Content
Introduction to APEX
Run-time Architecture
Components of the development environment
SQL Workshop
Object browser
SQL commands
Script repository
Query Builder
Utilities to import and export data
Building Forms
Using the create form wizard
Form Types
Editing the page
Building Reports
Using the create Report Wizard
Classic reports
Interactive reports
Pages and Regions
Overview of page and region types
Creating Calendars
HTML regions
Region layout
Items and Buttons
Item types
Using lovs
Quick Picks
Creating buttons
Page Processing
Page Rendering – computations and processes
Page Processing – computations, validations, processes and branches
Creating default DML processes
Dynamic actions – standard and advanced
Incorporating plug-ins
Session State
Understating session state
Clearing session state
Understanding the APEX URL syntax
Shared Components
LOVs including cascading LOVs
Incorporating images and files
Application level items and computations
Lists
Breadcrumbs
Tabs
Themes and Templates
Copying themes and templates
Editing templates
Security
Authentication
Authorisation
Session State protection
Deployment
Creating supporting objects
Export and Import
Websheets
Overview of creating a websheet application