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

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
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 11g or 12c SQL course or have equivalent experience
  • Completed our five day Oracle 11g or 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
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