Oracle Training : Oracle APEX Version 5.0.4

Oracle APEX Version 5.0.4

Oracle Training Overview

This course provides a complete, hands-on introduction to Oracle APEX 5, Oracle’s 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 smartphones.

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. In fact, they will create:

A desktop application with interactive reports
A mobile application with data entry and review capability
A multiple page website (websheet) with an interactive database interface

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 12c SQL course or have equivalent experience

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

Course duration

5 Days

Oracle Training Course outline

Chapter 1 – Introduction To APEX

Life Without Oracle Application Express
A Summary Of APEX’s History
Controlling The History Of APEX
APEX Instance Options
Choosing A Web Browser
SQL*Plus
- Copy And Paste In SQL*Plus
- Launching SQL*Plus From The Command Prompt
SQL Developer
- Running Queries
- Using Query Builder
- Exploring And Manipulating Objects
- Running Scripts

Chapter 2 – APEX Installation

The Database
Downloading APEX
Staging The Installation Files
Removing The Preinstalled Version Of APEX
Running The Main APEX Installation Script
APEX Admin Account Setup
Configuring Restful Services
Configuring The Embedded PL/SQL Gateway
Miscellaneous Tasks
Enabling Network Services
Logging In As Admin And Creating A Workspace
Setting Up Email
Creating A Workspace Based On An Existing Schema
Objects Created In A New Or Existing Schema

Chapter 3 – Overview Of The APEX Workspace

Workspace Anatomy
- The “Parse As” Schema
Roles For APEX Users
- Instance Administrators
- Workspace Administrators
- Developers
- End Users
Anatomy Of An Application
- Applications
- Pages
- Regions
- Items
Relationships Between Workspaces, Applications And Database Schemas
- Associating Multiple Schemas With An Application
Overview Of APEX Modules
The APEX Home Page
The Application Builder Drop-Down And Page
- Create Application
- Import
- Export
- Dashboard
- Workspace Utilities
- Application Migrations
The SQL Workshop Drop-Down And Page
- The Object Browser
- The Table Link
- The Data Link
- The Indexes Link
- The Model Link
- The Constraints Link
- The Grants Link
- The Statistics Link
- The UI Defaults Link
- The Triggers Link
- The Dependencies Link
- The SQL Link
- SQL Commands
- SQL Scripts
- Utilities
- Query Builder
- Data Workshop
- Generate DDL
- Methods On Tables
- User Interface Defaults
- Schema Comparison
- Object Reports
- Recycle Bin
The Team Development Drop-Down And Page
The Packaged Apps Drop-Down And Page
The Administration Drop-Down And Page

Chapter 4 – Our Real World Problem

The Problem And Solution Requirements
Needed Database Objects
- The Team Table
- The Work_Orders Table
- The WO_Details Table
Designing For APEX
Primary Key Considerations With APEX
APEX And PL/SQL
Schemas For Database Objects

Chapter 5 – Initial Object Design

Overview Of Our Process
Creating Our Application Objects
- The Team Table
- The Work_Orders Table
- The WO_Details Table
The Table And Column Comments
Additional PL/SQL Objects And Modifications Needed
Documenting Your Application

Chapter 6 – Object Design II

Loading Data Into Our Tables
Creating Lookup Tables
Loading And Running Scripts
User Interface Defaults
- Defining Table Dictionary Defaults

Chapter 7 – Creating & Navigating Apps

Using The Create Application Wizard
- Packaged / Sample Applications
Understanding Websheet Applications
Creating Applications From Spreadsheets
- Highlighting
- Control Break Reports
- Inserting New Records
- Updating Records
- Deleting Records
Creating Applications From The Ground Up
- Naming Applications
- Adding A Page
- Shared Components
- Application Attributes
Understanding Page Designer
- The Toolbar
- The Tree Pane
- The Central Pane
- Property Editor
- Resizing Components Of Page Designer
- Gallery Pane
Building Our Home Page
Using Public Pages
Using Navigation Bar Entries
Using Global Pages
Using Breadcrumb Regions
- Breadcrumb Entries
Using Lists
Generating And Using Lists Of Values
- Static LOVs
- Dynamic LOVs
Release / Screen Reader
- Customizing Release Information
- The Screen Reader Mode Link

Chapter 8 – Basic Forms And Reports

Building A Form On A Table
Modifying A Form On A Table
Looking Behind The Curtain
Creating A Form On A Procedure
Modifying A Form On A Procedure
Creating Master-Detail Reports And Forms
Modifying Master-Detail Reports
Editing
Using Session State
- Inspecting Available Session State Variables
- A Valuable Button
Using APEX Items
- The Benefits Of Bind Variables
- Using Built –In Items
URL Syntax
Copying Web Pages
Creating Searchable Reports
- Modifying Our Report
- The Need For Reset Pagination
- Highlighting Your Search Term
Deleting Pages
Modifying Form Design
- Changing Display Order
- A Few Additional Tweaks
APEX Help
Using Declarative BLOBs

