Course Description
This Oracle online training course will describe the components of Oracles’ Application Express tool V3. Oracle Application Express covers the methods used within APEX to quickly and efficiently develop web based applications. This training covers how to install and configure APEX, build an application, create forms, reports, buttons, and templates, work with session states, page processing, navigation and utilities and handle security.
In This Course You Will Learn:
- Install APEX
- Configure APEX
- Develop APEX Applications
Prerequisites
You need to have six months of development experience or have taken the following GogoTraining courses:
Outline
Module 00: Oracle Application Express Online Training - Course Introduction
Module 01: Introduction to Application Express
- Application Express Concepts
- Application Express Architecture
- Create Workspace and Workspace Admin
Module 02: Using SQL Workshop
- Creating Objects
- Processing Ad Hoc SQL Statements
- Managing SQL Scripts
- Running Queries
- Lab: Using SQL Workshop
Module 03: Building a Application
- Components of an application
- Creating an application
- Creating an application from a spreadsheet
- Lab: Building an Application
Module 04: Creating Reports
- Report Types
- Interactive Reports
- Report Wizards
- Customizing Reports
- Lab: Creating Reports
Module 05: Creating Forms
- Form types
- Creating a form on a table
- Tabular forms
- Master detail form
- Form attributes
- Lab: Creating Forms
Module 06: Page and Regions
- Page definitions
- Editing Page attributes
- Region Attributes
- Comments
Module 07: Items and Buttons
- Creating Items
- Creating Buttons
Module 08: Session State and Debugging
- Implementing Session State
- Clearing Session State
- Reviewing Session State
Module 09: Page Processing
- Page rendering and Page processing
- Computations for the applications
- Validating input data
- Process data
Module 10: Shared Components
- List of Values for an applications
- Creating Trees
- Shared component reports
- User Defaults
Module 11: Dynamic Content
- Filtering reports
- Creating charts from a wizard
- Creating a calendar
Module 12: Themes
- Explaining Themes
- Switching Themes
- Custom Themes
- Lab: Working with Themes
Module 13: Templates
- Creating a template
- Modifying a template
- Cascading style sheet
Module 14: APEX Admin
- Managing Users
- Requesting Schema and storage
- Clearing Session State
- Lab: Using Admin APEX
Module 15: Implementing Security
- Authentication versus Authorization
- Authentication Scheme
- Access Control
- Session State Protection
Module 16: Deploying Applications
- Define supporting objects
- Exporting the application
- Importing the application
- Installing supporting objects
Module 17: Utilities
- Importing and exporting data
- Generate DDL
- View objects
- Monitor the database