Advanced Programming using Oracle Application Express

Octalsoft offers programs in alliance with global IT software vendors to make you certified specialist. Octalsoft premium alliance with leading software houses allow globally recognized certification programs with these vendors.

"Advanced Oracle Application Express" is an obvious next step to our basic training on "Developing Applications with Oracle Application Express"

Introduction:-

Oracle Application Express (Oracle APEX) is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure. In this course you will be introduced to rapid web application development using Oracle APEX. You also learn advance programming concepts and deployment techniques. The course will help you understand best practices that you can apply at your work and in real world Oracle APEX based applications.

Duration: 4 days

Advanced Oracle Application Express Program Contents:

Introduction to Application Express

•     Key features of Application Express
•     Using the Query Builder
•     Using the SQL Script Repository
•     Query the Data Dictionary
•     Data Import/Export Utility
•     Using other Application Express Utilities
•     Introduction to Application Builder
•     Creating an application from scratch
•     Creating an application using Spreadsheet data
•     Review sample Applications

•     Creating Forms and Reports
•     Create a Report Using a Wizard
•     Interactive Reports
•     Advance reporting techniques
•     Export a Report as a CSV or XML file
•     Enhanced Report Printing, PDF download and BI Publisher
•     Build a Master/Detail Form
•     Procedure based Form
•     Dynamic PL/SQL with APEX
•     APEX ITEM Package

Advance Concepts, Administration and Deployment

•     Working with CLOBs and BLOBs (Uploading and Downloading techniques)
•     Advance Programming concepts
•     Web Services
•     Using Application Express APIs
•     Import and Export Your Application
•     Managing Workspaces and Repository
•     Review Application Express report

Application Security

•     Creating and managing users
•     APEX Authentication and Authorization
•     Monitoring Workspace and Development activity

APEX Best Practices

•     Debugging / Troubleshooting
•     APEX in a DEV, TEST and PROD Environment
•     Version Control Management
•     Custom Themes
•     Design Communication

Audience:

An excellent course for anyone who wants to learn advanced skills in Oracle Application Express and create feature rich applications in APEX. Administrator, Application Developers, Database Administrators, Web Administrator  and users who write applications and procedures that Oracle Application Express.

Pre Requisites:

Following are the suggested pre-requisites for this course.

• Basic understanding of database objects (tables, views, sequences, triggers, constraints etc.)
• Basic knowledge of Oracle Application Express
• Basic knowledge of SQL, PL/SQL, HTML & JavaScript

If you are not sure whether you should be doing this course, contact us and we will schedule a one-to-one discussion with you to understand your requirements and advise you.