Course Topics on 

Oracle Application Express (APEX): Developing Web Applications (40 Hours)

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
• Import 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
• Create 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

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

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 

Upcoming Schedule on APEX Batch: