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.

Linux Training >

Events >