Oracle APEX Training: Introduction to Oracle Application Express 4.1

Course Number: ORC-900
Duration: 4 days
view class outline

Oracle APEX Training Overview

In Accelebrate's Oracle APEX Training: Introduction to Oracle Application Express 4.1 training, students learn how to develop web applications from scratch, as well as how to manage database structures and actual data within an Oracle database.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=course&page=SQL104.

Oracle APEX Training Prerequisites

All students should have an understanding of Oracle SQL and PL/SQL.

Hands-on/Lecture Ratio

This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 25 minutes.

Oracle APEX Training Materials

All students receive comprehensive courseware and a related textbook.

Software Needed on Each Student PC

Core 2 Duo processor or faster
Windows XP, Vista, 7, 8, or later with the latest service packs and at least 3GB RAM
JRE or JDK 6.0 or later
Oracle database (Express Edition 10g, 11g, or later is fine for purposes of class) with APEX 4.1 or later installed

Oracle APEX Training Objectives

All attendees will learn to:

Understand the Oracle APEX architecture
Use SQL Workshop to interface with and manipulate your data
Build database-centric Web applications using Application Builder
Create web-based forms and reports
Secure your web applications
Deploy your web applications
Build a Websheet application
Explore the new features in the latest release of Oracle APEX

Oracle APEX Training Outline

Introduction to Oracle Application Express

What is Oracle APEX?
Benefits
Architecture and Installation
Capabilities
Typical APEX Applications
Major Components
APEX Resources

From the Developer's Perspective

Workspace Concepts
Workspace Login
APEX Components
Application Builder Overview
Demonstration Applications
SQL Workshop Overview

Application Design Requirements

Identify system requirements
APEX specific design issues
From ERD to Tables

Using SQL Workshop

Accessing SQL Workshop
Using Object Browser
Executing SQL Commands
Working with SQL Scripts
Using Query Builder
Accessing Utilities submenu
Using Data Workshop
Generating DDL
Establishing User Interface Defaults
Managing the Recycle Bin
Using Schema Comparison
Using About Database

Application Builder Basics

Understand the Basics of Application Builder
Application Builder Terms
Methods of Creating an Application
Editing Application Properties

Basic Forms and Reports

Creating a Form
Creating a Report
Understanding Session State
Declarative BLOBs

Advanced Forms and Reports

Pages
Developer Toolbar
Tabular Forms
Interactive Reports
Calendar Reports
Chart Reports

Page Controls

Items
Buttons
Validations
Computations
Processes
Branching
Dynamic Actions

Security

Overview of Security
Authentication
Creating a Authentication Scheme
Authorization
Creating an Authorization Scheme
Access Control
Session State Protection

Application Deployment

APEX Application Lifecycle
Deploying Application
Exporting Application
Importing Application
Cross Application Report

Additional Developer Tools

Application and Page Management
APEX Views and APEX Dictionary
Searching in APEX
Monitoring APEX
APEX Advisor
Build Options
SQL Developer and APEX
PL/SQL Refactoring and DML Packages

APEX Plug-ins

Types of APEX Plug-ins
Using Plug-ins to enhance the user experience
4.1 extensions with authorization and authentication

APEX 4.1 New Features

End User data uploads
Improvements in Error Handling
Tabular Form Improvements
Mobile App Templates
Calendar Improvements
Client-side Dynamic Action Support

Websheets

Websheet Page Structure
Navigation
Help
Markup Syntax
User Authentication
User Authorization
Sections
Administration
4.1 New Features

Websheet Example

APEX Workspace Administration

Environmental Information
Manage Service
Managing Users and Groups
APEX Instance Administrator

Team Development

Team Development Overview
Team Development Interface
Features
Milestones
To Do Items
Bugs
Feedback
News

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.