ORACLE Application Express

Workshop II Ed 2

3 days training event

6100-3047

Course Outlines - Download PDF

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 learn how to use collections, add dynamic actions, create and customize plug-ins and create and consume a RESTful Web Service in this course.

Learn To

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.

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

Audience

  • Application Developers

  • Database Administrators

  • System Analysts

  • Project Manager

  • Forms Developer

  • Business Intelligence Developer

  • Web Administrator

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 Environment: Products Installed

  • Course Objectives

  • Introducing Course Persona

  • Lesson Schedule

  • Accessing the Labs Directory

  • Course Environment: Workspace Details

Introducing Course Persona

  • Workspace Administration

  • What is a Packaged Application?

  • Quick Review of What You Already Know

  • Components of Team Development

  • Additional Resources

  • Packaged Application Used in this course

  • Other Components

  • Securing Database Applications

Using Collections

  • Create a collection on an interactive report

  • What is a Collection?

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

  • Add a procedure in AJAX to refresh a page region periodically

  • Add buttons with conditions in the report page to display report based on the conditions

  • Scrolling Region

  • Configuring Oracle Application Express to send email

Generating and Using Table APIs

  • Add a Form to an Application that shows how to add the process that will insert or update

  • the database using the Table API

  • Modify the Table API

  • What is a Table API?

  • Generate a Table API

Creating and Using RESTful Web Services

  • What is a RESTful Web Service?

  • An Example: RESTful Web Service

  • Consuming a RESTful Web Service in an APEX Application

  • Components of a RESTful Web Service

  • Creating a new RESTful Web Service

Using Themes and Templates

  • Application Types: Desktop, Mobile, Responsive - Explain what they are and what criteria

  • determines which application to create

  • Include using CSS to customize the template

  • Review the layout of a Page template

  • Establishing a Master Application and a Corporate Theme

  • Create and modify a theme

  • Theme Overview: Which ones are for which type of Application

  • Using Substitution Strings in Templates

  • Utilize new page attributes - files/inline styles

Developing a New Theme for Your Application Using ThemeRoller

  • What is ThemeRoller?

  • Create a theme using the ThemeRoller

Securing Your Application

  • SQL Injection

  • Oracle Internet Directory

  • Cross-Site Scripting

  • Application Level Security

  • Technical Architecture: Overview

  • What Is a Directory?

  • Authenticating Users by Using LDAP

  • Browser Security

Deploying and Maintaining Your Application

  • Application Components

  • Backups

  • Things to consider

Optimizing Your APEX Application

  • Monitoring Application Performance

  • Monitoring Activity

  • Application Performance Considerations

  • Managing Services

  • Database Configuration Considerations

Globalization and Translation

  • Switching Languages

  • Understanding Application Translation and Globalization Support

  • Translating the Data the Application Uses

  • Translating an Application

  • Localization

  • Specifying the Primary Language for an ApplicationLoading a New Language

TRAINING LOCATIONS

أماكن ومقرات التدريب حول العالم

Dubai

Dubai

Kuala Lumpur

Kuala Lumpur

Tunis

Tunis

Istanbul

Amman

Amman

Sunny resort beach with palm tree at the coast shore of Red Sea in Sharm el Sheikh, Sinai, Egypt, Asia in summer hot. Bright sunny light

Sharm El Sheikh

Ottawa

Ottawa

Paris

Lagos

Lagos

Harare

Harare

Kampala

Kampala

Casablanca

Casablanca