TMNA CTS Training Portal

Oracle Application Express: Developing Web Applications

Request a Quote for this class

About this Course

Oracle Application Express Release 4.1 further streamlines the development of database-centric Web applications. In this course, you'll learn to rapidly develop a Web application and then deploy using Oracle Application Express.

Audience Profile

  • Application Developers
  • Technical Consultant
  • System Analysts
  • Business Intelligence Developer
  • Forms Developer
  • Developer

At Course Completion

Upon completing this course, students will be able to:

  • Incorporate shared components into an application.
  • Use SQL Workshop to create and manage database objects.
  • Maintain and monitor access to an application.
  • Manage the Application Development process.
  • Use the application builder to create and modify an application.
  • Secure an application by restricting access to users.
  • Deploy an application from a development environment to a production environment.
  • Create various components of an application using the multiple wizards availabe
  • Develop database and websheet applications
  • Deploy the Application as a Packaged Application
  • Debug your application
  • Utilize dynamic components such as dynamic actions and plugins
  • Manage Access Control by authorizing and authenticating users
  • Utilize Team Development to drive the application development process
  • Utilize and Manage Shared Components in an Application
  • Add Page Processing components
  • Manage database objects
  • Administer Oracle Application Express Workspaces
  • Load and Unload data or application components
  • Manage users and groups
  • Build queries of database objects and incorporate in an application
  • Use and manipulate reports and forms in Oracle Application Express

Course Outline

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
  • Import and export data using Utilities

2. 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

3. Creating Reports

  • Identify the types of reports you can create
  • Create, manipulate and customize interactive reports
  • Create and modify classic and wizard reports

4. Creating Forms

  • Identify the types of forms you can create
  • Create and modify various types of forms

5. 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

6. 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

7. Understanding Session State and Debugging

  • Explain how APEX uses session state
  • View, reference and clear session state values
  • Review messages in debug mode

8. 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

9. 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

10. Using Application and Page Utilities

  • Use the Advisor to verify your application
  • Manage defaults using the Attribute Dictionary

11. 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

12. 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

13. 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

14. Administering Application Express Workspaces

  • Create a developer and a workspace administrator user
  • Request a schema or a storage
  • Monitor the developer activity log

15. 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

16. Deploying Your Application

  • Identify the supporting objects for your application
  • Export an application and its supporting objects
  • Import an application
  • Install the supporting objects

17. Managing and Maintaining the Application Development Process

  • Track Features, Milestones, Bugs and To Dos
  • Manage Feedback