• Increase font size
  • Default font size
  • Decrease font size
  • default color
  • cyan color
  • red color

Focus Thread Consulting

....focussing on quality solutions

Member Area
Oracle APEX Training Contents PDF Print E-mail
Training - Oracle APEX Training

We are glad to announce our newly launched online Oracle Application Express Training (APEX).

This is a hands-on lab-intensive course conducted on weekends. Our instructor lead trainings are interactive with Practice and Q/A Sessions. We use industry leading Conferencing Software [with integrated VOIP] to provide trainings.


Batch Commencing on: 21 February 2010

Course Fee: USD 399/- [Introductory Price]

Training Duration: 5 Days


Training Schedule: 3, 4, 10, 11 & 17 April 2010


See the Detailed Course Breakdown Below By Scrolling Down




 

Course Contents:

Day 1


Oracle Application Express
– APEX Concepts
– APEX Main Components
– Create a Workspace
– Workspace Administrator
– Log into APEX
– Run an Application

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

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

Pages and Regions
– View Page Definitions
– Edit Page Definitions
– Create a New Region
– View Region Attributes
– Add Comments
– Add a Title
– Add a logo

Hands On
– Create a Workspace
– Explore SQL Workshop, Browse, Create & Modify objects
– Create an Application, Reports, Pages and Regions

Day 2

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

Items and Buttons
– Create Items
– Edit Item Attributes
– Create Buttons
– Edit Button Attributes

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

Hands On
– Create Form
– Add Items, Buttons to Page and Region
– Create Processes and Branches

Day 3

Add Shared Navigation Components
– Shared Components Overview
– Parent and Standard Tabs
– Navigation Bars
– Lists
– Breadcrumbs

Other Shared Components
– Lists of Values
– Trees
– Shared Component Reports
– User Interface Defaults

Display Dynamic Content
– Filter Reports with Dynamic Queries
– Create Charts with a Wizard
– Create a Calendar

Hands On
– Create Shared Components
– Create List of Values, Trees
– Create Charts

Day 4

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

Themes and Templates
– Switch to a Different Theme
– View Existing Templates
– Manage Templates
– Add a Reference to a Cascading Style Sheet

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

Hands On
– Manage Themes
– Monitor Activity
– Manage Users

Day 5

Implement Security
– Authentication and Authorization
– Provide an Authentication Scheme
– Create an Authorization Scheme Using Access Control
– Enable and Configure Session State Protection

Deploy an Application
– Define Supporting Objects
– Package an Application
– Export an Application
– Import an Application
– Install Supporting Objects

Utility Programs
– Import and Export Data
– Generate DDL Statements
– View Objects Reports
– Monitor the Database

Hands On
– Manage Authentication
– Import and Export application/pages/shared components

 

(c)All contents on this website are copyright to FocusThread UK Limited