Basic Developer course in Oracle Application Express

Training Provided by Mercury Innovations-ApexDevelop An excellent course for anyone who wants to develop, deploy and maintain web based applications. Oracle Application Express developer's course describes how to use the Oracle Application Express development environment to build and deploy database-centric Web applications. During the 3-day course, participants are provided access to there own private Workspace which can be accessed through the web browser and the workspace will be available during the course and up to one month after the course is completed. The participants would also have access to the source code and example applications. Oracle Application Express version is 3. 2 running on Oracle 10g database.

Basic Developer course in Oracle Application Express Course Contents
================
Introduction to Oracle Application Express
What is Oracle Application Express?
Oracle Application Express Architecture
Understanding Oracle Application Express Roles
Logging into Oracle Application Express
Demonstration Application
Creating and logging onto workspace
Installing demonstration application
Running demonstration application
Application Builder Concepts
Page processing and Rendering
Session Management
Substitution strings & URL syntax
Using SQL Workshop
Using Object Browser to view, create, edit, drop database objects
Using SQL Commands to interact with database
Using SQL Scripts to create, edit, delete and run SQL & PL/ SQL scripts
Using Query Builder to build queries graphically
Building an Application
Creating an application from wizard
Creating an application From Scratch
Creating an application From Spreadsheet
Understanding Pages and Regions
What is a Page in APEX
Controls on a Page
Different Sections of a Page
Page Rendering
Page Processing
Shared Components
Attributes of a Page
What is a Region
Different Attributes of a Region
Creating Interactive Reports
Creating Interactive Reports
Interactive Report Attributes
Interactive Report Column Attributes
Creating SQL Reports
Creating SQL Reports
SQL Report Attributes
SQL Report Column Attributes
Creating Forms
Creating Forms with Report
Creating Simple Forms
Creating Tabular Forms
Creating Master-Detail Forms
Creating Forms Using Wizards and Manually
Understanding Page Rendering & Page Processing Components Required for Form
Working with Items & Buttons
Creating Different Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
Creating Buttons
Understanding Buttons
Navigation
Creating Tabs, Lists, Breadcrumbs, Navigation Bar, List of Values
Shared Components
Understanding Different Attributes of Shared Components
Using Shared Components in Pages
Page Processing
Having a Thorough Understanding of Following Sections of Page Rendering & Processing
Computations
Validations
Processes
Branches
Themes & Templates
Understanding Themes
Switching Themes
Changing Theme Defaults
Understanding Templates and viewing template definitions
Security
Managing Application Security
Understanding Different Authentication Options in APEX
Creating a Custom Authentication
Switching from One Authentication Method to Another
Understanding Authorization in APEX
Creating Authorization Schemes
Attaching Authorization Schemes to Pages, Regions, Tabs etc.
Packaging & Deploying Application
Understanding Different Deployment Options
Understanding the Packaging & Deployment Process
Packaging Application with Supporting Objects
Deploying Application from One Environment to Another

About The Training Provider: Mercury Innovations-ApexDevelop