Oracle® Developer Courses from Activia

Oracle® Application Express - APEX

A 4-Day Training Course

Course Content

Course Aims

The Oracle Application Express course introduces delegates to Oracle's Application Express version 4 software. It is designed to give delegates practical experience in using Application Express version 4, also known as Apex, for building web-based applications for an Oracle database and websheets for managing structured and unstructured data.
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.
Apex version 4 includes all the features of Apex version 3. This course covers all the features of Apex version 3 and the new features introduced in version 4. The course is suitable for both Oracle Application Express version 4 and Oracle Application Express version 3 users. The course will be delivered using Apex version 4 software.

Who Should Attend

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.
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.
Pre-requisite courses would include:

  • Oracle SQL
  • Oracle PL/SQL

Course Outline

This course is a 4-day training course structured into 21 modules.

Module 1
Introduction to Oracle Application Express
Topics covered
  • APEX Concepts
  • APEX Main Components
  • Workspaces, Database Applications and Websheet Applications
  • Creating a Workspace
  • The Workspace Administrator
  • Upgrading APEX
  • Logging into APEX
  • Running an Application
  • 0
    Module 2
    Sql Workshop
    Topics covered
  • Use APEX to Browse, Create and Modify Objects
  • Process Ad Hoc SQL Statements
  • Manage Scripts in APEX
  • Create, Run and Save SQL Queries
  • 0
    Module 3
    Build a Database Application
    Topics covered
  • Application Components
  • Create an Application
  • Create an Application from a Spreadsheet
  • 0
    Module 4
    Create Reports
    Topics covered
  • Create Reports Using Wizards
  • Edit Report Attributes
  • Add Links to Reports
  • Create a Link to a Printer-Friendly version of a Report
  • Save and Print Reports in Different Formats
  • 0
    Module 5
    Pages and Regions
    Topics covered
  • 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
  • 0
    Module 6
    Introduction to Shared Components
    Topics covered
  • Overview of Application Express Shared Components
  • Standard Tabs
  • 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
  • 0
    Module 7
    Create Forms
    Topics covered
  • 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
  • 0
    Module 8
    Items and Buttons
    Topics covered
  • Create Items
  • Edit Item Attributes
  • Create Buttons
  • Edit Button Attributes
  • 0
    Module 9
    Page Processing
    Topics covered
  • Page Rendering and Page Processing
  • Create Computations
  • Validate Input Data
  • Process Data
  • Create Application Branching
  • 0
    Module 10
    Add Shared Navigation Components
    Topics covered
  • Overview of Application Express Shared Components
  • Parent and Standard Tabs
  • Navigation Bars
  • Lists
  • Breadcrumbs
  • 0
    Module 11
    Other Shared Components
    Topics covered
  • Text Messages/li>
  • Trees
  • Shared Component Reports
  • User Interface Defaults
  • 0
    Module 12
    Display Dynamic Content
    Topics covered
  • Filter Reports with Dynamic Queries
  • Create Charts with a Wizard
  • Format Charts
  • Create a Calendar
  • 0
    Module 13
    Dynamic Actions and Plug-In Components
    Topics covered
  • Understand Dynamic Actions
  • Understand Plug-in Components
  • Plug In a Component
  • Create a Dynamic Action
  • Use a Plug-in in a Dynamic Action
  • 0
    Module 14
    Session State and Debugging
    Topics covered
  • Understand Session State
  • Set a Session State Value
  • Clear the Session State
  • Review the Session State
  • Review the Messages in Debug Mode
  • 0
    Module 15
    Themes and Templates
    Topics covered
  • 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
  • 0
    Module 16
    Build a Websheet Application
    Topics covered
  • Websheet Components
  • Create a Websheet Application
  • Run a Websheet
  • Add a Section to a Websheet
  • Add a Page to a Websheet
  • 0
    Module 17
    Websheet Data Grids and Links
    Topics covered
  • Add a Data Grid to a Websheet using Copy & Paste
  • Add a Data Grid from Scratch
  • Link a Data Grid to a Websheet Page
  • Link a File to a Websheet Page
  • 0
    Module 18
    Administer Apex Workspaces
    Topics covered
  • Manage Users
  • Request a Schema or Storage
  • Purge Session State
  • Monitor Developer Activity Log
  • Monitor Workspace Activity
  • View Activity reports
  • Import a Workspace
  • 0
    Module 19
    Implement Security
    Topics covered
  • Authentication and Authorization
  • Provide an Authentication Scheme
  • Create an Authorization Scheme Using Access Control
  • Enable and Configure Session State Protection
  • 0
    Module 20
    Deploy An Application
    Topics covered
  • Define Supporting Objects
  • Package an Application
  • Export an Application
  • Import an Application
  • Install Supporting Objects
  • 0
    Module 21
    Utility Programs
    Topics covered
  • Import and Export Data
  • Generate DDL Statements
  • View Objects Reports
  • Monitor the Database
  • 0 0

    Activia Training :   Training courses for business at twelve locations UK wide