Oracle Application Express 3.0: Developing Web Applications

This course is designed to introduce the students to Oracle Application Express 3.0. The course covers various Application Express components and wizards to build applications and database objects that are easy to deploy. The students learn how to build forms and reports and incorporate different types of items and shared components. Creating and utilizing various navigation components as well as session management and debugging are discussed. In addition, students incorporate access control, and session protection to enforce application security. Once the application is complete, students learn how to define their packaged application and export the application. Students will also use all the Utilities and Report capabilities that Oracle Application Express provides to build a robust application.

Learn to:

	Develop a database-centric Web application using the Application Builder
	Manage Authentication, Authorization and Session State within your Application
	Utilize and Manage Shared Components
	Administer Application Express Workspaces
	Manage Database Objects Using SQL Workshop
	Deploy Your Application

course content details

	Introducing Oracle Application Express

	Explaining the General Concepts
	Identifying the Main Components
	Creating a Workspace and Workspace Administrator
	Logging In to Oracle Application Express
	Installing and Running a Sample Application
	Installing a Packaged Application

	Interacting with the Database by Using SQL Workshop

	Browsing, Creating and Modifying Objects
	Processing Ad Hoc SQL Statements
	Managing Scripts
	Creating, Running and Saving SQL Queries

	Building an Application

	Identifying the Components of an Application
	Creating an Application from Scratch
	Creating an Application from a Spreadsheet

	Creating Reports

	Generating Reports Using Wizards
	Editing Report Attributes
	Adding Links in Reports
	Saving or Printing Reports in Different Formats

	Creating Forms

	Creating a Form on a Table With a Report
	Creating a Tabular Form
	Creating a Master-Detail Form
	Editing Form Attributes

	Working with Pages and Regions

	Viewing Page Definitions
	Editing Page Attributes
	Creating a New Region
	Viewing Region Attributes
	Adding Comments

	Adding Items and Buttons

	Creating Items
	Editing Item Attributes
	Creating Buttons
	Editing Button Attributes

	Understanding Session State and Debugging

	Implementing Session State
	Setting a Session State Value
	Clearing the Session State
	Reviewing the Session State
	Reviewing the Messages in Debug Mode

	Including Page Processing

	Explaining the Difference Between Page Rendering and Page Processing
	Creating Computations
	Validating Input Data
	Process Data
	Creating Application Branching

	Adding Shared Components That Aid Navigation

	Providing an Overview of Shared Components
	Managing Parent and Standard Tabs
	Managing Navigation Bars
	Managing Lists
	Managing Breadcrumbs

	Adding Other Shared Components

	Managing List of Values
	Managing Trees
	Accessing Shared Component Reports
	Setting User Interface Defaults

	Displaying Dynamic Content

	Filtering Reports Using Dynamic Queries
	Creating Charts Using a Wizard
	Creating a Calendar

	Working with Themes and Templates

	Switching to a Different Theme
	Viewing Existing Templates
	Managing Templates
	Adding a Logo
	Referencing a Cascading Style Sheet
	Changing a Field to Use a Class in the Referencing Stylesheet

	Administering Oracle Application Express Workspaces

	Managing Users
	Requesting a Schema or Storage
	Purging Session State
	Monitoring Developer Activity Log
	Monitoring Workspace Activity
	Viewing Activity Reports

	Implementing Security

	rentiating Between Authentication and Authorization
	Providing an Authentication Scheme
	Creating an Authorization Scheme Using Access Control
	Enabling and Configuring Session State Protection

	Deploying Your Application

	Defining Supporting Objects
	Exporting Your Application
	Importing Your Application
	Installing Supporting Objects

	Using Utilities

	Importing and Exporting Data
	Generating Data Definition Language (DDL) Statements
	Viewing Object Reports
	Monitoring the Database