Oracle APEX Training Class
 
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   

Oracle Application Express (APEX) Development

(formerly HTML-DB)

  A 5-day on-site APEX Class
2005-2016 by Burleson Corporation
 

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

 

   
 
APEX Consulting

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.


 
Key Features

* 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!

  

Course Description

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.

Book Required

  Easy Oracle HTMLDB

Kent Crotty & Michael Cunningham
Rampant TechPress (2005)

ISBN: 0-9761573-1-4


Book Details

Audience

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.

Curriculum Design

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
 
Syllabus
 


Installing
APEX

Upgrading APEX
mod_plsql

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

Importing Data
Exporting Data

APEX SQL Workshop

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

Learning APEX

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

HTML DB 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 Navigation

NavBar
Tabs
Menus
Buttons
Trees

Customizing HTML DB

APEX Regions
APEX Themes
APEX Templates
CSS



APEX Debugging, HTML DB API’s. APEX Best Practices
 
 

Course Exercises:

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.


 

 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.