Oracle Application Express Workshop II Ed 2

Duration: 3 Days

What you will learn

This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle
Application Express Workshop I course. You’ll examine topics that including learning how to use collections, add
dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service.

Learn To:

Extend Your applications using collections, dynamic application and plug-ins.
Create and use RESTful Web Services.
Make your application accessible.
Customize themes and templates.
Establish a master application and corporate theme that many applications can use.
Migrate an existing application to a new theme.
Incorporate a jQueryUI ThemeRoller theme into your mobile application.
Secure, deploy and maintain your applications.
Optimize your application performance.

Benefits to You

By taking this course, you’ll develop the ability to ensure that the APEX application is accessible. You’ll be able to
determine which theme to use based on the type of application you want to build (desktop, mobile or responsive) as well
as how to customize the templates.
Set Up a Master Template Application
This course will teach you how to set up a Master (Template) Application that contains common regions used as a
starting point. You’ll learn how to build a landing pad page that helps to navigate throughout the application. Expert
Oracle University instructors will help you explore some considerations when upgrading your APEX applications to a
responsive theme while incorporating a new jQueryUI ThemeRoller theme into your existing mobile application.

Audience

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

Related Training

Required Prerequisites
Basic knowledge of SQL, PL/SQL, and HTML
Oracle Application Express Workshop I Ed 2
Suggested Prerequisites
Oracle Database: PL/SQL Fundamentals
Oracle Database: SQL Workshop I

Course Objectives

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
Extend Your applications using collections, dynamic applications, and plug-ins

Course Topics

Course Overview

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

Introducing Course Persona

Introducing Course Persona
Quick Review of What You Already Know
Securing Database Applications
What is a Packaged Application?
Components of Team Development
Workspace Administration
Other Components
Packaged Application Used in this course
Additional Resources

Using Collections

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

Extending Your Application: Dynamic Actions

Adding Dynamic Actions

Extending Your Application: Plug-ins

Authentication/Authorization Plug-in Capability
Using and Customizing the CSS Bar Chart Plug-In

Incorporating Interactivity in Your Application

Tooltip
Scrolling Region
Add buttons with conditions in the report page to display report based on the conditions
Add a procedure in AJAX to refresh a page region periodically
Configuring Oracle Application Express to send email

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

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 Templates

Application Types: Desktop, Mobile, Responsive – Explain what they are and what criteria determines which application to create
Theme Overview: Which ones are for which type of Application
Review the layout of a Page template
Include using CSS to customize the template
Using Substitution Strings in Templates
Utilize new page attributes – files/inline styles
Create and modify a themeEstablishing a Master Application and a Corporate Theme

Developing a New Theme for Your Application Using ThemeRoller

What is ThemeRoller?
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