0845 450 6120

Oracle Application Express Workshop II

This level 2 course is for anyone has attended the level 1 course and wants to learn more about Application Express (APEX)

Reset

Learning Objectives

Special Notices

This course runs on APEX version 5

Pre-Requisites

We recommend a basic knowledge of SQL and PL/SQL & APEX

Course Content

Adding Features to Your Application

  • BLOB handling
  • Sending E-Mails and attachments
  • Creating Tabular Forms Manually
  • Using Collections
  • User defined Error Handling
  • Creating Data Load Pages
  • Creating Trees

Introduction to Dynamic Actions

  • What are Dynamic Actions?
  • Creating an Enable/Disable Declarative Dynamic Action
  • Creating a Set Value Dynamic Action with a SQL Statement
  • Create a Set Value Dynamic Action Using PL/SQL
  • Changing the class when an item is null
  • Disabling a Button When Items are Null
  • Refreshing the data in a report using custom filters

Introduction to Plug-ins

  • Identifying the steps to creating and using a plug-in in your Application
  • Importing a plug-in
  • Creating a plug-in

Creating Mobile Applications

  • Add a mobile user interface to a database application
  • Creating List View
  • Creating and linking a form to the application
  • Add a link on the Home page
  • Use some of the HTML5 item types
  • Adding a HTML5 chart to your application

Creating Dynamic Content

  • Understanding Conditional Logic
  • Dynamic PL/SQL Content
  • Creating PL/SQL Reports

Websheets

  • What are Websheets?
  • Websheet verses Database Applications
  • Creating Websheets
  • Editing Properties
  • Running the WebsheetPages
  • Pages and Sections
  • Incorporating a Text Section
  • Incorporating a Data Section
  • Incorporating a Chart Section
  • Incorporating a PL/SQL Section
  • Incorporating a Navigation Section
  • Adding Annotations to a Page
  • Using Markup Syntax
  • Sharing Websheets with Users

Team Development Functionality

  • Tracking features, milestones, bugs and to dos
  • Managing Feedback
One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include