Advanced Oracle Application Express (APEX) Workshop

Course Overview

Customizing APEX Templates

• Create Custom Templates
• Use Subscriptions

Responsive Web Design

• Allow applications to re-size to any device
• Brief CSS overview
• How do media queries work
• Using print media query

APEX Collections

• Create and use a collection.
• Build an event application using a collection
• Discuss collection limitations
• Wrap collections in a database view

Manual Forms with PL/SQL

• How to convert a declarative form to a manual form
• Understand row locking in a web environment
• Discuss MD5 hash and row versioning
• Detect if row level updates are needed

Manual Tabular forms

• Manually Creating Tabular Forms
• Validation in Tabular Forms
• Working with Collections

Error Handling

• Brief discussion on the interface injection design pattern
• How to catch errors raised within APEX and PL/SQL
• Map constraints and errors to friendly messages

Debugging

• How to use the apex_debug API
• How to approach locating a bug
• Understand the sequence of events that happen on a page
• Integrate SQL developer line by line debugger

SQL Developer & APEX Integration

• Custom views and reports
• Managing apex environment
• Deploying applications

Performance

• Settings which impact application performance
• Fixing report pagination
• How to use a dynamic report source

Production Issues

• How to deploy an application
• Discuss deployment strategies
• Manage database objects, apex objects, and developer files
• Deployment workflow

REST services – Publish

• Discuss ORDS(Oracle Resful Data Services) requirements
• Create a declarative services to expose data for disparate systems

REST services – Consume

• Read web service data from PL/SQL
• Perform AJAX operations to retrieve data
• apex.process javascript object

Prerequisites

• Intermediate APEX Class or equivalent knowledge
• Students should have built several production APEX Applications
• Experience with Structured Query Language (SQL) and Oracle PL/SQL

• Technical Requirements

  Nothing is required for labs (workshops). We will provide everything you need for all hands-on labs. Modest PC or Mac specs are required to connect to the online class.  

  Also, we strongly recommend using two monitors for this class.