Introduction To Application Express

Working With Oracle APEX

The Introduction To Application Express training course provides a complete, hands-on introduction to Oracle APEX 5.0, Oracle’s premier Rapid Application Development tool.

With this revolutionary tool, you can, quickly and efficiently, create highly complex web-based applications that will run on any operating system environment, including smart phones.

In this class, you will build a fully-functioning application from the ground-up. If you are a database user wanting to explore rapid application development, this class is for you. This course requires completion of five-day Oracle 11g or 12c SQL course or equivalent experience, and completion of five-day Oracle 11g or 12c PL/SQL course or equivalent experience.

Course Summary

Purpose: 
To introduce database users and administrators to Oracle APEX 5.0, Oracle’s premier Rapid Application Development tool.
Audience: 
Software developers, database users, business analysts, application developers, database administrators, and IT managers.
Skill Level: 
Learning Style: 

Hands-on training is customized, instructor-led training with an in-depth presentation of a technology and its concepts, featuring such topics as Java, OOAD, and Open Source.

Hands On help
Duration: 
5 Days
Productivity Objectives: 
  • Completely understand how to create highly complex web-based applications
  • Create interactive reports that allow for full customization, including:
    • Searching and sorting
    • Creating control break reports
    • Performing highlighting to focus on specific rows or values
    • Adding custom computations (including aggregations)
    • Charting and custom dashboards
Introduction To Application Express is part of the Oracle curriculum.

What You'll Learn

In the Introduction To Application Express training course you’ll learn:

  • Chapter 1 – Introduction To APEX
    • Overview Of The Class
    • History Of APEX
    • APEX Instance Options
    • Tools
      • Web Browser Selection
      • SQL*Plus
      • SQL Developer
  • Chapter 2 – APEX Installation
    • Removing The Old Version
    • Installing The New Version
    • APEX ADMIN Setup
    • Configuring RESTful Services
    • Configuring The Embedded PL/SQL Gateway
    • Creating A Workspace
  • Chapter 3 – The APEX Workspace
    • Roles For APEX Users
    • Anatomy Of An Application
    • Overview Of APEX Modules
      • Application Builder
      • SQL Workshop Interface
      • SQL Commands Interface
      • SQL Scripts Interface
      • Utilities Interface
    • Team Development / Administration
  • Chapter 4 – Our Real World Problem
    • Needed Database Objects
    • Designing For APEX
    • APEX And PLSQL
    • The “Parse As” Schema
  • Chapter 5 – Initial Object Design
    • Needed Database Objects
      • Tables
      • Views
      • Triggers
      • Sequences
      • Comments
    • Generating Application Documentation
  • Chapter 6 – Object Design II
    • Loading Data
    • Creating Lookup Tables
    • Loading And Running Scripts
    • User Interface Defaults
  • Chapter 7 – Creating & Navigating Apps
    • Using The Create Application Wizard
    • Understanding Websheets
    • Creating Applications From Spreadsheets
    • Creating Applications From Scratch
      • Regions
      • Public Pages / Global Pages
      • Navigation Bar Entries
      • Breadcrumbs / Lists / LOVs
  • Chapter 8 – Basic Forms And Reports
    • Forms On Tables
    • Forms On Procedures
    • Master-Detail Forms And Reports
    • Creating Searchable Reports
    • Using Declarative BLOBs
  • Chapter 9 – Advanced Forms And Reports
    • Creating Tabular Forms
    • Interactive Reports
    • User Help For Interactive Reports
    • Subscribing To Reports
    • Creating Calendars
    • Creating Charts
  • Chapter 10 – Programmatic Components
    • Using Conditions
    • Using Required Values
    • Using Validations
    • Creating Computations
    • Creating Processes
    • Using PL/SQL Regions
    • Using Dynamic SQL
  • Chapter 11 – Dynamic Actions
    • Understanding Dynamic Actions
    • Implementing Dynamic Actions
    • Using Multiple Triggering Elements
    • Using PL/SQL
    • Using JavaScript
  • Chapter 12 – APEX Security
    • Integrating User Security
    • Creating Needed Database Objects
    • Security Model Implementation
    • Authentication
    • Conditional Security
    • Controlling Data Access
    • Protecting Session State
  • Chapter 13 – Websheets
    • The Structure Of A Websheet
    • Navigating Websheets
    • Websheet Help
    • Markup Syntax
    • Authenticating & Authorizing Users
    • Sections In Websheets
    • Using Annotations
  • Chapter 14 – Creating A Websheet Application
    • Creating The Database Objects
    • Websheet Creation And Configuration
    • Creating Websheet Content
  • Chapter 15 – Bundling And Deployment
    • Application Component Identification
    • Including Supporting Objects
    • Importing An Application
  • Chapter 16 – Additional Developer Tools
    • Understanding Page Locks
    • Application Groups / Page Groups
    • The APEX Data Dictionary
    • Monitoring APEX Applications
    • The APEX Advisor
    • APEX Build Options
    • Using Page-Specific Utilities
  • Chapter 17 – Workspace Management
    • The APEX Administration Interface
    • Service Management
    • Metadata Management
    • User / Group Management
    • Monitoring Activity And Dashboards
  • Chapter 18 – APEX Team Development
    • The Team Development Interface
    • Features
    • Milestones
    • To-Do Items
    • Bugs
    • Feedback
    • Team Actions
    • Available User Roles

Contact us to learn more

Not all training courses are created equal. Let the customization process begin! We'll work with you to design a custom Introduction To Application Express training course that meets your specific needs.

DevelopIntelligence has been in the technical/software development learning and training industry for nearly 20 years. We’ve provided learning solutions to more than 48,000 engineers, across 220 organizations worldwide.

About Develop Intelligence
Di Clients

surveyask

Need help finding the right learning solution?   Call us: 877-629-5631