Oracle Application Express:
Developing Web Applications Course
Module 1: Maintaining Database Objects Using SQL Workshop
• Browse, create and modify database objects using the 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
Module 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
Module 3: Creating Reports
• Identify the types of reports you can create
• Create, manipulate and customize interactive reports
• Create and modify classic and wizard reports
Module 4: Creating Forms
• Identify the types of forms you can create
• Create and modify various types of forms
Module 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
Module 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
Module 7: Understanding Session State and Debugging
• Explain how APEX uses session state
• View, reference and clear session state values
• Review messages in debug mode
Module 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
Module 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
Module 10: Using Application and Page Utilities
• Use the Advisor to verify your application
• Manage defaults using the Attribute Dictionary
Module 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
Module 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
Module 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
Module 14: Administering Application Express Workspaces
• Create a developer and a workspace administrator user
• Request a schema or a storage
• Monitor the developer activity log
Module 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
Module 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
Module 17: Managing and Maintaining the Application Development Process
• Track features, milestones, bugs and to-dos