Welcome to OracleAPEXAcademy
Courses Images
Demo on Request

COURSE

Oracle APEX Workshop-II

For Advance Users

Join this course if you have worked on Oracle APEX Technology

Advance INFORMATION

  • Price : On Email
  • Lessons : 30
  • Length : 30 Hours
  • Level : Basic
  • Category : Development
  • Started : Oct-15
  • Shift : 02

Course Description

Oracle Application Express (APEX) is low-code development environment which can be used to develop different application/websites. Oracle APEX is a real rapid application development tool.

This course is for one who have already have worked on Oracle APEX with all the Basic Fundamentals of Oracle APEX.

In this course you will be brief with advance development in Oracle APEX.

Course Syllabus

Section 1: Introducing Course and Overview

1. Introducing Course
• Quick Review of What You Already Know
• Securing Database Applications
• What is a Packaged Application?
• Components of Team Development
• Workspace Administration
• Other Components
• Packaged Application Used in this course
• Additional Resources
2. Collection and Dynamic Action in Oracle APEX
• What is a Collection?
• Create a collection on an interactive report
• Adding Dynamic Actions
3. Extend your app with plugins and Adding Intractivity in Application
• Authentication/Authorization Plug-in Capability
• Using and Customizing the CSS Bar Chart Plug-In
• Tooltip
• Scrolling Region
• Add buttons with conditions in the report page to display report based on the conditions
• Add a procedure in AJAX to refresh a page region periodically
• Configuring Oracle Application Express to send email
4. Table APIs and REST Services
• What is a Table API?
• Generate a Table API
• Modify the Table API
• Add a Form to an Application that shows how to add the process that will insert or update the database using the Table API
• What is a RESTful Web Service?
• Components of a RESTful Web Service
• An Example: RESTful Web Service
• Creating a new RESTful Web Service
• Consuming a RESTful Web Service in an APEX Application
5. Working with Themes and Templates
• Application Types: Desktop, Mobile, Responsive - Explain what they are and what criteria determines which application to create
• Theme Overview: Which ones are for which type of Application
• Review the layout of a Page template
• Include using CSS to customize the template
• Using Substitution Strings in Templates
• Utilize new page attributes - files/inline styles
• Create and modify a theme
• Establishing a Master Application and a Corporate Theme
6. Developing a New Theme for Your Application Using ThemeRoller
• What is ThemeRoller?
• Create a theme using the ThemeRoller
7. Securing Your Application
• • What Is a Directory?
• Oracle Internet Directory
• Technical Architecture: Overview
• Authenticating Users by Using LDAP
• SQL Injection
• Cross-Site Scripting
• Browser Security
• Application Level Security
8. Deploying and Maintaining Your Application
• Application Components
• Things to consider
• Backups
9. Optimizing Your APEX Application
• Application Performance Considerations
• Managing Services
• Monitoring Activity
• Database Configuration Considerations
• Monitoring Application Performance
10. Globalization and Translation
• Understanding Application Translation and Globalization Support
• Specifying the Primary Language for an ApplicationLoading a New Language
• Translating an Application
• Translating the Data the Application Uses
• Localization
• Switching Languages

Latest Courses

Introduction to SQL

40 Hours Price: On Request

Introduction to Oracle APEX

30 Hours Price: On Request

Advance Oracle APEX

30 Hours Price: On Request