Choose your language:

Hong Kong
New Zealand
United Kingdom
United States

Oracle Application Express Introduction v3.1

Course Code



4 Days

This course provides an introduction to Application Express, Oracle�s lightweight database-centric web development tool that can be used to easily create small, simple web applications. It is ideally suited for the developer coming from the Oracle Forms/Reports world that wants to learn to develop a web application from scratch. It is equally useful for data managers that would like to move their data (and applications) from a single user environment such as a spreadsheet or Microsoft Access application to database repository. It provides great functionality for managing the database structures and actual data within an Oracle database.
This course is designed for individuals who are PL/SQL Developers, Web Developers, and Database Administrators.
Upon completion of this course, participants will be able to:
� Discuss the Oracle APEX architecture
� Manage database objects using SQL Workshop
� Load/unload data, run reports using Utilities
� Build a database-centric Web application using Application Builder
� Administer an APPLICATION EXPRESS Workspace
Introduction to Oracle APPLICATION EXPRESS version 3.1
What is Oracle Application Express (APEX)?
Software requirements
Architecture and installation
Typical APEX applications
Major components
Oracle Resources

Workspace Concepts
Workspace Login
APPEX Components
Application Builder Overview
SQL Workshop Overview
Utilities Overview
Demonstration Applications

Using SQL Workshop
Accessing SQL Workshop
Using Object Browser
Executing SQL commands
Working with SQL Scripts
Using Query Builder

Using Utilities
Accessing Utilities
Using Data Load and Unload
Generating DDL
Running Object Reports
Using the Recycle Bin
Running APEX Views Reports
Using Schema Comparison
Understand data available from Database Monitor and About Database

Application Builder Basics
Understand the Basics of Application Builder
Application Builder Terms
Methods of Creating an Application
Creating an Application from Scratch demo

Forms and Reports
Creating a Form Using a Wizard
Creating Reports Using Wizards
Editing Report Attributes
Interactive Reports
Creating a Parameterized Report
Creating a Drill Down Report

Working with Pages, Regions and Templates
Page Overview
Editing Page Attributes
Developer Toolbar
Creating a Region
Region Types
Editing Region Attributes
Overview of Templates
Editing a Page Template

Modifying the Application User Interface
Adding Items and Buttons
Calendars and Charts
Working with Check Boxes

Page Processing
Explain the difference between page rendering and page processing
Create computations
Validate user input
Process data
Create branching within an application

PDF Printing in APEX
Understand software requirements for PDF printing
Install BI Publisher to enable PDF printing
Configure APEX to work with BI Publisher
Create PDF reports
Use BI Publisher Desktop to configure a report

Apex and Web Services
Understand what a Web Service is
Get a basic understanding of SOAP, WSDL, and UDDI
Create a web service reference from WSDL

Shared Components and Development Practices
Parent and Standard Tabs
Navigation Bars
Breadcrumb Menus
List of Values
Application Design Best Practices
Packaging Applications

Session State
What is a Session State?
APEX Session State Implementation
Viewing Session State
Getting Session State Values
Setting a Session State Value
Clearing Session State and Cache Values

Security Implementation and Deployment
Overview of Security
Creating a Authentication Scheme
Creating an Authentication Scheme
Deploying an Application

APEX Workspace Administration
Locking and Unlocking Pages
User Roles
Requesting a New Workspace
Managing APEX Users
Monitoring Workspace Utilization
Managing Log Reports
Administering Session State
Provisioning Services
Send Us a Message
Choose one