Oracle Application Express (APEX) Training

Delegates should have some experience with SQL and PL/SQL.

Introducing Application Express

• What is Application Express(APEX)
• Benefits of APEX
• History of APEX
• Architecture Overview - logical and physical
• APEX Repository Overview
• Out of the box development features
• SQL Developer and APEX

Getting Started with Application Express

• What is a Workspace?
• Different types of APEX users
• How to access APEX
• Application Express Components
• What is an Application?
• What is a Packaged Application?

Working with the SQL Workshop

• What is SQL Workshop?
• Browsing, creating and modifying objects
• Processing ad hoc SQL and PL/SQL statements
• Managing scripts
• Using the Utilities

Creating a Database Application

• Types of Application
• Components of an application
• Application Builder Home Page
• An Application's Home Page
• Creating an application
• Creating an application from a file

Creating Forms

• List the different types of application forms that you can create in Application Express
• Creating single entry Forms
• Creating Editable Interactive Grids
• Creating Master-Detail Forms
• Modifying a Form

Creating Reports

• List the type of reports that you can create in Application Express
• Describe the different ways of creating reports in Application Express
• Create an interactive report
• Create an interactive grid
• Create a classic report
• Create a report with form
• Create a faceted search page
• Linking a Form and a Report
• Modifying a Report

Understanding Pages and Regions

• What is a Page in APEX?
• Different Sections of a Page
• Page Rendering
• Page Processing
• Shared Components
• Page Attributes
• What is a Region?
• Lists, Breadcrumbs and Calendar Regions
• Positioning Regions

Working with Items and Buttons

• Types of page level Items (Text, Text Area, Checkbox, Select List, Radio Group etc.)
• Create and use page-level items
• Create and use buttons
• Creating a Report Filter

Adding Computations, Processes, and Validations

• Explain page rendering and page processing
• Create computations
• Create page processes
• Create validations
• Create branches

Understanding Session State

• Understanding Sessions
• Session IDs and APEX URLs
• What is Session State?
• Viewing Session State
• Referencing Session State in your Application
• In-built Substitution Variables

Working with Shared Components

• What is a Shared Component?
• Types of Shared Components
• What are List of Values (LOVs)?
• Creating Cascading LOVs
• Uploading and Referencing Images
• Application Items, Computations and Processing
• Editing the Navigation Menu

Using Themes and Theme Styles

• Describe themes and templates
• Explain the key features of Universal Theme
• Create and use a new theme
• Describe Universal Theme, Theme Styles, Theme Roller, and Template Options
• Use Theme Styles
• Use Theme Roller, and Live Template Options
• Upload and use a CSS

Oracle APEX Workspace Administration

• Workspace Administration Topics
• Manage Services
• Manage Users and Groups
• Monitor Activity
• Dashboards
• Workspace Utilization

APEX Security Features

• Explain how to secure your application
• Describe authentication and authorization
• Create and use an authentication scheme for your application
• Create and attach an authorization scheme to your application, page, or components

Introduction to Dynamic Actions

• What are Dynamic Actions?
• Create and use dynamic actions

Creating and Using Plug-ins

• Describe Plug-ins
• Implement Plug-ins in your application

Displaying other Content

• Oracle JET Charts
• Calendars
• Trees

Data Loading

• Create a data upload form for users
• Transform the data upon upload
• Validate and reject rows

Migrating an Application between Environments

• Describe the steps involved in migrating an application between environments
• Export the application definition, underlying database objects, and data from your development environment
• Import the application definition, underlying database objects, and data in the target development environment