1Z0-771: Oracle Application Express (APEX)

Getting started with APEX

• The application homepage

• Sample application

• Developer navigation bar

• Page editor

• Page rendering

• Page processing

• Shared components

• Page editor views

SQL Workshop

• Using the Object Browser

• Issuing ad hoc statements

• Maintaining the SQL scripts repository

Creating reports

• Creating reports

• Basic reports

• Running your first report

• Report analysis pages

• Interactive reports

• Enhanced interactive reports

• Report and column attributes

• Layout and pagination

• The APEX_ITEM package

Creating forms

• Introduction to forms

• Master-detail forms

• Generating a primary key

• Form page options

• Running a master-detail form

• Procedure-based forms

Calendars and charts

• Creating calendars

• Calendar attributes

• Date intervals

• Column and day links

• HTML, SVG, and Flash charts

• Asynchronous updates

Managing session state

• What is a session?

• Understanding page URLs

• The Session State page

• Setting and getting session data

• Clearing session data

• Bookmarking pages

Navigation

• Overview of navigation

• Navigation bars

• Bread crumbs

• Tabsets

• Lists

• Trees

Validations and computations

• Validations and computations

• Item-level validations

• Regular expressions

• Page-level validation

• Creating components

JavaScript and CSS

• What is JavaScript?

• Adding JavaScript to an application

• Referencing HTML items with JavaScript

• Dynamic drop-down menus

• JavaScript events

• Dynamic Actions

• Introduction to CSS

Page Layout

• Templates

• Page templates

• Substitution strings

• Regions and region templates

• Subregions

• Master pages

• HTML regions

Web sheets

• Application Controls

• Search

• Section Content

• Page controls

• View and access related pages

• Annotations

• Data Visualization

• Data Grids

• Data grid inline editing

• History

• Administration

Uploading and downloading documents

• Uploading and downloading documents

• Creating report of uploaded documents

• Storing document attributes

• Storing documents in a customized table

• Downloading documents from a customized table

Web services

• What is a web service?

• SOAP (Simple Object Access Protocol)

• WSDL (Web Services Description Language)

• UDDI (Universal Description Discovery and Integration)

• Support for RESTful web services

• Creating web service references

• Deplaying web service results

Emailing with APEX

• Configuring email settings

• Enabling network services with Oracle 11g

• The APEX_MAIL package

• Sending email from APEX

• Adding email attachments

• Viewing the email queue and logs

• Pushing the email queue

Plugins

• Item Type Plug-Ins

• Region Type Plug-Ins

• Process Type Plug-Ins

• Dynamic Action Type Plug-Ins

• Community Plug-In Repositories

Administering workspaces

• Creating a workspace

• Managing developers and users

• Exporting and importing workspaces

• Granting a new workspace

• Locking a workspace

• Managing storage and schema reports

• Workspace reports

Security

• Authentication

• Configuring LDAP authentication

• Authorization

• Access Control page

• Session state protection

Using Utilities

• Unloading data from a table

• Loading spreadsheet data into a table

• Generating application DDL

• Viewing object reports

• The recycle bin

• Other utilities

Globalization

• Language preferences

• Translating applications

• Language Identification

• Translating messages

• Translating internal messages

Deploying applications

• Deploying an application

• Deployment options

• Packaged applications

• Exporting application metadata

• Supporting objects

• Exporting supporting objects

• Importing an application