Oracle Application Express (Oracle APEX) is a rapid web application development tool. Use a web browser to develop fast, secure applications. This Developing Web Applications training will help you rapidly develop and deploy a web application using Oracle Application Express. Learn about access control, manage shared components and use the debugger to resolve issues.
Course Contents
Day 1
Maintaining Database Objects Using SQL Workshop
Browse, create and modify database objects using Object browser
Execute SQL scripts using SQL Command and SQL Scripts
Build and save SQL queries using Query Builder
mport and export data using Utilities
Building Database Applications
Discuss the difference between a Database Application and a Websheet Application
Identify the components of a database application
Create a database application from scratch
reate a database application from a spreadsheet
Creating Reports
Identify the types of reports you can create
Create, manipulate and customize interactive reports
Create and modify classic and wizard reports
Creating Forms
Identify the types of forms you can create
Create and modify various types of forms
Day 2
Working with Pages and Regions
View and edit page definitions and attributes
Create and modify a region and subregion
Create a Page Zero
Add page groups and comments
Adding Items and Buttons
Identify different types of items
Create items and edit item attributes
Create and use List of Values
Create buttons and edit button attributes
Understanding Session State and Debugging
Explain how APEX uses session state
View, reference and clear session state values
Review messages in debug mode
Including Page Processing
Explain the difference between page rendering and page processing
Create computations in application pages
Create page processes
Create validations to verify user input
Create branches within a application
Day 3
Building a Websheet Application
Create a Websheet Application
Add a Page to a Websheet Application
Add and manipulate a Data Grid and Report
Add Annotations to a Data Grid
Create a Saved Report of a Data Grid
Add Sections to a Page
Share Websheets using an Access Control List
Using Application and Page Utilities
Use the Advisor to verify your application
Manage defaults using the Attribute Dictionary
Adding Shared Components that Aid Navigation
Explain the use of shared components in an application
Create and edit tabs, navigation bar entries, lists and breadcrumbs
Displaying Dynamic Content
Create and use a dynamic action
Import and use a plugin
Create and modify a chart
Create a calendar
Create a tree
Day 4
Working with Themes, Templates, and Files
Explain what themes and templates are
Create a new theme from the repository and switch to the theme to make current
Create and edit a template
Upload and use a Cascading Style Sheet and an image
Administering Application Express Workspaces
Create a developer and a workspace administrator user
Request a schema or a storage
Monitor the developer activity log
Implementing Security
List the different ways to secure your application
Differentiate between authentication and authorization
Create an authentication scheme for your application
Create an authorization scheme using Access Control
Enable and configure Session State Protection
Deploying Your Application
Identify the supporting objects for your application
Export an application and its supporting objects
Import an application
Install the supporting objects
Managing and Maintaining the Application Development Process
Track Features, Milestones, Bugs and To Dos
Manage Feedback