Oracle Application Express – Level 2

Difficulty
Rating
1020,00 
+ VAT

We are sorry, but currently we don't know when the course will be arranged next time.
Please contact sales: +358 20 7776 670 or myyntipalvelu@sovelto.fi

Overview

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

Outline

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

Prerequisites

We recommend a basic knowledge of SQL and PL/SQL & APEX or attendance of the following courses prior to attending the course:
http://qa.com/training-courses/technical-it-training/oracle/database/database-application-development/oracle-database-sql-and-plsql-fundamentals/

Also the course http://www.qa.com/training-courses/technical-it-training/oracle/database/database-application-development/oracle-application-express-level-1/

 

Places left:
No participant limit
1020,00  + VAT