Intermediate Oracle APEX with Scott Spendolini

Intermediate APEX is designed for someone who has some APEX development experience and is looking to tap into some of the more sophisticated features of the tool as well as the Oracle Database.

The course starts out by discussing concepts such as database logic and regular expressions.  It then highlights how to use Oracle Database features as well as 3rd party products with APEX.  Students will  integrate an external web service with their APEX application.  Time is spent with three of the APEX APIs - APEX_MAIL, APEX_APPLICATION and APEX_ITEM.  The course also examines how to better secure your APEX applications.  It concludes with packaging up your application and discusses deployment options.
Course Topics
Packaged Applications
- Install a Packaged Application and its Supporting Objects
Database Logic
- Create a Form based on database triggers and constraints
Regular Expressions
- Understand basic concepts of Regular Expressions
- Create a Regular Expression-based Validation
Shared Components
- Create Application Items
- Create Application Computations
- Create Application Processes
- Create a Tree
- Set the Application Date Format Mask
- Manage Breadcrumbs
- Create Shared List of Values
Storing & Indexing Files
- Create a form to upload files with the Declarative BLOB feature
- Index search, and score your documents with Oracle Text
Web Services
- Understand the basics of Web Services
- Integrate an external Web Service with APEX
Collections & APIs
- Create a multi-page Wizard
- Modify the results of the Wizard
- Understand APEX Collections
- Create a Collection
- Add Members to a Collection
- Remove Members from a Collection
- Use the APEX_ITEM API in a report
- Use the APEX_APPLICATION API in a page process
- Create a custom tabular form with the APEX_ITEM API
- Create a tabular form validation
Pritning with PL/PDF
- Understand how to securely integrate PL/PDF with APEX
- Integrate a PL/PDF report with an APEX button
- Use PL/PDF Templates
Sending E-Mail
- Understand the APEX_MAIL API
- Send e-mail and attachments with the APEX_MAIL API
Personalization
- User Customizable Regions
- Using APEX User Preferences
Security
- Understand how VPD and APEX integrate
- Create and enable a VPD function
- Understanding and preventing Cross Site Scripting
- Understanding and preventing SQL Injection
Configuration Management
- Define and assign a Build Option
- Create scripts for a set of DDL actions
- Create a Packaged Application based on the class application
- Setting Application Attributes
- Subscriptions

 

Intermediate Oracle APEX with Scott Spendolini
  • Item #: APEX003
  * Marked fields are required.
Qty*
Price $1,800.00
Availability In-Stock