Introduction To Application Express Course

Course Summary

The Introduction To Application Express training course is designed to demonstrate an introduction to Oracle Application Express (APEX) 5.0.

The course begins with an introduction into how to build a fully-functioning application from the ground-up.

Purpose

Learn how to build an application using 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.

Role

Business Analyst - Software Developer - Technical Manager

Skill Level

Intermediate

Style

Hack-a-thon - Learning Spikes - Workshops

Duration

5 Days

Related Technologies

Web Development

Download

Productivity Objectives:

Demonstrate how to create highly complex web-based applications
Create interactive reports that allow for full customization
Experiment with searching and sorting
Create control break reports
Perform highlighting to focus on specific rows or values
Add custom computations (including aggregations)
Apply charting and custom dashboards

Learn About Virtual Training

Request Information

Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.

If you are not completely satisfied with your training class, we'll give you your money back.

about our training

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
Expert Practitioners

Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.
Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
Fully Customized

One-size-fits-all doesn't apply to training teams. That's where we come in!

What You'll Learn

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

Introduction To APEX
- Overview Of The Class
- History Of APEX
- APEX Instance Options
- Tools
  - Web Browser Selection
  - SQL
  - Plus
  - SQL Developer
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
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
Our Real World Problem
- Needed Database Objects
- Designing For APEX
- APEX And PLSQL
- The “Parse As” Schema
Initial Object Design
- Needed Database Objects
  - Tables
  - Views
  - Triggers
  - Sequences
  - Comments
- Generating Application Documentation
Object Design II
- Loading Data
- Creating Lookup Tables
- Loading And Running Scripts
- User Interface Defaults
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
Basic Forms And Reports
- Forms On Tables
- Forms On Procedures
- Master-Detail Forms And Reports
- Creating Searchable Reports
- Using Declarative BLOBs
Advanced Forms And Reports
- Creating Tabular Forms
- Interactive Reports
- User Help For Interactive Reports
- Subscribing To Reports
- Creating Calendars
- Creating Charts
Programmatic Components
- Using Conditions
- Using Required Values
- Using Validations
- Creating Computations
- Creating Processes
- Using PL/SQL Regions
- Using Dynamic SQL
Dynamic Actions
- Understanding Dynamic Actions
- Implementing Dynamic Actions
- Using Multiple Triggering Elements
- Using PL/SQL
- Using JavaScript
APEX Security
- Integrating User Security
- Creating Needed Database Objects
- Security Model Implementation
- Authentication
- Conditional Security
- Controlling Data Access
- Protecting Session State
Websheets
- The Structure Of A Websheet
- Navigating Websheets
- Websheet Help
- Markup Syntax
- Authenticating & Authorizing Users
- Sections In Websheets
- Using Annotations
Creating A Websheet Application
- Creating The Database Objects
- Websheet Creation And Configuration
- Creating Websheet Content
Bundling And Deployment
- Application Component Identification
- Including Supporting Objects
- Importing An Application
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
Workspace Management
- The APEX Administration Interface
- Service Management
- Metadata Management
- User / Group Management
- Monitoring Activity And Dashboards
APEX Team Development
- The Team Development Interface
- Features
- Milestones
- To-Do Items
- Bugs
- Feedback
- Team Actions
- Available User Roles