KT-5520 Introduction to Oracle Application Express (APEX) Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Introduction to Oracle Application Express (APEX)


Description: 

Product Overview

  • Target audience
  • Product features
  • Development approach
  • Product architecture
  • Concepts - workspaces and applications
  • The Application Express user interface
  • Navigating in the product
  • Item Finder search tool
  • Running an application

SQL Workshop

  • The Object Browser
  • Creating and browsing database objects
  • Query Builder
  • Executing SQL commands
  • Creating and running scripts
  • Creating database objects
  • Defining user interface defaults

Utilities

  • Importing data
  • Exporting data
  • Database Monitor
  • Generating DDL
  • Object reports
  • Recycle bin

Application Builder

  • Creating an application based on a spreadsheet
  • Creating an application from scratch
  • Reviewing and editing application objects
  • The Developer Toolbar
  • Creating a page
  • Creating a SQL report
  • Page rendering and processing overview
  • Create a form and associated report

Creating Pages

  • Creating a page group
  • Assigning pages to groups
  • The Page Definition screen
  • Page attributes
  • Report Wizard
  • Form Wizard
  • Editing the page
  • Page processing

Regions and Items

  • Create a region
  • The Region Wizards
  • Editing a region
  • Adding items
  • Modifying an item
  • Item display types
  • Adding buttons
  • Conditionally displaying regions
  • Customize queries
  • Report attributes
  • Downloading the report to a CSV file

Page Processing

  • OnLoad processing
  • Adding validation
  • Computations
  • Branching
  • Calling a page - URL syntax
  • Using variables
  • Session State
  • Getting Session State
  • Setting Session State
  • Viewing a page in Debug Mode

Shared Components

  • Logic components
  • Lists
  • Breadcrumbs
  • Lists of values
  • Tabs
  • NavBars
  • Processes
  • Items
  • Shortcuts
  • Webservices

Themes and Templates

  • Themes
  • Theme repository
  • Managing templates
  • Page templates
  • Region templates
  • Other templates
  • Subscribing to a template
  • Cascading Style Sheets (CSS)

Other Page and Region Types

  • Interactive reports
  • Creating charts
  • Creating calendars
  • Creating trees
  • Creating a wizard
  • Using page 0

Utilities and Reporting

  • Translations
  • Managing CSS and image files
  • Uploading images
  • Exporting and importing

Advanced Development Techniques

  • Authentication
  • Authorization
  • Access Control Wizard
  • Cross Site Scripting
  • Session State Protection
  • Using Page 0
  • Using AJAX
  • The Application Express API
  • Recommendations

Administration and Deploying An Application

  • Builds
  • Application packaging
  • Managing Application Express
  • Provisioning workspaces
  • User administration
  • Purging logs
  • Purging Session State
  • Manage application models
  • Workspace preferences

 
     
Prerequisite: 
  • No previous APEX experience is required. Basic SQL, PL/SQL, HTML and JavaScript skills are helpful, but not essential.
 
   
     
Duration: 
3 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.