Oracle Application Express Training Class

Get expert Oracle Application Express consulting For Oracle Oracle Application Express consulting, we have certified Oracle expert developers to provide world-class Oracle Application Express services.

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

* See ready-to-use examples for creating Oracle Application Express applications * Learn step-by-step examples of Oracle Application Express data access and document formatting * Create dynamic web content with Oracle Application Express * Understand how to update Oracle Oracle Application Express * Learn the best practices for developing Oracle Application Express systems to improve productivity, performance, and security * Learn how to customize your application with Themes and CSS * Learn how to package your Oracle Application Express application for easy deployment. * See Rapid Application Development techniques to create Oracle applications, fast!

This is an intensive Oracle application express training class designed to rapidly learn to develop Oracle systems with 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. The course features working examples of complex Oracle Application Express database access and techniques for creating easy Oracle Application Express applications.   Easy Oracle Oracle Application Express Kent Crotty & Michael Cunningham Rampant TechPress (2007) ISBN: 0-9761573-1-4 Book Details The student should have a basic understanding of Oracle database administration and application development with PL/SQL.  This Oracle Application Express course also assumes a basic knowledge of DBA structures including tables, indexes and constraints.

This Oracle application express class was developed by Kent Crotty, a noted Oracle Application Express 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.

Installing APEX

Upgrading to APEX version 1.6
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 Oracle Application Express Data Workshop

Importing Data
Exporting Data

Oracle Application Express SQL Workshop

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

Learning the APEX Application Builder

Application Attributes
Pages
Regions
Page Rendering
Conditional Processing
Shared Components
Wizards
Utilities
CSS and Image Files
Export/Import
Section III – Building Applications

Creating Web Pages with APEX

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

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 Oracle Application Express - Using Oracle Application Express 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 Oracle Application Express 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 Oracle Application Express - Under what circumstances will it be necessary to use Java inside Oracle Application Express ? 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 - Oracle Application Express 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 Oracle Application Express application? How do we handle PL/SQL packages/functions/procedures?

Exercise - Oracle Application Express best-practices – Advise on working with many-to-many data relationships. Using built-in Oracle Application Express functions whenever possible (per Tony Jedlinski), and using XML interfaces with PDF templates. Sending e-mail notifications, creating application-side user roles and coding for restricting data access.

Exercise - Oracle Application Express reporting – Creating advanced reports in Oracle Application Express . Using the Wizards, setting breakpoints, pagination, printing reports, including custom report headers, including calculations.

 

This is a copyrighted Oracle application Express training class (c) 2010 all rights reserved.