Oracle Apex Training Course Content Outline :

Introduction to Apex

• Intro
• Architecture
• Versions
• Documentation
• Software Requirements

Getting started

• Application Homepage
• Developer Navigation Bar
• Page Editor
• Page Rendering and Processing
• Shared Components

SQL Workshop

• Browsing, Creating and Modifying Objects
• Issuing adhoc SQL commands
• Processing Ad Hoc SQL Statements
• Managing Scripts
• Creating, Running and Saving SQL Queries

Creating Reports

• Basic Reports
• Report Analysis Pages
• Interactive Reports
• Report and Column Attributes
• Report Layout and Pagination
• APEX ITEM package

Forms

• Master Detail Form
• Generating Primary Keys
• Procedure based Form

Calendars and Charts

• Calendar wizard
• SQL Calendar
• Calendar Attributes
• Date Intervals
• Calendar Links
• Flash Charts
• SVG Charts
• HTML Charts
• Chart Asynchronous Updates

Managing session state

• Session overview
• Page URL Syntax
• Session State Page
• Setting and Getting Session Data
• Clearing Session Data
• Bookmarking Public Pages

Navigation

• Navigation Bars
• Bread Crumbs
• Tab Sets
• Lists
• Trees

Validations and Computations

• Item level validations
• Page level validations
• Custom validations using PL/SQL
• Page Computations

JavaScript and CSS

• JavaScript Overview
• Adding JavaScript to an Application
• Referencing Page Elements with JavaScript
• JavaScript Events
• Cascading Style Sheets Overview
• Uploading and using CSS in Apex

Page Layout

• Page Templates
• Substitution Strings
• Regions
• Page 0

Uploading and Downloading Documents

• Uploading Documents to Apex
• Displaying Uploaded Documents
• Making Documents Available for Download
• Storing Document Attributes
• Storing Documents in Custom Tables

Web Services

• Web Service Overview
• SOAP Simple Object Access Protocol
• WSDL Web Services Description Language
• UDDI Universal Description, Discovery, and Integration
• Creating Web Services from a WSDL
• Creating Web Services Manually
• Displaying Web Service Results

Emailing with Apex

• Configuring Email Settings
• Enabling Network Services for Oracle 11g
• Sending Text and HTML Email
• Sending Email Attachments
• Viewing Email Queue and Logs

Creating PDFs

• PDF Printing with Apex
• Installing BI Publisher
• Configuring Apex to Work with BI Publisher
• Creating Simple PDF Report
• Creating Master-Detail PDF Report
• Using BI Publisher Desktop for Customized PDF Reports

Administering Apex workspaces

• Managing Users
• Provisioning options
• Provisioning a schema
• Provisioning extra workspace storage
• Workspace reports
• Locking workspaces
• Removing workspaces

Security

• Authentication
• Configuring LDAP Authentication
• Authorization
• Creating and Using Access Control Page
• Session State Protection

Using Utilities

• Importing and Exporting Data
• Generating Data Definition Language Statements
• Viewing Object Reports
• Monitoring the Database

Globalization

• Language Preferences
• Translating Applications and Messages
• Language Identification
• Translating Internal Messages

Deploying Applications

• Deployment Options
• Packaged Applications
• Exporting Application Metadata
• Supporting Objects Page
• Exporting Supporting Objects
• Importing an Application