Overview

This course is for developers who wish to gain a practical understanding of how to use Oracle Application Express (APEX).

Prerequisites

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

Outline

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