Oracle APEX

An Introduction to APEX (Application Express)

Welcome to the wonderful world of Oracle Application Express (APEX). You’re about to learn how to use a tool that we believe will revolutionize the way you think about and approach writing web-based Oracle systems. It certainly has for us.

Prior to the advent of APEX, developing fully interactive web based systems over data that resided within an Oracle database almost always meant learning a new and often complex language like Java, .NET, or PHP and then figuring out how to integrate your chosen language seamlessly with the data that resided in your database. Often this also meant trying to incorporate business rules that were already coded in the form of PL/SQL.

In such situations, it could take months or even years just to become proficient enough with your chosen language to begin to write a functional system. If you’re like many, you’ll become frustrated with the fact that you’ve spend an inordinate amount of time to do what seems like a relatively easy task. Fear not! The days of long-winded and complex web development platforms may just be behind us.

What is APEX?

APEX is a 100% browser-based rapid application development (RAD) tool that helps you to create rich interactive Oracle-based web applications very quickly and with relatively little programming effort.

There are many RAD development tools and platforms on the market. If you’re dealing with data that resides in an Oracle database, there are a number of things that makes APEX distinctive and thus more attractive as a development platform. First and foremost is the fact that APEX is built on and uses as its core languages, SQL, and PL/SQL. This is a huge advantage for those of you who have already been working with the Oracle database because it means you can immediately draw on what you know. Even for those who don’t have an Oracle background, if you are going to be working with an Oracle database, you’ll need to learn about its particular flavor of SQL and will at some point likely find a need for the PL/SQL procedural language.

This fact becomes even more beneficial if you are migrating an Oracle-based system to APEX that already has a significant amount of business logic coded into stored PL/SQL program units. In this instance, you can almost immediately take advantage of that logic with very little effort or change to the existing code.

Another great advantage is that APEX is a declarative tool that provides a feature rich core designed to make your job easier. Because APEX takes care of many of the underlying functions common to all web-based applications you are able to focus on the logic specific to your application.

A large share of what you need to accomplish can be done by using one of the many built-in wizards provided as part of the APEX Application Builder. The wizards walk you through the process of defining what you want your application to do and then stores that information as metadata. Once the wizard is complete you can edit and enhance the functionality, or even replace it with your own custom SQL and PL/SQL routines. After you become proficient with APEX you might even find yourself bypassing the wizards altogether and generating more complex definitions directly.

What to learn

This Oracle Application Express Workshop training teaches you how to quickly and efficiently develop database-centric web applications using Oracle Application Express. Explore implementing security in your applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express.

Learn To:

  • Create database applications for both desktop and mobile interfaces.
  • Add various components like new pages, reports regions, items and other components required to enhance an application.
  • Create processes, validations, computations and dynamic actions within an application.
  • Change the look and feel of your web applications using built-in themes and templates.
  • Create and use shared components for an application.
  • Understand managing and using session state variables.
  • Implement security in an application.
  • Manage application navigation using shared components.
  • Improvise your application by creating calendars, charts and trees.
  • Extend your application by adding advanced features like printing, BLOB object, data loading, site and more.
  • Enable feedback mechanisms from the application and tracking the feedback from Oracle APEX.

Benefits to You

When you walk away from this course, you will have developed the knowledge and skills to create database applications using desktop and mobile interfaces. You'll learn how to enhance your application by adding various components like reports, forms, items, dynamic actions, calendars, charts, plug-ins and other shared components required in an application.

Course Objective

  • Create Pages and Regions in an Application.
  • Log in to an Oracle Application Express Workspace
  • Create Page and Application Items and Buttons
  • Create Page Processes and Validations
  • Implement Security
  • Manage Application Navigation
  • Extend an Application
  • Create Themes and Templates
  • Create Shared Components such as Tabs, Lists, and Breadcrumbs.
  • Add Dynamic Actions
  • Import and Use Plug-Ins
  • Create and Use Calendars and Trees
  • Utilize Application Express Printing methods
  • Manage Application feedback
  • Create Reports and Forms in an application
  • Create and Run Database Applications using desktop and mobile interfaces

Course Overview

  • Maintaining Database Objects Using SQL Workshop
  • Creating a Database Application
  • Working with Pages and Regions
  • Using and Creating Interactive Reports
  • Creating Forms
  • Adding Items and Buttons
  • Understanding Session State
  • Including Page Processing
  • Validating and Debugging Your Application
  • Adding Shared Components That Aid Navigation
  • Working with Themes, Templates, and Files
  • Implementing Security
  • Managing Application Navigation
  • Extending Your Application
  • Displaying Dynamic Content
  • Utilizing Application Express Printing
  • Deploying Your Application
  • Building a Websheet Application
  • Managing and Maintaining the Application Development Process