Oracle Application Express

3 days @ £1,195.00  
S5

Oracle Application Express Course Overview

This Oracle Application Express course introduces the delegate to Oracle's Application Express software.  It is designed to give delegates practical experience in using Application Express, also known as Apex, for building web-based applications for an Oracle database.

Skills Gained

The delegate will practice:

  • Developing an Apex Web Application
  • Creating Reports
  • Creating Forms
  • Managing Web Pages and Regions in the Apex Application
  • Using and Managing Shared Components in an Application
  • Using Cascading Stylesheets and Javascripts in Apex Applications
  • Adding graphs and charts to an Apex Application
  • Adding Page Processes to the Apex Applciation
  • 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
  • Administering Apex Workspaces
  • Loading and Unloading Data or Application Components
  • Deploying an Apex Application

Who will the Course Benefit?

The Oracle Application Express 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.

Course Objectives

By the end of the course delegates will be able to use the Oracle Application Express development environment for functional application development for the Web.  They will gain practical experience in building and deploying applications for the Web, in using Application Express to manage database objects and in administering the Oracle Application Express environment.

Requirements

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

Oracle Application Express Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE APPLICATION EXPRESS

  • APEX Concepts
  • APEX Main Components
  • Creating a Workspace
  • The Workspace Administrator
  • Logging into APEX
  • Running an Application

Session 2: SQL WORKSHOP

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

Session 3: BUILD AN APPLICATION

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

Session 4: CREATE REPORTS

  • Create Reports Using Wizards
  • Edit Report Attributes
  • Add Links to Reports
  • Create a Link to a Printer-Friendly version of a Report
  • Save Reports in Different Formats
  • Print Reports in Different Formats

Session 5: PAGES AND REGIONS

  • View Page Definitions
  • Edit Page Definitions
  • Create a Page Zero
  • Create a New Region
  • View Region Attributes
  • Add Comments
  • Add a Title
  • Add a logo

Oracle Application Express Training Course

Course Contents - DAY 2

Session 6: CREATE FORMS

  • Web Form Behaviour in APEX
  • Create Forms of Different Types
  • Format a Form
  • Add a List of Values to a Form
  • Locking in APEX Forms

Session 7: ITEMS AND BUTTONS

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

Session 8: PAGE PROCESSING

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

Session 9: ADD SHARED NAVIGATION COMPONENTS

  • Overview of Application Express Shared Components
  • Parent and Standard Tabs
  • Navigation Bars
  • Lists
  • Breadcrumbs

Session 10: OTHER SHARED COMPONENTS

  • Lists of Values
  • Trees
  • Shared Component Reports
  • User Interface Defaults

Session 11: DISPLAY DYNAMIC CONTENT

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

Oracle Application Express Training Course

Course Contents - DAY 3

Session 12: Session STATE AND DEBUGGING

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

Session 13: THEMES AND TEMPLATES

  • 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

Session 14: ADMINISTER APEX WORKSPACES

  • Manage Users
  • Request a Schema or Storage
  • Purge Session State
  • Monitor Developer Activity Log
  • Monitor Workspace Activity
  • View Activity reports
  • Import a Workspace

Session 15: IMPLEMENT SECURITY

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

Session 16: DEPLOY AN APPLICATION

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

Session 17: UTILITY PROGRAMS

  • Import and Export Data
  • Generate DDL Statements
  • View Objects Reports
  • Monitor the Database

Pre-Requisite Courses

Follow-On Courses


       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking

In London


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

 

MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600 6116
Manchester centre:
MWB Manchester
Pall Mall Court
61-67 King Street
Manchester
M2 4PD
UK
Birmingham centre:
MWB Birmingham
43 Temple Row
Birmingham
B2 5LS
UK
Bristol centre:
Woodhouse Manor
Fern Hill
Almondsbury
Bristol
BS32 4LX
UK
Leeds centre:
c/o Blue Chip Training Solutions
11 New Princess Street
Leeds
LS11 9BA
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600 6116

or email:

info@
stayahead.com



 

Top  |  Go back  

Print Friendly

Printer friendly version of the Oracle Application Express outline