Oracle APEX Version 5.0.4

Course:  ORAPEX
Duration:  5 Days
Level:  II
Course Summary

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

« Hide The Details
Topics Covered In This Course

C***********************************

Chapter 1 Introduction To APEX

C***********************************

Life Without Oracle Application Express

A Summary of APEXs 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

C******************************* 

Chapter 2 APEX Installation

C*******************************

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

C************************************************** 

Chapter 3 Overview of The APEX Workspace

C************************************************** 

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

C*************************************** 

Chapter 4 Our Real World Problem

C***************************************

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

C********************************* 

Chapter 5 Initial Object Design

C********************************** 

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

C***************************** 

Chapter 6 Object Design II

C***************************** 

Loading Data into Our Tables

Creating Lookup Tables

Loading and Running Scripts

User Interface Defaults

  • Defining Table Dictionary Defaults

C****************************************** 

Chapter 7 Creating & Navigating Apps

C****************************************** 

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

C**************************************** 

Chapter 8 Basic Forms and Reports

C**************************************** 

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

C******************************************** 

Chapter 9 Advanced Forms and Reports

C********************************************* 

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

C******************************************* 

Chapter 10 Programmatic Components

C*******************************************

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

C******************************* 

Chapter 11 Dynamic Actions

C*******************************

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

C***************************** 

Chapter 12 APEX Security

C***************************** 

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

C********************************** 

Chapter 13 Mobile Applications

C********************************** 

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

C************************* 

Chapter 14 Websheets

C************************* 

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

C************************************************* 

Chapter 15 Creating A Websheet Application

C************************************************* 

Creating the Database Objects

Websheet Creation and Configuration

Creating Websheet Content

  • Data Grid Constraints
  • Alternative Default Reports
  • SQL Tags

Websheet Access Controls

C***************************************** 

Chapter 16 Bundling and Deployment

C*****************************************

Application Component Identification

  • New Applications
  • Existing Applications
  • Using APEX-Based Files
  • Application Export
  • Exporting A Websheet

Including Supporting Objects

Importing an Application

C****************************************** 

Chapter 17 Additional Developer Tools

C****************************************** 

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

C***************************************** 

Chapter 18 Workspace Management

C***************************************** 

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

C****************************************** 

Chapter 19 APEX Team Development

C****************************************** 

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

What You Can Expect

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
Who Should Take This Course

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.

Recommended 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
Training Style

Instructor Led

Lecture and Hands on Labs

« Hide The Details
Related Courses
Code Course Title Duration Level
OR18SQL
Oracle18c SQL
5 Days
I
Details
OR11E1
Oracle 11g/12c: Express Introduction to SQL and SQL*Plus
3 Days
I
Details
OR11E2
Oracle 11g/12c Express Introduction to SQL, SQL*Plus, and PL/SQL
3 Days
I
Details
OR11D1
Oracle 11g/12c Developer: Introduction to PL/SQL
2 Days
I
Details
OR11E
Oracle 11g/12c Essentials: SQL, SQL*Plus and PL/SQL
5 Days
I
Details
OR11D
Oracle 11g/12c Developer: PL/SQL Complete
5 Days
I
Details
OR11D2
Oracle 11g/12c Developer: Intermediate PL/SQL
3 Days
II
Details
ORPLSA
Oracle 11g Advanced PL/SQL
3 Days
III
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com