Oracle Application Express

Course Content

1. Oracle Application Express

  • APEX Main Components
  • Create a Workspace
  • Workspace Administrator
  • Log into APEX
  • Run an Application
2. SQL Workshop

  • Browse Objects, Create Objects and Modify Objects
  • Process Ad Hoc SQL Statements
  • Manage Scripts and data
  • Create, Run and Save SQL Queries

3. Build An Application

  • Application Components
  • Create an Application
  • Create an Application from a Spreadsheet
  • Create Reports Using Wizards
  • Edit Report Attributes
  • Add Links to Reports
  • Save Reports in Different Formats
  • Print Reports in Different Format

4. Pages and Regions

  • View Page Definitions
  • Edit Page Definitions
  • Create a New Region
  • View Region Attributes
  • Add Comments
  • Add a Title
  • Add a logo

5. Create Forms

  • Create a Form on a Table with Report
  • Create Forms of Different Types
  • Add a List of Values to a Form

6. Items and Buttons

  • Create Items
  • Edit Item Attributes
  • Create Buttons
  • Edit Button Attributes

7. Page Processing

  • Page Rendering and Page Processing
  • Create Computations
  • Validate Input Data
  • Process Data
  • Create Application Branching

8. Add Shared Navigation Components

  • Shared Components Overview
  • Parent and Standard Tabs
  • Navigation Bars
  • Lists
  • Breadcrumbs

9. Other Shared Components

  • Lists of Values
  • Trees
  • Shared Component Reports
  • User Interface Defaults

10. Display Dynamic Content

  • Filter Reports with Dynamic Queries
  • Create Charts with a Wizard
  • Create a Calendar

11. Session State and Debugging

  • Implement Session State
  • Set a Session State Value
  • Clear the Session State
  • Review the Session State
  • Review the Messages in Debug Mode

12. Themes and Templates

  • Switch to a Different Theme
  • View Existing Templates
  • Manage Templates
  • Add a Reference to a Cascading Style Sheet

13. Administer Apex Workspaces

  • Manage Users
  • Request a Schema or Storage
  • Purge Session State v/s Monitor Developer Activity Log
  • Monitor Workspace Activity
  • View Activity reports

14. Implement Security

  • Authentication and Authorization
  • Provide an Authentication Scheme
  • Create an Authorization Scheme Using Access Control
  • Enable and Configure Session State Protection

15. Deploy an Application

  • Define Supporting Objects
  • Package an Application
  • Export an Application
  • Import an Application
  • Install Supporting Objects

16. Utility Programs

  • Import and Export Data
  • Generate DDL Statements
  • View Objects Reports
  • Monitor the Database
© 2012 S&M Consultants