Introduction to Oracle Application Express 4

 Introduction to Oracle Application Express 4

In Bascom Bridge’s Oracle APEX Training: Introduction to Oracle Application Express 4 training, students learn how to develop web applications from scratch, as well as how to manage database structures and actual data within an Oracle database.

ORACLE APEX TRAINING OBJECTIVES

• Understand the Oracle APEX architecture
• Use SQL Workshop to interface with and manipulate your data
• Build database-centric Web applications using Application Builder
• Create web-based forms and reports
• Secure your web applications
• Deploy your web applications
• Build a Websheet application
• Explore the new features in the latest release of Oracle APEX

ORACLE APEX TRAINING PREREQUISITES

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

ORACLE APEX TRAINING MATERIALS

All students receive comprehensive courseware and a related textbook.

SOFTWARE NEEDED FOR EACH PC:

• One shared APEX environment, running Oracle Application Express 4.2, with a separate APEX account for each student
• This course can be taught using APEX 4.0 or 4.1 upon request.
• 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 TRAINING OUTLINE

• Introduction to Oracle Application Express
  • What is Oracle APEX?
  • Benefits
  • Architecture and Installation
  • Capabilities
  • 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
  • APEX specific design issues
  • From ERD to Tables
• Using SQL Workshop
  • Accessing SQL Workshop
  • Using Object Browser
  • Executing SQL Commands
  • Working with SQL Scripts
  • Using Query Builder
  • Accessing Utilities submenu
  • Using Data Workshop
  • Generating DDL
  • Establishing User Interface Defaults
  • 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
• Basic Forms and Reports
  • Creating a Form
  • Creating a Report
  • Understanding Session State
  • Declarative BLOBs
• Advanced Forms and Reports
  • Pages
  • Developer Toolbar
  • Tabular Forms
  • Interactive Reports
  • Calendar Reports
  • Chart Reports
• Page Controls
  • Items
  • Buttons
  • Validations
  • Computations
  • Processes
  • Branching
  • Dynamic Actions
• Security
  • Overview of Security
  • Authentication
  • Creating a Authentication Scheme
  • Authorization
  • Creating an Authorization Scheme
  • Access Control
  • Session State Protection
• Application Deployment
  • APEX Application Lifecycle
  • Deploying Application
  • Exporting Application
  • Importing Application
  • Cross Application Report
• Additional Developer Tools
  • Application and Page Management
  • APEX Views and APEX Dictionary
  • Searching in APEX
  • Monitoring APEX
  • APEX Advisor
  • Build Options
  • SQL Developer and APEX
  • PL/SQL Refactoring and DML Packages
• APEX Plug-ins
  • Types of APEX Plug-ins
  • Using Plug-ins to enhance the user experience
  • Extensions with authorization and authentication
• APEX  Features
  • End User data uploads
  • Improvements in Error Handling
  • Tabular Form Improvements
  • Mobile App Templates
  • Calendar Improvements
  • Client-side Dynamic Action Support
• Websheets
  • Websheet Page Structure
  • Navigation
  • Help
  • Markup Syntax
  • User Authentication
  • User Authorization
  • Sections
  • Administration
  • Websheet Example
• APEX Workspace Administration
  • Environmental Information
  • Manage Service
  • Managing Users and Groups
  • APEX Instance Administrator
• Team Development
  • Team Development Overview
  • Team Development Interface
  • Features
  • Milestones
  • To Do Items
  • Bugs
  • Feedback
  • News
• Conclusion