Oracle Apex 3.1 - ORA900

Oracle Application Express (APEX), formerly known as HTML DB, is a rapid web application development tool for the Oracle database. Using a web browser, you can develop and deploy professional applications that are both fast and secure. This course will show students how to develop web applications using Oracle Apex. The students will perform many hands-on exercises with various lab sessions.

Below is an example of what you will learn in our Apex class!

Configuring Oracle Apex to use Oracle BI Publisher

Course ID: ORA900

Duration: 5 days

Audience: Web Developers,PL/SQL Developers

Prerequisites: Basic SQL,some PL/SQL helpful
Topics:

Introduction to Apex

• Introduction to Apex
• The Oracle Apex homepage
• The Apex engine and lifecycle
• Apex versions
• Software requirements
• User roles
• Workspaces, schemas, users, and groups

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
• 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
• Introduction to CSS

Page Layout

• Templates
• Page templates
• Substitution strings
• Regions and region templates
• Master pages
• HTML regions

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)
• 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

Creating PDFs

• PDF printing with Apex
• Installing BI Publisher on Windows
• Configuring APEX to work with BI Publisher
• Creating a simple PDF report
• Creating standard master-detail PDF reports
• Using BI Publisher Desktop

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

Appendix A - Installation