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

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


Introduction to Oracle Application Express 4

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : ORC-900
  •  Theory : 40%
  •  Lab : 60%
  • Duration : 24 hours
Scroll Up
Skip to toolbar