Oracle Application Express: Advanced Workshop

Total time

Oracle Application Express: Advanced Workshop

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

This product does not have fixed starting dates and/or places.

Description

This workshop helps the participants to build on what they learned in the 5-day Oracle Application Express: Developing Web Applications course. Topics such as application navigation and content, Plug-ins and how they can be used in the APEX application are examined. Participants learn to define complex client-side behavior by making use of dynamic actions. In addition, how to build a Custom Tabular Form that uses collections and validations is discussed.

Participants learn to extend their application in the areas of adding BLOB data, PDF printing, and Web services in addition to copying and modifying templates,creating and modifying a new theme. Knowledge on some of the advanced charting tec…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: .

This workshop helps the participants to build on what they learned in the 5-day Oracle Application Express: Developing Web Applications course. Topics such as application navigation and content, Plug-ins and how they can be used in the APEX application are examined. Participants learn to define complex client-side behavior by making use of dynamic actions. In addition, how to build a Custom Tabular Form that uses collections and validations is discussed.

Participants learn to extend their application in the areas of adding BLOB data, PDF printing, and Web services in addition to copying and modifying templates,creating and modifying a new theme. Knowledge on some of the advanced charting techniques is also shared. Examining some of the other APIs that are available as well as monitoring and managing the application using custom activity monitoring is discussed. This course is 50% lecture and 50% practices.

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
  • Use Dynamic Actions, Plug-ins, and advanced charting techniques
  • Extend applications to use binary large object (BLOB) data and Web Services
  • Print reports within APEX using report queries and report layouts utilizing BI Publisher
  • Integrate APEX application with LDAP as well as prevent vulnerabilities associated with SQL Injection and Cross-Site Scripting attacks

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.


Audience
  • Application Developers
  • System Analysts
  • Developer
  • PL/SQL Developer
  • Business Analysts
  • Technical Consultant
  • Business Intelligence Developer
  • Forms Developer

Course Topics Managing Application Navigation
  • Building a Hierarchical List with Images
  • Building a Database Driven Navigation Report
  • Building a Site Map
  • Adding a Dashboard
  • Incorporating Security into Navigation
  • Manipulating Interactive Reports
  • Managing Feedback
Building Custom Tabular Forms
  • Building a Declarative Tabular Form
  • Building a Tabular Form Manually
  • Adding Validations to your Tabular Form
  • Managing Changes to the Tabular Form using Collections
Defining Client-Side Behaviors
  • Examining the two types of Dynamic Actions
  • Creating Advanced Dynamic Actions to define complex Client-Side Behavior
  • Changing the Class When an Item Is Null
  • Disabling a Button When an Item Is Null
  • Highlighting an Item When the Value of Another Item Changes
  • Setting the Value of an Item When Another Item Changes
  • Deleting and Re-Creating a Row in a Report
  • Refreshing the Data in a Report Using Custom Filters
Creating and Customizing Plug-ins
  • Identifying the Steps to Creating and Using Plug-in in your Application
  • Importing a Plug-in
  • Importing and Using the Star Rating Item Type Plug-in
  • Importing and Using the Notification Dynamic Action Plug-in
  • Optimizing the Performance of your Plug-ins
  • Creating and Using a Send E-mail Process Type Plug-in
Extending Your Application
  • Adding binary large object (BLOB) data to your Application
  • Incorporating Web Services into your Application
  • Creating and Using a RESTful Web Service
  • Exposing a Report Region as a RESTful Web Service
  • Accessing Application Express 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
  • Creating a Report with a Dynamic Layout Selection
Advanced Charting Techniques
  • Building different types of Charts
  • Creating a multiseries 3D Column chart
  • Creating a Combined Chart
  • Creating and Customizing a Project Gantt Chart
  • Creating and Customizing a Gauge Chart
  • Creating a Map and Associating Data with the Map
Securing your Application
  • Authenticating Users Using LDAP
  • 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

Course Objectives
  • 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
  • Define Client-Side behaviors by using Dynamic Actions
  • Import, use Plug-ins and optimize the performance of Plug-ins
  • Extend applications by adding BLOB data, and incorporating Web services
  • Print reports within APEX using report queries and report layouts utilizing BI Publisher
  • Utilize advanced charting techniques in Application Express
  • Manipulate application content through templates, themes, and style sheets
  • Secure your application by using LDAP and prevent SQL injection attacks and cross-site scripting and usage of Session State Protection
  • Monitor and manage your application by using custom reports

There are no reviews yet.

    Share your review

    Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

    There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.