In this course, you will learn to: Enhance Your Oracle Application Express Application Add Advanced Functionality to your Application Express Application Make Your Application Express Applications Production Ready
Our Courses
Oracle Application Express: Workshop II
Course Content
- Course Overview
- Agenda
- Roadmap
- Course Environment
- Workspace Details
- Accessing the labs Directory
- Introducing Course Persona: Steve
- Introducing Course Persona: Stella
- Introducing Course Persona: Richard
- Demo Application: Project Tracking System
- Practice Application: GlobalMart Management Tool
- 2 Introduction and Review
- Agenda
- Learning Objectives
- Steve Reviews Oracle Application Express Concepts and PTS Features
- What Is Oracle Application Express?
- Workspace Home Page
- What Is App Builder? The First Component of Oracle Application Express
- What Is SQL Workshop? The Second Component of Oracle Application
- Express
- Accessing SQL Workshop
- Running SQL Commands
- What Is Team Development? The Third Component of
- Oracle Application Express
- What Is App Gallery? The Fourth Component of Oracle Application Express
- Accessing the App Gallery
- What Is a Workspace?
- Defining Roles
- Building Your Database Application
- Components of an Application Page
- Page Designer: The Advanced Web-Based IDE
- Page Designer: Drag and Drop from Gallery
- Page Definition: Overview
- Different Views of a Page
- Oracle Application Express: Other Features
- iii
- Securing Database Applications
- Additional Resources: Application Express OTN Page
- Oracle Learning Library
- Additional Resources: Documentation and Tutorials
- Oracle Application Express Developer Certified Expert
- Practice 2: Overview
- Summary
- 3 Securing Your Application
- Learning Objectives
- Topics
- PTS Scenario
- Understand Preconfigured Authentication Schemes
- Examples: Preconfigured Authentication Schemes
- Social Sign-In: Example
- Social Sign-In: Introduction
- Using Social Sign-In
- Using Social Sign-In Step 1: Create an Application
- Using Social Sign-In Step 2: Configure Google APIs “Project” to use Google
- Authentication
- Using Social Sign-In Step 3: Register your Application
- Using Social Sign-In Step 4: Create Credentials – Client ID and Client Secret
- Using Social Sign-In Step 5: Create Web Credentials
- Using Social Sign-In Step 6: Create Authentication Scheme
- Using Social Sign-In Step 7: Run the Application
- Topics
- Securing PTS – Common Hacking Mechanisms
- What Is Cross Site Scripting (XSS)?
- Preventing Cross-Site Scripting: Example
- SQL Injection: PTS Scenario
- What Is SQL Injection?
- Assessing Vulnerability
- Preventing SQL Injection Attacks Using Bind Variables
- Preventing SQL Injection Attacks: Using Bind Variables
- Quiz
- Topics
- Managing Browser Security
- Specifying Browser Security
- Practice 3: Overview
- Summary
- iv
- 4 Deploying and Maintaining Your Application
- Learning Objectives
- PTS Scenario
- Topics
- Understanding Packaged Application
- Topics
- Understanding Supporting Objects
- Identifying the Supporting Objects for an Application
- Specifying Prerequisites and Other Options
- Specifying Build Options
- Creating Installation Scripts
- Creating Deinstallation Scripts
- Topics
- Deploying an Application
- Step 1: Exporting an Application
- Step 2: Importing an Application
- Step 3: Installing an Application
- Step 4: Publish an Application’s URL
- Step 4: Publish an Application’s URL – Enabling Friendly URL syntax
- Step 4: Publish an Application’s URL – Define Alias for Your Application
- Quiz
- Topics
- Managing Remote Deployment
- Understanding Remote Deployment
- Using One-Click Remote Deployment: Step 1: Create an Application in APEX
- instance 1. Here we used apex.oraclecorp.com.
- Using One-Click Remote Deployment: Step 2:–Enable ORDS and copy Endpoint
- URL of the APEX instance 2 where you want to deploy your application.
- Using One-Click Remote Deployment Step 3:–Use Remote Deployment to export the
- application you created in step 1: Create REST Enabled SQL Service and create
- a new credential
- Using One-Click Remote Deployment Step 4:–Select the REST service and deploy
- your application to instance 2
- Practice 4: Overview
- Summary
- 5 Optimizing Your Application
- Learning Objectives
- Manage Your Services
- Topics
- Manage Service
- v
- Manage Service – Make a Service Request
- Manage Service – Set Workspace Preference
- Manage Service – Edit Announcement
- Manage Service – Workspace Utilization
- Monitoring the Activity of Your Application
- Topics
- Monitoring the Activity of Your Application (Contd.)
- Monitoring the Activity of Your Application
- Monitor Activity – Page Views
- Monitor Activity –Developer View
- Monitor Activity – Sessions
- Monitor Activity – Page View Analysis
- Monitor Activity – Environment
- Monitor Activity – Login Attempts
- Monitor Activity – Application Errors
- Monitor Activity – Workspace Schema and Other Reports
- Monitor Activity – Archived Activity Reports
- Monitoring and Improving the Performance of Your Applications
- Topics
- Monitor and Improve Performance – Database Configurations
- Monitor and Improve Performance – Use Bind Variables
- Monitoring Performance – #TIMING# Substitution String
- Monitor and Improve Performance – Object Reports
- Monitor and Improve Performance – Caching
- Quiz
- Practice 5: Overview
- Summary
- 6 Managing Globalization and Translation
- Learning Objectives
- Topics
- Globalization Attributes
- Accessing Globalization Attributes Page
- Editing the Globalization Attributes Page: Specifying the Attributes
- Topics
- Translating an Application: How Translated Applications Are Rendered?
- Translating an Application: How to Translate an Application?
- Translating an Application: Step 1: Define Application Languages
- Translating an Application: Step 2: Seed Translatable Text
- Translating an Application: Step 3: Download XLIFF Translation Files
- Translating an Application: Step 4: Translate Text
- vi
- Translating an Application: Step 5: Apply XLIFF Translation Files
- Translating an Application: Step 6: Publish Translated Application
- Translating an Application: How to Set the Primary Language of
- an Application?
- Topics
- Translate Messages Used in PL/SQL Region
- Translate Messages Used in PL/SQL Region: Set the Primary Language
- to English
- Translate Messages Used in PL/SQL Region: Create a New PL/SQL Translation
- Region
- Translate Messages Used in PL/SQL Region: Define New Translation Messages
- (English and French)
- Translate Messages Used in PL/SQL Region: Change the Primary Language
- (to French) and Run Application
- Quiz
- Practice 6: Overview
- Summary
Related Courses
Oracle AI Vector Search Deep Dive ELS
Discover how Oracle Database 23aitransforms natural language questions into secure,..
2 Days
11 Lectures
Oracle AI Vector Search Fundamentals Live Class
Leverage the key capability of Oracle AI Databaseto design and..
2 Days
13 Lectures
Oracle Database Appliance Release 18c Overview
This course provides an overview of Oracle Database Appliance Release..
2 Days
14 Lectures
Oracle Exadata Database Machine: Implementation and Administration
After completing this course, you should be able to: Describe..
5 Days
23 Lectures
Oracle Database 19c: Deploy, Patch, and Upgrade Workshop Live Class
This course helps you learn how to deploy, patch, and..