Oracle Application Express Workshop II Ed 2

Upcoming sessions

No date suits you?

Notify me when a session is added.

  • Duration: 3 days
  • Regular price: $2,895
  • Preferential price: $2,895

Course outline

Reference : D79657GC20

Duration : 3 days

Our scheduled trainings are offered in French. The educational material is in English.

© Oracle

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

Prerequisites

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

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

Contents

Module 1 - Course Overview
  • Course Objectives
  • Lesson Schedule
  • Course Environment: Products Installed
  • Course Environment: Workspace Details
  • Accessing the Labs Directory
  • Introducing Course Persona
Module 2 - Introducing Course Persona
  • Quick Review of What You Already Know
  • Securing Database Applications
  • What is a Packaged Application?
  • Components of Team Development
Module 3 - Workspace Administration
  • Other Components
  • Packaged Application Used in this course
  • Additional Resources
Module 4 - Using Collections
  • What is a Collection?
  • Create a collection on an interactive report
Module 5 - Extending Your Application: Dynamic Actions
  • Adding Dynamic Actions
Module 6 - Extending Your Application: Plug-ins
  • Authentication/Authorization Plug-in Capability
  • Using and Customizing the CSS Bar Chart Plug-In
Module 7 - 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
Module 8 - 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
Module 9 - 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
Module 10 - 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 theme
  • Establishing a Master Application and a Corporate Theme
Module 11 - Developing a New Theme for Your Application Using ThemeRoller
  • What is ThemeRoller?
  • Create a theme using the ThemeRoller
Module 12 - Securing Your Application
  • What Is a Directory?
Module 13 - Oracle Internet Directory
  • Technical Architecture: Overview
  • Authenticating Users by Using LDAP
  • SQL Injection
  • Cross-Site Scripting
  • Browser Security
  • Application Level Security
Module 14 - Deploying and Maintaining Your Application
  • Application Components
  • Things to considerBackups
  • Backups
Module 15 - Optimizing Your APEX Application
  • Application Performance Considerations
  • Managing Services
  • Monitoring Activity
  • Database Configuration Considerations
  • Monitoring Application Performance
Module 16 - 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