CMDBID: 63011 | Course Code: QAORAPEX2 | Duration: 2 Days
This level 2 course is for anyone has attended the level 1 course and wants to further develop their skills with Oracle Application Express (APEX)
This course is for people in the roles:
Candidates will learn to:
Generate Form based on Methods on Tables utility.
Create and use RESTful Web Services.
Customise themes and templates.
Create a master application and custom theme.
Migrate an existing application to a responsive theme.
Incorporate interactivity in their application.
Build tabs based on a static list.
Secure their application.
Deploy and maintain their applications.
Optimise their application performance.
Oracle Application Express Workshop I Ed 1
Basic knowledge of SQL, PL/SQL, and HTML
Adding Features to Your Application
Sending E-Mails and attachments
Creating Tabular Forms Manually
User defined Error Handling
Creating Data Load Pages
Introduction to Dynamic Actions
What are Dynamic Actions?
Creating a Set Value Dynamic Action with a SQL Statement
Create a Set Value Dynamic Action Using PL/SQL
Changing the class when an item is null
Disabling a Button When Items are Null
Refreshing the data in a report using custom filters
Introduction to Plug-ins
Identifying the steps to creating and using a plug-in in your Application
Importing a plug-in
Creating a plug-in
Creating Mobile Applications
Add a mobile user interface to a database application
Creating List View
Creating and linking a form to the application
Add a link on the Home page
Use some of the HTML5 item types
Adding a HTML5 chart to your application
Creating Dynamic Content
Understanding Conditional Logic
Dynamic PL/SQL Content
Creating PL/SQL Reports
What are Websheets?
Websheet verses Database Applications
Running the WebsheetPages
Pages and Sections
Incorporating a Text Section
Incorporating a Data Section
Incorporating a Chart Section
Incorporating a PL/SQL Section
Incorporating a Navigation Section
Adding Annotations to a Page
Sharing Websheets with Users
Team Development Functionality
Tracking features, milestones, bugs and to dos
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well
as public sector institutions such as the Department of Defence and the Department of Health.