Oracle Application Express Workshop II

Description: This Oracle Application Express Workshop II will help you extend your skills with Oracle Application Express. Learn to extend your applications using collections, dynamic applications and plug-ins.

Duration: 3 Days

Learn to:

• Generate Form based on Methods on Tables utility.
• Create and use RESTful Web Services.
• Customize themes and templates.
• Create a master application and custom theme.
• Migrate an existing application to a responsive theme.
• Incorporate interactivity in your application.
• Build tabs based on a static list.
• Secure your application.
• Deploy and maintain your applications.
• Optimize your application performance.

Audience:

• Project Manager
• Database Administrators
• Application Developers
• Web Administrator
• System Analysts
• Business Intelligence Developer
• Forms Developer

Course Objectives:

• Create and use RESTful Web Services
• Generate Form based on Methods on Tables utility
• Make your application accessible
• Customize themes and templates
• Incorporate Interactivity in your application
• Build tabs based on a static list
• Extend your applications using collections, dynamic applications, and plug-ins
• Secure your application
• Deploy and maintain your applications

Required Prerequisites:

• Basic knowledge of SQL, PL/SQL, and HTML

Topics: Course Overview

Course Objectives

• Lesson Schedule
• Course Environment: Products Installed
• Course Environment: Workspace Details
• Accessing the Labs Directory

Introducing and Review

• Quick Review of What You Already Know
• Packaged Application Used in this course
• Additional Resources

Using Collections

• What is a Collection?
• Create a collection on an interactive report

Generating and Using Table APIs

• What is a Table API?
• Generate a Table API
• Modify the Table API
• Add a Form to an Application that shows how to add the process that will insert or update the database using the Table API

Extending Your Application: Dynamic Actions

• Process a Modal Window using Dynamic Actions
• Delete a Row in a Report using Dynamic Actions

Extending Your Application: Plug-ins

• Import and use region type plug-ins, such as Big Value List, CSS Bar Chart
• Optimize the performance of your plug-ins

Creating and Using RESTful Web Services

• What is a RESTful Web Service?
• Components of a RESTful Web Service
• An Example: RESTful Web Service
• Creating a new RESTful Web Service
• Consuming a RESTful Web Service in an APEX Application

Using Themes and Template

• Application Types: Desktop, Mobile, Responsive
• Theme Overview: Which ones are for which type of Application
• Review the layout of a Page template
• Using Substitution Strings in Templates
• Review a page that contains a report and review the region template and then the report template
• Create and modify a theme
• Switch to the Custom Theme

Making Your Application Accessible

• What is Web Accessibility?
• Accessibility Modes
• About VPAT
• Areas in an Application that need to be accessible
• Testing Application to identify accessibility issues
• Show an example of an accessible app and what features make it so

Incorporating Interactivity in Your Application

• Tooltip
• Scrolling Region
• Modal Region

Building Tab Drop Down as Dynamic/Static List

• Show how to create the Tab structure using a List

Securing Your Application

• What Is a Directory?
• Oracle Internet Directory
• Technical Architecture: Overview
• Authenticating Users by Using LDAP
• SQL Injection
• Cross-Site Scripting
• Application Level security
• Restricted Characters - at the item level

Deploying and Maintaining Your Application

• Application Components
• Things to consider
• Backups

Optimizing Your APEX Application

• Application Performance Considerations
• Managing Services
• Monitoring Activity
• Database Configuration Considerations
• Monitoring Application Performance

oller?

Create a theme using the ThemeRoller

Securing Your Application

• What Is a Directory?
• Oracle Internet Directory
• Technical Architecture: Overview
• Authenticating Users by Using LDAP
• SQL Injection
• Cross-Site Scripting
• Browser Security
• Application Level Security

Deploying and Maintaining Your Application

• Application Components
• Things to consider
• Backups

Optimizing Your APEX Application

• Application Performance Considerations
• Managing Services
• Monitoring Activity
• Database Configuration Considerations
• Monitoring Application Performance

Globalization and Translation

• Understanding Application Translation and Globalization Support
• Specifying the Primary Language for an ApplicationLoading a New Language
• Translating an Application
• Translating the Data the Application Uses
• Localization
• Switching Languages