Oracle Application Express: Advanced Workshop |
Oracle University |
Oracle Application Express: Advanced Workshop Duration: 3 Days What you will learn Students attending this workshop enhance their skills in Oracle Application Express. Students examine topics on using application navigation to build site maps and dashboards. In addition, students learn about AJAX and Javascript and how these can be used in an APEX application. Students learn to build a Custom Tabular Form that uses collections and validation, develop their own themes and templates and extend the application in the areas of PDF printing, email notifications, web services, and integrating with other Oracle products such as SQL Developer, Application Server LDAP and SSO. Examining some of the other APIs that are available as well as monitoring and managing your application using custom activity monitoring is also discussed. Learn To: Include application navigation techniques such as Database-Driven report generation, Site Maps, Dashboards and Interactive Report Regions in APEX applications Build custom tabular forms that contain validations and use collections Incorporate JavaScript and AJAX into APEX applications Extend applications using email notifications, using declarative support, incorporating web services and utilizing integration with SQL Developer Print reports within APEX using report queries and report layouts utilizing BI Publisher Integrate APEX application with LDAP and SSO as well as prevent vulnerabilities associated with SQL Injection and Cross-Site Scripting attacks Audience Application Developers Database Administrators Developer Prerequisites Required Prerequisites Oracle Application Express 3.0: Developing Web Applications Oracle Database 11g: SQL and PL/SQL Fundamentals Course Objectives Monitor and manage your application by using custom reports Manage application navigation by using hierarchical lists with images, database-driven navigation, site maps, and dashboards Build custom tabular forms that use collections and validations Manage application content dynamically by using JavaScript and AJAX Copyright © 2009, Oracle. All rights reserved. Page 1 Extend your application to add binary large object (BLOB) data, send email notifications, use Web services, and integrate with SQL Manipulate application content through templates, themes, and style sheets Create reports declaratively and use the print APIs Secure your application by using LDAP and SSO and prevent SQL injection attacks and cross-site scripting and usage of Session
Course Topics Build a Hierarchical List with Images Build a Database Driven Navigation Report Build a Site Map Adding a Dashboard Incorporate Security into Navigation Manipulate Interactive Reports Building Custom Tabular Forms Build a Custom Tabular Form Add Validations to your Tabular Form Manage Changes to the Tabular Form using Collections Using Javascript and AJAX Techniques Incorporating some JavaScript examples into your APEX Application Incorporating some AJAX examples into your APEX Application Extending your Application Adding BLOB Data to your Application Sending Email Notifications Incorporating Web Services into your Application Accessing APEX Application objects in SQL Developer Customizing Themes and Templates Copying and Modifying a template Creating and modifying a theme Using a variety of styles in a template Utilizing Application Express Printing Printing a Standard Report with Derived Output Creating a PDF Report with Multiple Queries Including Dynamic Images in your Report Creating a Report with a Custom XML and XSL Sending a Report as an Email Attachment Creating a Report with a Dynamic Layout Selection Securing your Application Authenticating Users Using LDAP Configuring your Application for Single-Sign On Preventing SQL Injection Attacks Preventing Cross-Site Scripting Using Session State Protection Monitoring and Managing your Application Using Prepackaged Monitoring Capabilities Monitoring Activity of your Application Monitoring Performance of your Application Tuning your Application
Managing Application Navigation
|