Oracle Training : Oracle APEX Version 4.2.5

Oracle APEX Version 4.2.5

Oracle Training Overview

This course provides a complete, hands-on introduction to Oracle APEX 4.2.5, Oracles premier Rapid Application Development tool. With this revolutionary tool, developers can quickly and efficiently create highly complex web-based applications that will run on any operating system environment including smart phones. Interactive reports can be created 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

In this class, students will actually build a fully functioning application from the ground up.

Oracle Training Audience

This course is appropriate for any database user wanting to explore rapid application development. That would include end users, business analysts, application developers, database administrators and IT management.

Oracle Training Prerequisites

Students attending this course should have:

Completed our five day Oracle 11g or 12c SQL course or have equivalent experience
Completed our five day Oracle 11g or 12c PL/SQL course or have equivalent experience

Course duration

5 Days

Oracle Training Course outline

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