Introduction to Oracle Application Express 5

Introduction to Oracle Application Express 5

Bascom Bridge’s Introduction to Oracle Application Express 5 training teaches attendees how to create small, simple web applications from scratch.  Students also learn how  to move their data (and applications) from a single user environment such as a spreadsheet, or Microsoft Access application, to a database repository.

ORACLE APEX 5 TRAINING OBJECTIVES

All students will:

• Discuss the Oracle APEX architecture
• Use SQL Workshop/Utilities
• Build a database-centric Web application using Application Builder
• Build a Websheet application
• Administer an APPLICATION EXPRESS Workspace
• Use Team Development to manage APEX development projects

ORACLE APEX 5 TRAINING PREREQUISITES

All students should have an understanding of Oracle SQL and PL/SQL.

ORACLE APEX 5 TRAINING MATERIALS

All students receive comprehensive courseware and a related textbook.

SOFTWARE NEEDED FOR EACH PC:

• One shared APEX environment, running Oracle Application Express 5, with a separate APEX account for each student
• Each student computer will need a web browser and Oracle SQL Developer installed.
• Please contact us for detailed setup instructions if you have purchased this class.
• For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

ORACLE APEX 5 TRAINING OUTLINE

• Introduction to Oracle APPLICATION EXPRESS
  • What is Oracle APEX?
  • Benefits
  • APEX History
  • Architecture and Installation
  • Typical APEX Applications
  • Major Components
  • APEX Resources
• From the Developer’s Perspective
  • Workspace Concepts
  • Workspace Login
  • APEX Components
  • Application Builder Overview
  • Demonstration Applications
  • SQL Workshop Overview
• Application Design Requirements
  • Identify system requirements
  • From ERD to Tables
  • APEX specific design issues
• Using SQL Workshop
  • Accessing SQL Workshop
  • Using Object Browser
  • Establishing User Interface Defaults
  • Executing SQL Commands
  • Working with SQL Scripts
  • Using the Utilities
  • Using Data Workshop
  • Generating DDL
  • Managing the Recycle Bin
  • Using Schema Comparison
  • Using About Database
• Application Builder Basics
  • Understand the Basics of Application Builder
  • Application Builder Terms
  • Methods of Creating an Application
  • Editing Application Properties
  • Page Designer Overview
• Basic Forms and Reports
  • Creating a Form
  • Creating a Report
  • Understanding Session State
  • Using Help
  • Declarative BLOBs
• Advanced Forms and Reports
  • Pages
  • Developer Toolbar
  • Tabular Forms
  • Classic and Interactive Reports
  • Calendar Reports
  • Chart Reports
• Page Controls
  • Items
  • Buttons
  • Page Rendering and Processing
  • Validations
  • Computations
  • Processes
  • Branching
• Security
  • Overview of Security
  • Authentication
  • Creating a Authentication Scheme
  • Authorization
  • Creating an Authorization Scheme
  • Access Control
  • Session State Protection
• Application Deployment
  • APEX Application Lifecycle
  • Deployment
  • Export and Import
• Websheets
  • Websheet Page Structure
  • Navigation
  • Help
  • Markup Syntax
  • User Authentication
  • User Authorization
  • Sections
  • Administration
• Additional Developer Tools
  • Page Locking
  • Application and Page Groups
  • APEX Views
  • APEX Views
  • Build Options
  • SQL Developer and APEX
  • PL/SQL Refactoring
  • DML Packages
• APEX Workspace Administration
  • Instance Administration
  • Request Modes
  • Manage Service
  • Manage Metadata
  • Manage Users and Groups
• Team Development
  • Team Development Overview
  • Team Development Interface
  • Milestones
  • Features
  • To Do Items
  • Bugs
  • Feedback
  • News
• APEX APIs
  • APEX APPLICATION
  • APEX_COLLECTION
  • APEX_ERROR
  • APEX_IR
  • APEX_ITEM
  • APEX_MAIL
  • APEX_PLSQL_JOB
  • APEX_UTIL
• Dynamic Actions
  • Dynamic Action Definitions
  • Dynamic Actions in Page Designer
  • Actions
• APEX Plug-ins
  • Types of Plug-Ins
  • Item-type plug-in
  • Region-type plug-in
  • Dynamic action plug-in
  • Process type plug-in
• Conclusion