APEX Training Services

Corporate Training

If your organization is interested in build skills of APEX for in house development then we are well-equipped to make a training course for your people on-site or remote. We can also arrange workshops training and plan to invite some of the best-skilled developers from time to time.

Educational Training

We do provide industrial training to students for their final year training program and co-ops which leads to a successful career in the emerging technology of APEX.

Oracle Application Express Workshop I Ed 2

Introducing Oracle Development Architecture
Application Express Overview
Introducing Oracle Development Architecture
Using Application Express
Basic functions of Administration in Oracle Application Express
About Workspace, Schema
Application Builder Overview
Introducing Database Applications
Creating Database Applications
Creating Mobile Application
Introducing Reports
Using Classic Reports
Using Interactive Reports
Creating and Customizing an Interactive Report
Creating Reports for a Mobile Application
Creating Column Toggle Report
Creating a Reflow Report

Using Forms
Creating Forms
Modifying Forms
Creating a Form in a Mobile Application

Introducing Page Definition
Working with Page Regions
Working with Pages
Introducing Items
Using Items
Creating List of Value (LOV) Type of Items
Using Buttons
Understanding Session State in Oracle Application Express
Using Session State in Oracle Application Express
Introducing Page Processing
Including Computations
Including Processes
Including Validations
Including Branches
Using the Advisor
Managing Your Attribute Dictionary
Debugging Your Application
Introducing Shared Components
Creating Tabs
Creating Lists
Creating Breadcrumbs
Creating a Navigational Bar
Using Themes
Using Templates
Using Files
Securing an Application
Using Authentication Schemes
Using Authorization Schemes
Using Session State Protection
Building a Hierarchical List with Images
Building a Site Map
Enforcing Authorization on Your Site Map
Linking Interactive Reports using a Declarative Filter
Creating and Using Charts
Enhanced Charting Examples
Creating Data Load Wizard Pages
Creating an Upload and Download Page
Adding BLOB Data to an Existing Application
Sending Email from an Application
Using Dynamic Actions
Using Plug-Ins
Using Calendars
Using Trees

What is Team Development?
Managing Feedback

Printing a Standard Report with Derived Output
Creating a PDF Report with Multiple Queries

Oracle Application Express Workshop II Ed 2

Course Objectives
Lesson Schedule
Course Environment: Products Installed
Course Environment: Workspace Details
Accessing the Labs Directory
Introducing Course Persona
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
What is a Collection?
Create a collection on an interactive report
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
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

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
What is ThemeRoller?
Create a theme using the ThemeRoller
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
Application Components
Things to consider
Backups
Application Performance Considerations
Managing Services
Monitoring Activity
Database Configuration Considerations
Monitoring Application Performance
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

Oracle Application Express: Administration Ed 2

Overview
Identifying Pre-installation Tasks
Installing Oracle Application Express
Administering Post Installation Tasks
Installing Oracle REST Data Services
Configuring Oracle REST Data Services in Standalone Mode
Managing Instance and Workspace Administration
Creating Workspaces
Creating Users
Creating Schemas
Managing Existing Workspaces
Configuring Instance Settings
Configuring Security Settings
Configuring Features
Managing Administration Page and Tasks
Managing Services
Creating Users and Groups
Monitoring Activity
Using Dashboards
Managing Service Requests
Managing Session State
Exporting/Importing Workspaces
Managing Public Themes
Monitoring Activity
Managing Announcements
Managing Custom Applications
Learning about the APEX_INSTANCE_ADMIN API
Managing Workspaces
Managing Schemas
Managing Parameters
Managing Instance Administrator Tasks
Administering DBA Tasks
Managing Schemas
Troubleshooting