	Training/Mentoring

	E-Business Suite
	Business Intelligence
	Custom Development
	Database Services
	Managed Services
	Training/Mentoring
		The Service
		The Value
		References
		Contact Us / Registration
		Oracle Certification Prep
		Pricing
		Course Schedule
		Directions, Travel & Accommodations
		Register Online
	Oracle Licensing

Oracle Application Express (formerly called HTML DB)

Click here to contact us

Course Overview

Oracle Application Express (APEX) provides students with a solid understanding of Oracle's latest rapid application development environment. The presentation style is a series of concise lessons, with each lesson preparing students to apply the knowledge gained in a challenging exercise based on a real-world situation. Topics begin with an overview of the Oracle APEX development environment, its genesis, capabilities and applications. Instruction continues with an overview of each of the environments major areas; Application Builder, SQL Workshop and Administration. The course will then continue with an in depth exploration of the development environment including data importing, application wizards, element wizards, session management, page rendering and processing, application shared components, application elements, computations, validations processes and branching. All of these will be brought together through a series of exercises that result in a working application.

Course Goals

To build an understanding of the Oracle APEX development environment and its capabilities
To provide students with the skills necessary to take full advantage of the Oracle APEX rapid application develop environment to produce real world applications.
To obtain hands-on experience through exercises in an instructor-led environment, promoting interactive learning

Prerequisites

This course assumes a good working knowledge of PL/SQL
A very basic understanding of Hyper Text Markup Language (HTML) is useful

Who Should Attend?

Any one wishing to gain an understanding of the capabilities of the Oracle APEX rapid application development environment.
Application developers who want be able to start developing real world application quickly utilizing Oracles latest technology.

Course Materials

Oracle APEX Course Notes
Oracle APEX Handbook
Oracle APEX Sample Applications

Duration

Three days

Tuition

$1,395

Course Outline

Introductions
Overview of Oracle APEX development environment
Working with the SQL Workshops
Creating your first application with the Application wizard
How the page rendering and processing works
How Oracle APEX handles the session
Building Web pages
- Creating Reports
- Creating Forms
Understanding Application Shared Components
Themes and Templates
Understanding Navigation
Regions; what are they and how do you use them
Manually creating buttons and items
Working with Substitution variables
Using Validations and Computations
Processes
- A look at generated processes
- Creating processes manually
Working with Graphs and Charts
Controlling Application security
Oracle APEX Administration
The use of JavaScript in Oracle APEX
Oracle APEX built in functions and the PL/SQL Web Toolkit