دوراتنا

Oracle التطبيق Express: ورشة عمل II

حول هذه الدورة

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

3 أيام

6 محاضرات

تم النسخ
Download Course PDF

دورة المحتوى

  • 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

ذات صلة الدورات

Oracle AI Vector بحث Deep Dive ELS

Discover how Oracle Database 23aitransforms natural language questions into secure,..
يومان

11 Lectures

اكتشف الدورة

Oracle AI Vector Search Fundamentals Live Class

Leverage the key capability of Oracle AI Databaseto design and..
يومان

13 Lectures

اكتشف الدورة

Oracle قاعدة البيانات Appliance Release 18c Overview

This course provides an overview of Oracle Database Appliance Release..
يومان

14 محاضرة

اكتشف الدورة

Oracle Exadata Database Machine: تطبيق و Administration

After completing this course, you should be able to: Describe..
5 أيام

23 Lectures

اكتشف الدورة

XML Fundamentals Ed 1.1

XML Fundamentals Ed 1.1..
يومان

9 Lectures

اكتشف الدورة

Oracle Database 19c: Deploy, Patch, و Upgrade ورشة عمل Live Class

This course helps you learn how to deploy, patch, and..
يومان

12 محاضرة

اكتشف الدورة
ابدأ الآن