Oracle Application Express Workshop II

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Oct 17, 202209:0005:00EDTToronto - In Class or by Video Conference3$3,600 USDPurchase


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.

Duration: 3 Days

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.

Audience:

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

Course Objectives:

  • 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

Required 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

oller?
  • 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
    Right Menu IconMENU