By using our website you agree to our use of cookies.

Oracle Application Express 5

4 Day Course
Hands On
Code OAE5

Book Now - 1 Delivery Method Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

Overview

This Oracle Application Express 5 (APEX) course introduces the delegate to Oracle's Application Express version 5.1 software. It is designed to give delegates practical experience in using Application Express version 5, also known as Apex, for building web-based applications for an Oracle database and websheets for managing structured and unstructured data.

New to Apex version 5.1 is the Interactive Grid feature. Interactive Grid allows the rapid editing of multiple rows of data in a dynamic grid and combines the best features of Interactive Reports and Tabular Forms. There are also enhancements to the Universal Theme, Page Designer, Calendars, Charts, the Create Application and Page Wizards and uploading files.

Objectives

The delegate will learn and acquire skills as follows:

  • Using the Apex SQL Workshop
  • Developing an Apex Web Application
  • Creating Reports
  • Creating Interactive Grids
  • Creating Forms
  • Using Page Designer to manage Web Pages and Regions in the Apex Application
  • Using and Managing Shared Components in an Application
  • Using Cascading Stylesheets and Javascript in Apex Applications
  • Adding graphs and charts to an Apex Application
  • Adding Page Processes to the Apex Application
  • Adding Dynamic Actions to the Apex Application
  • Managing Database Objects from within Apex
  • Building Queries of Database Objects
  • Deploying an Apex Application as a Packaged Application
  • Managing Apex Users and Groups
  • Authorising and Authenticating Apex Users
  • Loading and Unloading Data or Application Components
  • Deploying an Apex Application
  • Developing an Apex Websheet
  • Creating Data Grids and Links in an Apex Websheet
View detailed Course Modules

Target Audience

The Oracle Application Express 5 (APEX) course is aimed at Application developers, software developers, Web developers, Oracle Forms and Reports developers and technical support professionals who wish to develop interactive applications on the Web for end users.

Additional Information

  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Collapse all

Introduction to Oracle Application Express (6 topics)

  • APEX Concepts
  • APEX Main Components
  • Create a Workspace
  • Workspace Administrator
  • Log into APEX
  • Run an Application

Pages and Regions (8 topics)

  • View Page Attributes in Page Designer
  • Edit Page Attributes in Page Designer
  • Create a Global Page
  • Create a New Region
  • View Region Attributes
  • Add Comments
  • Add a Title
  • Add a logo

Shared Components (6 topics)

  • Overview of Application Express Navigation Components
  • Manage the Navigation Menu
  • Create Navigation Bar Entries
  • Manage Breadcrumbs
  • Create and Use Lists and List Items
  • Creating and using Shortcuts

SQL Workshop (4 topics)

  • Browse, Create and Modify Objects
  • Process Ad Hoc SQL Statements
  • Manage Scripts
  • Create, Run and Save SQL Queries

Build an Application (3 topics)

  • Application Components
  • Create an Application
  • Create an Application from a Spreadsheet

Create Reports (5 topics)

  • Create Reports Using Wizards
  • Edit Report Attributes
  • Add Links to Reports
  • Save Reports in Different Formats
  • Print Reports in Different Formats

Using Files (5 topics)

  • Uploading Images
  • Creating Cascading Stylesheet Files
  • Uploading Static Files
  • Adding an Image as an Application Logo
  • Adding a Reference to a Javascript File

Create Forms (3 topics)

  • Create a Form on a Table with Report
  • Create Forms of Different Types
  • Add a List of Values to a Form

Creating Lists of Values (6 topics)

  • Overview of Application Express Shared Components
  • Dynamic and Static Lists of Values
  • Create a Dynamic List of Values
  • Create a Static List of Values
  • Use a List of Values to Control Data in a Report
  • Create a Cascading List of Values

Items and Buttons (4 topics)

  • Create Items
  • Edit Item Attributes
  • Create Buttons
  • Edit Button Attributes

Page Processing (5 topics)

  • Page Rendering and Page Processing
  • Create Computations
  • Validate Input Data
  • Process Data
  • Create Application Branching

Display Dynamic Content (3 topics)

  • Filter Reports with Dynamic Queries
  • Create Charts with a Wizard
  • Create a Calendar

State and Debugging (5 topics)

  • Understand Session State
  • Set a Session State Value
  • Clear the Session State
  • Review the Session State
  • Review the Messages in Debug Mode

Themes and Templates (7 topics)

  • Switch to a Different Theme
  • View Existing Templates
  • Manage Templates
  • Create a new Template
  • Template subscription
  • Add a Reference to a Cascading Style Sheet
  • Add a reference to a Javascript file

Dynamic Actions and Plug-In Components (5 topics)

  • Understand Dynamic Actions
  • Understand Plug-in Components
  • Plug In a Component
  • Create a Dynamic Action
  • Use a Plug-in in a Dynamic Action

Build a Websheet Application (5 topics)

  • Websheet Components
  • Create a Websheet Application
  • Run a Websheet
  • Add a Section to a Websheet
  • Add a Page to a Websheet

Implement Security (4 topics)

  • Authentication and Authorization
  • Provide an Authentication Scheme
  • Create an Authorization Scheme Using Access Control
  • Enable and Configure Session State Protection

Deploy an Application (5 topics)

  • Define Supporting Objects
  • Package an Application
  • Export an Application
  • Import an Application
  • Install Supporting Objects

Prerequisites

A working knowledge of SQL and PL/SQL is required. Some knowledge of HTML would be beneficial but is not essential.

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.

Pricing

Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Jun Jul Aug Sep Oct Nov
Later scheduled dates may be available for this course.
Next 6 Months
Oracle Development Training Courses

Course PDF

Print

Share this Course

Share

Recommend this Course

Sections