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

·       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

 

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