Oracle Application Express 3.1 Training (Apex)

Duration: 4 days

Audience: Web developers wishing to quickly develop and deploy functional websites using Oracle as a back-end data source.

Prerequisites: Basic knowledge of SQL, some HTML is helpful but not required.

Course outline:

• Introduction to Oracle Apex 3.1
• Intro
• Architecture
• Versions
• Documentation
• Software Requirements
  
• Getting started
• Application Homepage
• Developer Navigation Bar
• Page Editor
• Page Rendering and Processing
• Shared Components
• Page Layout
• Page Templates
• Substitution Strings
• Regions
• Page 0 (Master page)
  
• 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
  
• JavaScript and CSS
• JavaScript Overview
• Adding JavaScript to an Application
• Referencing Page Elements with JavaScript
• JavaScript Events
• Cascading Style Sheets (CSS) Overview
• Uploading and using CSS in Apex
• 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
  
• Security
• Authentication
• Configuring LDAP Authentication
• Authorization
• Creating and Using Access Control Page
• Session State Protection
  
• 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
  
• Installing Oracle Apex & BI Publisher (Appendix)