Application Express Workshop II

Course Fees: $3219.00 excl. GST
Printed Manual: $0.00 excl. GST
Course Duration: 3 days
Course Manual

Sorry, no course dates found

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 You

  • Because 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 Experience

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

Participate in Hands-On Exercises

  • This course consists of 50% interactive instruction and 50% hands-on practices. Furthermore, you'll also learn how interactivity can be included in your applications by creating tooltips, scrolling regions and displaying a modal window initiated from a report.
  • Application Developers
  • Business Intelligence Developer
  • Database Administrators
  • Forms Developer
  • Project Manager
  • System Analysts
  • Web Administrator
Basic knowledge of SQL, PL/SQL, and HTML; Oracle Application Express Workshop I
  • 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
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