Oracle Application Express Workshop II

Course DateLocationDaysPriceRegister
Aug 16, 2017Montreal3 $2,895Register
Oct 25, 2017Montreal3 $2,895Register
Sep 6, 2017Quebec3 $2,895Register
Sep 5, 2017Toronto3 $2,895Register
Nov 13, 2017Toronto3 $2,895Register
Dec 18, 2017Toronto3 $2,895Register
Feb 21, 2018Toronto3 $2,895Register
Apr 4, 2018Toronto3 $2,895Register


Course DateLocationDaysPriceRegister
Sep 6, 2017Live Virtual - 10:00 am Eastern3 $2,760Register
Nov 6, 2017Live Virtual - 9:00 am Eastern3 $2,760Register
Oct 22, 2017Live Virtual - 9:30 pm Eastern3 $2,760Register


Course DateLocationDaysPriceRegister
Self-Paced Learning3 $2,550Register


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.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.Benefits to YouBecause Oracle APEX resides within the Oracle Database and can easily integrate with authentication schemes (like Oracle Access Manager, SSO and LDAP) you can learn to build secure applications that can scale to meet your largest user communities. Attending this workshop will help you build on what you learned in the 5-day Oracle Application Express Workshop I course.Gain Hands-On ExperienceEnrolling in this workshop helps you explore how to use collections, add dynamic actions, use powerful plug-ins to extend functionality in your applications and create and consume a RESTful Web Service. Themes and Templates used in Oracle Application Express (Apex) are also discussed, along with responsive design, which is a recent user interface design principle used in Apex. You'll learn how interactivity can be included in your applications by creating tooltips, scrolling regions and displaying a modal window initiated from a report. This course is 50% lecture and 50% hands-on practices.

Duration: 3 Days

Course Objective:

  • 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

Audience:

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

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

Related Courses:

  • Oracle Application Express Workshop II
  • Instructor Led Training
Course DateLocationDaysPriceRegister
Aug 16, 2017Montreal3 $2,895Register
Oct 25, 2017Montreal3 $2,895Register
Sep 6, 2017Quebec3 $2,895Register
Sep 5, 2017Toronto3 $2,895Register
Nov 13, 2017Toronto3 $2,895Register
Dec 18, 2017Toronto3 $2,895Register
Feb 21, 2018Toronto3 $2,895Register
Apr 4, 2018Toronto3 $2,895Register


Course DateLocationDaysPriceRegister
Sep 6, 2017Live Virtual - 10:00 am Eastern3 $2,760Register
Nov 6, 2017Live Virtual - 9:00 am Eastern3 $2,760Register
Oct 22, 2017Live Virtual - 9:30 pm Eastern3 $2,760Register


Course DateLocationDaysPriceRegister
Self-Paced Learning3 $2,550Register