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






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