Oracle Apex

• SQL
• PLSQL
• HTML/CSS
• JavaScript

• Benefit of Oracle
• History of Oracle

• Oracle APEX Architecture.
• Benefits & History of Oracle APEX.
• APEX useful Resources & Links.

• Installation And Configuration of Oracle APEX
• What is a Workspace?
• APEX Hierarchy (Workspace, Applications, Pages, Regions & Items)

• Creating Workspace
• Manage and Requesting Services
• Create and Manage Users and Groups
• APEX Workspace Components & Attributes Setting
• Understanding different type of users.
• Monitor Activity

• Application Builder Home Page
• Application Builder Defaults
• Types of APEX Applications.
• What is a packaged application? Install various packaged application.
• User Interface
• Defaults Application Groups
• Managing export repository
• Utilities (imp/exp) CSV, Text
• Dynamic Actions
• Validations

• Creating an application from scratch.
• Components of an application.
• Page Definition.
• What is a Page in APEX?
• Controls on a Page.
• Different Sections of a Page.
• Attributes of a Page.
• Create a New Region.
• Different Attributes of a Region.
• Import and Export Application.
• Authentication & Authorization from Database Table.

Role Based Security

• Understanding Themes
• Switching Themes
• Changing Theme Defaults
• Understanding Templates and viewing template definitions

• Computations
• Validations (client side and server side)
• Processes
• Branches

• Types of Reports
• Creating Report with SQL Query
• Toggle Report & Attributes
• Classic Report & Attributes
• Interactive Grid & Attributes
• Interactive Reports & Attributes

Add Links to Reports

• Understanding different Types of Charts.
• Understanding Different Attributes of a Chart.
• Drill down and linked Charts.

• Creating Forms with Report
• Creating Simple Forms
• Creating Tabular Forms
• Editable Interactive Grid
• Creating Master-Detail Forms

• Understand different Types of Items
• Creating Different Types of Items (Text, Text Area, Checkbox, Select List, Radio Group etc.) Edit Item Attributes
• Create and Edit Buttons (Attribute).

• Create Parent and Standard Navigation Menu.
• Create Navigation Bar Entries.
• Create Dynamic and Static Lists of Values.
• Create Breadcrumbs
• Data Load Definition
• Globalization

• Refresh items and regions
• Invoke PL/SQL processes from browser events
• Retrieve data from the DB and set items values.

• How to use Plugins in applications

• Uploading Image
• Uploading Static Files
• Adding an Image as an Application Logo.
• Adding a Reference to a JavaScript File.