Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
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:
  1. A desktop application with interactive reports
  2. A mobile application with data entry and review capability
  3. 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
Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved