Oracle Apex Training Course

This Apex course is taught at your Company site with up to 20 students.  Click here for on-site Apex course prices Optional supplemental mentoring

Apex Training Experts Our Oracle Apex training courses use experienced Apex developers to provide world-class Apex classes.  On site Apex training is a great value because our Apex training is customized just for you.

* 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 Oracle Apex programming course designed to allow you to rapidly learn to develop Oracle systems with Apex. Oracle Application Express (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. This Oracle Apex course features working examples of complex Apex database access and techniques for creating easy Apex applications. The student should have a basic understanding of Oracle database administration and application development with PL/SQL.  This Oracle Application Express (Apex) course also assumes a basic knowledge of DBA structures including tables, indexes and constraints.

This Oracle Apex training class course was developed by a Oracle Certified DBA.

Installing Apex

Upgrading to the latest Apex version
Configuring Apex 4
using mod_plsql

Apex Administration I

Development basics
Creating a workspace
Apex development best practices

Apex users and schema management

Apex authentication and user management
Apex conditions and authorization schema
Apex data security

Apex architecture and layout

Apex dynamic actions
Apex websheets
Working with Apex collections

Oracle Apex Data Workshop

Importing Data
Exporting Data

Apex SQL Workshop

SQL Command Processor
Explain Plan
Browsing Database Objects
Query by example
UI Defaults
Scripts

Learning the Apex Application Builder

Apex Application Attributes
Apex Pages
Apex Regions
Apex Page Rendering
Apex Conditional Processing
Apex Shared Components
Apex Wizards
Apex Utilities
CSS and Image Files
Export/Import

Application Deployment with Oracle Apex

Loading Apex pictures and images
Using Apex tabs
Using breadcrumbs
Deploying your Apex application to a production
Using Application Builder Utilities to Deploy Your Apex Application
Export/Import
CSS and Image Files
The Export Repository

Apex Administration II

Apex Administration Home
Apex Service Administration
Manage Apex Engine Settings
Apex Workspace Provisioning
Managing Apex Requests
Managing Apex Workspaces
Export
Import
Managing Apex Users
Security

Creating Web Pages with Apex

Apex Forms
Apex Reports
Apex Charts
Apex Buttons
Items
Apex List of Values (LOVs)
Calendars
Shortcuts
Java

Apex reports, creating, printing and Apex graphics

Using Apex themes and templates

Apex localization

Apex Debugging

Apex 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 packages/functions/procedures?

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 calculations.

 

This Oracle Apex training class is copyright (c) 2016 by BC, all rights reserved.