• 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.

Oracle Application Express (Oracle APEX), formerly called HTML DB, is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure.

Developers with limited programming experience can quickly start developing and deploying web applications. APEX is the tool of choice to create web-based, database-centric applications.
Students attending this course, will gain various career opportunities in Apex development

Batch Commencing on: 27 November 2010

Course Fee: USD 399/- [Introductory Price]

Training Duration: 5 Days


Training Schedule:
27, 28 November and 4, 5, 11 December 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