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
CONTACT US
+91 9376007676INQUIRY NOW
Oracle Application Express Training
Introduction to Oracle Application Express 5






- Course No : ORC-902
- Theory : 40%
- Lab : 60%
- Duration : 24 hours
All students should have an understanding of Oracle SQL and PL/SQL.