Сhat now
Training Center MUKКурсыOracleDatabaseOracle Application Express Workshop II Ed 2

Oracle Application Express Workshop II Ed 2

Course code
Orcl_App
Duration
3 Days, 24 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview

Course overview

This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle Application Express Workshop I course. You’ll examine topics that including learning how to use collections, add dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service.

Objectives

Course Objectives

  • 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
  • Extend Your applications using collections, dynamic applications, and plug-ins
Prerequisites

Suggested Prerequisite

  • Basic knowledge of SQL, PL/SQL, and HTML

Required Prerequisite

  • Oracle Application Express Workshop I Ed 2

Audience

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

Course Topics

1. Course Overview

  • Course Environment: Products Installed
  • Course Objectives
  • Introducing Course Persona
  • Lesson Schedule
  • Accessing the Labs Directory
  • Course Environment: Workspace Details

2. Introducing Course Persona

  • Workspace Administration
  • What is a Packaged Application?
  • Quick Review of What You Already Know
  • Components of Team Development
  • Additional Resources
  • Packaged Application Used in this course
  • Other Components
  • Securing Database Applications

3. Using Collections

  • Create a collection on an interactive report
  • What is a Collection?

4. Extending Your Application: Dynamic Actions

  • Adding Dynamic Actions

5. Extending Your Application: Plug-ins

  • Authentication/Authorization Plug-in Capability
  • Using and Customizing the CSS Bar Chart Plug-In

6. Incorporating Interactivity in Your Application

  • Tooltip
  • Add a procedure in AJAX to refresh a page region periodically
  • Add buttons with conditions in the report page to display report based on the conditions
  • Scrolling Region
  • Configuring Oracle Application Express to send email

7. Generating and Using Table APIs

  • Add a Form to an Application that shows how to add the process that will insert or update the database using the Table API
  • Modify the Table API
  • What is a Table API?
  • Generate a Table API

8. Creating and Using RESTful Web Services

  • What is a RESTful Web Service?
  • An Example: RESTful Web Service
  • Consuming a RESTful Web Service in an APEX Application
  • Components of a RESTful Web Service
  • Creating a new RESTful Web Service

9. Using Themes and Templates

  • Application Types: Desktop, Mobile, Responsive – Explain what they are and what criteria determines which application to create
  • Include using CSS to customize the template
  • Review the layout of a Page template
  • Establishing a Master Application and a Corporate Theme
  • Create and modify a theme
  • Theme Overview: Which ones are for which type of Application
  • Using Substitution Strings in Templates
  • Utilize new page attributes – files/inline styles

10. Developing a New Theme for Your Application Using ThemeRoller

  • What is ThemeRoller?
  • Create a theme using the ThemeRoller

11. Securing Your Application

  • SQL Injection
  • Oracle Internet Directory
  • Cross-Site Scripting
  • Application Level Security
  • Technical Architecture: Overview
  • What Is a Directory?
  • Authenticating Users by Using LDAP
  • Browser Security

12. Deploying and Maintaining Your Application

  • Application Components
  • Backups
  • Things to consider

13. Optimizing Your APEX Application

  • Monitoring Application Performance
  • Monitoring Activity
  • Application Performance Considerations
  • Managing Services
  • Database Configuration Considerations

14. Globalization and Translation

  • Switching Languages
  • Understanding Application Translation and Globalization Support
  • Translating the Data the Application Uses
  • Translating an Application
  • Localization
  • Specifying the Primary Language for an ApplicationLoading a New Language
Request the training
Oracle Application Express Workshop II Ed 2
Course code:
Orcl_App
Duration:
3 Days, 24 Acad. Hours
Apply
Сhat now
Свяжитесь со мной
Сhat now
Отправить заявку
Registration for the webinar
Отправить заявку
Your application has been received! We will contact you soon.