Chapter 9 – Advanced Forms And Reports

Creating Tabular Forms
Modifying Tabular Forms
- Creating A Button That Links To A Page
Interactive Reports
- Creating Interactive Reports
- Running The Interactive Report
- The Finder Drop-Down
- Select Columns
- Filter
- Rows Per Page
- Format
- Sort
- Control Break
- Highlight
- Compute
- Aggregate
- Save Report
- Chart
- Group By
- Pivot
- Flashback
- Building A New Summary Report
Restricting Interactive Functionality
- For Each Report
The Column Heading Menu
User Help For Interactive Reports
Subscribing To Reports
Downloading Interactive Reports
Modifying The Edit Link For Interactive Reports
Creating Calendars
- Creating The Lease Expires Calendar
- Adding Supplemental Information To Calendar Entries
Creating Charts
- SQL For Charts
- Chart Creation
The “Lost Updates” Issue

Chapter 10 – Programmatic Components

Using Conditions
Using Required Values
Using Validations
- Item-Level Validations
- Page-Level Validation
- Validations For Tabular Forms
Creating Computations
- Understanding Execution Timing
- Computation Types
- Creating Computations
Creating Processes
- Using A Process
- Undocumented Feature Report
- Adding Columns To Tables Mid-Stream
Using PL/SQL Regions
Using Dynamic SQL

Chapter 11 – Dynamic Actions

Understanding Dynamic Actions
Implementing Dynamic Actions
- Dynamic Actions Based On Page-Level Events
Using Multiple Triggering Elements
Using PL/SQL For Dynamic Actions
Using JavaScript For Dynamic Actions

Chapter 12 – APEX Security

Integrating User Security Into Your Application
Creating Needed Database Objects
Who Do You Think You Are?
Security Model Implementation
Authentication
Custom Authentication
Switching Authentication Schemes
Database Authentication
Conditional Security
Controlling Access
Authorizations
Using Read-Only Items
Securing Data
Protecting Session State

Chapter 13 –Mobile Applications

A Fresh Look At Mobile Applications
Less Is More???
Creating The Mobile Application
The Fifty-Cent Tour Of Mobile Applications
- Which Wizard?
Back To Building Pinnacle Mobile
- Wiring Up The Custom Authentication
- Trigger Modification
- Building The Home Page
- Building The Submit A Work Order Page
- Copying Pages From Other Applications

Chapter 14– Websheets

Introduction To Websheet
The Structure Of A Websheet
Navigating Websheets
- Navigating Content
- Structural Navigation
Websheet Help
Markup Syntax
Authenticating Users
User Authorization
Sections In Websheets
- Text Sections
- Navigation Sections
- Data Sections
- Chart Sections
Using Annotations
The Administration Drop-Down
Exporting A Websheet
Importing A Websheet
Deleting A Websheet

Chapter 15 – Creating A Websheet Application

Creating The Database Objects
Websheet Creation And Configuration
Creating Websheet Content
- Data Grid Constraints
- Alternative Default Reports
- SQL Tags
Websheet Access Controls

Chapter 16 – Bundling And Deployment

Application Component Identification
- New Applications
- Existing Applications
- Using APEX-Based Files
- Application Export
- Exporting A Websheet
Including Supporting Objects
Importing An Application

Chapter 17 – Additional Developer Tools

Understanding Page Locks
Application Groups
Page Groups
The APEX Data Dictionary
APEX Searches In Applications
Monitoring APEX Applications
APEX APIs
APEX Plug-Ins
The APEX Advisor
APEX Build Options
- Creating The Build Option
- Applying The Build Option
Using Page-Specific Utilities
Using SQL Developer With APEX
Refactoring
Using Theme Roller

Chapter 18 – Workspace Management

The APEX Administration Interface
Service Management
Workspace Preferences
Editing Announcements
Metadata Management
- Developer Activity And Click Count Logs
- Click Count Logs
- Session State
- Application Cache
- Websheet Database Objects
- Application Build Status
- File Utilization
- Interactive Report Settings
User / Group Management
- User Groups
Monitoring Activity
Dashboards
Utilization Report
Deleting Applications

Chapter 19 – APEX Team Development

Architectural Overview
The Team Development Interface
- The Team Development Home Page
Features
- History Button
- Progress Log Button
Milestones
- Milestones Page
- By Owner
- Features By Milestone
To-Do Items
Bugs
Feedback
Team Development Utilities
- Manage Links
- Manage News
- Team Development Settings
- Release Summary
Available User Roles