Oracle Application Express Workshop II Ed 2

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 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