Oracle Application Express (APEX)
A 5-day on-site APEX Class
© 2005-2016 by Burleson Corporation
For Oracle APEX consulting, we have certified Oracle expert developers to
provide world-class APEX services. APEX consulting is a great value
because APEX consultants can create complex systems fast and inexpensively.
* See ready-to-use examples for
creating APEX applications
* Learn step-by-step examples of APEX
data access and document formatting
* Create dynamic web content with APEX
* Understand how to update Oracle APEX
* Learn the best practices for
developing APEX systems to improve productivity, performance, and security
* Learn how to customize your
application with Themes and CSS
* Learn how to package your APEX application for easy deployment.
* See Rapid Application Development
techniques to create Oracle applications, fast!
This is an intensive course
designed to rapidly learn to develop Oracle systems with APEX.
APEX is one of the most exciting application
development tools and is a true Rapid Application Development environment that
can take an idea from concept to a working production level application in a
short period of time.
The course features working examples of complex APEX database access
and techniques for creating easy APEX applications.
||Easy Oracle HTMLDB
Kent Crotty & Michael Cunningham
Rampant TechPress (2005)
The student should have a
basic understanding of Oracle database administration and application
development with PL/SQL. This APEX course also assumes a basic knowledge
of DBA structures including tables, indexes and constraints.
This course was developed by Kent Crotty, a
noted APEX author and DBA working with Oracle for over 15 years. Crotty is an
Oracle Certified DBA and a graduate of the University of Maryland. He is an IT
professional with over 15 years in a variety of roles ranging from
Programmer/Analyst (developer) to Systems and Database Administrator. Kent is
instrumental in developing complex Oracle systems architectures and specializes
on web-based Oracle applications.
APEX Training Course
APEX Administration I
Just the basics
More administration will be provided in a later chapter
Creating a workspace
manual mode, simple, just enough to continue with examples in the book
Oracle APEX Data Workshop
APEX SQL Workshop
SQL Command Processor
Browsing Database Objects
Query by example
APEX Application Attributes
APEX Page Rendering
APEX Conditional Processing
APEX Shared Components
CSS and Image Files
Application Deployment with Oracle APEX
Loading APEX pictures and images
Deploying your APEX application to a production
Using Application Builder Utilities to Deploy Your APEX Application
CSS and Image Files
The Export Repository
HTML DB Administration II
APEX Administration Home
APEX Service Administration
Manage APEX Engine Settings
APEX Workspace Provisioning
Managing APEX Requests
Managing APEX Workspaces
Managing APEX Users
Creating Web Pages with APEX
APEX List of Values (LOVs)
Customizing HTML DB
APEX Debugging, HTML DB API’s. APEX Best Practices
Exercise - Pre-populating pull-down lists
– Show how to embed the data for super-fast pull-down lists in the pre-map
processes for all online query screens.
Exercise - Object-oriented APEX - Using
APEX lists (dynamic included content) and using our TCI template. Using nested
included content (nested header).
Exercise - Architecture - Creating and
modifying menu's, linking to SQL*Forms (and back again), keeping the current
process “state” when invoking sub-screens.
Exercise - Documentation & help - Updating
the ms-word "documentation" (the lower-right screen button). Running scripts for
extracting the table definitions (dbms_metadata) from APEX for the ms-word
documentation. Creating mouse-over help bubbles.
Exercise - Quick Search - Building
quick-search pull-downs. For example, the SSD screen main menus will pre-extract
the names of all "social enhancements" clients, prior to screen map-out, so the
end-users can get super-fast access. This lesson will also include building
pull-down menus for list values (e.g. island names).
Exercise - Java in APEX - Under what circumstances will
it be necessary to use Java inside APEX? Perhaps online form validation rules?
Let's find a real-world example at TCI and do it as an exercise. John Garmany
can help with the actual Java coding.
Exercise - APEX for the DBA - How do
minimize trips to the database? How to we lift system components for migration
to production? How can we implement source-code version control? How do we do
performance tuning of an APEX application? How do we handle PL/SQL
Exercise - APEX best-practices
– Advise on working with many-to-many data relationships. Using built-in APEX
functions whenever possible, and using XML interfaces with PDF templates.
Sending e-mail notifications, creating application-side user roles and coding
for restricting data access.
Exercise - APEX reporting
– Creating advanced reports in APEX. Using the Wizards, setting breakpoints,
pagination, printing reports, including custom report headers, including