Oracle Application Express Workshop II

COURSE TOPICS

Module 1 : Enhancing Your Oracle APEX Application

• Enhancing Your Oracle Application Express Application
• Introduction and Review
• Practice 2-1: Exploring the Oracle Cloud Infrastructure Console ..
• Practice 2-2: Provisioning an Oracle APEX Service
• Practice 2-3: Accessing Oracle Apex Environment on Oracle Apex Service and Creating Workspace
• Practice 2-4: Creating a User
• Practice 2-5: Add Schemas in the Workspace
• Practice 2-7: Installing a Sample Dataset
• Practice 2-6: Import Project Tracking System Application
• Practice 2-7: Import Global Mart Management Tool Applicaiton
• Using Oracle Application Express Collections
• Practice 3-1: Creating and Updating a Collection
• Practice 3-2: Accessing a Collection
• Using Dynamic Actions
• Practice 4-1: Creating Advanced Dynamic Actions_Part01
• Practice 4-1: Creating Advanced Dynamic Actions_Part02
• Incorporating Interactivity in Your Application
• Practice 5-1: Using jQuery to Animate and Customize a Modal Dialog
• Practice 5-2: Using JavaScript to Implement an Auto Scroll Region in a Report
• Practice 5-3: Implementing Client Validation in an Interactive Grid
• Practice 5-4: Implementing Advanced Delete option in an Interactive Grid
• Sending Email from an Application
• Enhancing Your Oracle APEX App

Score 80% or higher to pass

Module 2 : Adding Advanced Functionality to your APEX Application

• Generating and Using Table APIs
• Practice 3-1: Generating and Using Table APIs
• Working with RESTful Services and Web Source Modules
• Practice 4-1: Creating RESTful Services
• Practice 4-2: Creating and Consuming Web Source Modules
• Using Templates and Themes
• Practice 5-1: Copying and Customizing a Button Template
• Practice 5-2: Creating a Custom Theme
• Practice 5-3: Creating an Application Using Custom Theme
• Using Faceted Search
• Creating a Faceted Search Page
• Practice 6-1: Creating a Faceted Search Enabled Report Using Create Page Wizard
• Practice 6-2: Creating an Application with Faceted Search Enabled Report Using Create Application Wizard
• Adding Advanced Functionality to your APEX App

Score 80% or higher to pass

 Module 3 : Making Your APEX Apps Production Ready

• Securing Your Application
• Practice 3-1: Preventing SQL Injection Attacks
• Deploying and Maintaining Your Applicati
• Practice 4-1: Identifying and Creating Supporting Objects
• Practice 4-2: Deploying an Application
• Optimizing Your Application
• Practice 5-1: Monitoring Activity and Performance of the GMT Application
• Managing Globalization and Translation
• Practice 6-1: Translating the GMT Application
• Practice 6-2: Specifying the Primary Language for the Translated GMT Application
• Practice 6-3: Translating Messages Used in the PL/SQL Region
• Making Your APEX Apps Production Ready

Score 80% or higher to pass