Course code Title Language Price # Unit Startdate Hour Enddate Location Signup
OR2346 Oracle APEX advanced on your request on your request Contact Us

Oracle APEX advanced

Oracle APEX advanced

Overview

Course code: 
OR2346
Duration: 
2
Time Unit: 
Day(s)
Overview: 

This course will allow you to build more professional and customized applications. During this course you will create your own application making use of the most important APEX and non-APEX features to enhance the APEX look and feel, security, reporting,....

Topics

Topics: 

1-STARTING UP A PROJECT
WORKING WITHIN AN APEX PROJECT
• WHEN TO USE APEX?
• SET UP A DEVELOPMENT ENVIRONMENT
• TEAM
• STANDARDS AND GUIDELINES
• DEVELOPMENT WITHIN A PROJECT
• INCREMENTAL ITERATIVE DEVELOPMENT
• PROTOTYPING
• REUSE
• VERSION MANAGEMENT
• OTAP
WORKING WITH APEX IN A DIFFERENT ENVIRONMENT
• WHAT IS SAAS?
• EXAMPLES OF SAAS
• SAAS WITH APEX
• BI WITH APEX
• WHAT IS NOT POSSIBLE WITH APEX?
• USING AND OFFERING WEBSERVICES
2-DESIGN AN APPLICATION

SECURITY AND AUDITING
• SECURITY WITHIN APEX
• LIGHTWEIGHT DIRECTORY ACCESS PROTOCOL
• STANDARD APEX SECURITY
• DATABASE AUTHENTICATION
• SINGLE SIGN-ON
• WHICH SECURITY IS BEST?
• CREATE YOUR OWN SECURITY
• IMPLEMENT SECURITY
• VIRTUAL PRIVATE DATABASE (VPD)
• APEX IMPORT/EXPORT IN DETAIL
USABILITY AND USER INTERFACE
• HOW WORKS A WEB APPLICATION?
• DIFFERENCES WITH CLIENT/SERVER
• STANDARD APEX LOOK AND FEEL
• TEMPLATES AND THEMES
• CSS
• SCREENFLOWS
• USE-CASE BASED DESIGNS
• JAVASCRIPT INTEGRATION
• AJAX IMPLEMENTATION
• INTERACTIVE REPORTS
• ADVANCED USER INTERFACE OPTIONS
• USER INTERFACE LIMITATIONS
• TEAM DEVELOPMENT IN DETAIL
• INSTALLING AND USING PLUG-INS
• MOBILE APPLICATIONS
3-BUILDING APPLICATIONS

BEST PRACTICES AND TIPS AND TRICKS

WORKING WITH COLLECTIONS

REPORTING
• PDF PRINTING
• BI PUBLISHER
• APACHE FOP
• JASPER REPORTS
• XSL-FO
• SCALABLE VECTOR GRAPHICS (SVG)

ERROR HANDLING AND BUSINESS RULES
• STANDARD APEX ERROR HANDLING
• IMPLEMENT YOUR OWN ERROR HANDLING
• BUSINESS RULES

TESTING AN APEX APPLICATION
• REGRESSION WITHIN APEX
• DEBUGGING IN APEX
• DEBUGGING PL/SQL
• DEBUGGING JAVASCRIPT/CSS/HTML
• UNIT TESTING
• TESTING SECURITY
• APEX ADVISOR

THE APEX LABYRINTH
• THE THEORY OF THE THICK DATABASE
• THICK DATABASES AND APEX
• INCREASE MANAGEABILITY

PERFORMANCE

CREATING REUSABLE COMPONENTS

MULTILANGUAGE APPLICATIONS

USING DICTIONARY VIEWS

USING APEX INTERNALS (EG CREATE_ITEM)

APEX API’S

INTEGRATION WITH OTHER APPLICATIONS AND TECHNOLOGIES
• JQUERY
• ORACLE TEXT
• GOOGLE

Prerequisites

Prerequisites: 

• Knowledge of SQL,PL/SQL and APEX environment
• Course OR2069 : Oracle : SQL Basics or equivalent knowledge
• Course OR2071 : Oracle : PL/SQL Fundamentals or equivalent knowledge
• Course OR2345 : Oracle : APEX Fundamentals or equivalent knowledge

Audience

Audience: 

Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
• Application designers and developers