Audience
Developers and database personnel requiring the skills to use Oracle's Application Express product. The class is delivered at version 4.x
Prerequisites
Familarity with Oracle and basic programming experience is assumed.
Course Objectives
Oracle Application Express is a Web-based application development tool, integrated within Oracle 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 participants 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
Duration
3 days. Hands on.
Course Content
Introdution to APEX
Run-time Architecture
Components of the development environment
SQL workshop
Obect 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