Course Title:
Oracle Application Server for Developers

Duration: 2 days

Course Overview
This course will show the delegate how to build dynamic Web applications that use an Oracle database by using the PL/SQL Web Toolkit to generate HTML. Scripting features will also be used to include dynamic content.

Target Audience


The attendees will be technically involved with web application design and development or database administrators wanting to further their understanding of web applications. The attendee should have a good understanding of SQL and PL/SQL with some exposure of the Oracle Application Server. Preferably they should have attended the Fundamentals of SQL, Fundamentals of PL/SQL and Oracle Application Server for Administrators courses.

Some basic knowledge of HTML and the internet would also be an advantage.

Course Objectives


On completion of this course, attendees will:

Be able to create interactive Web Pages
Use information from an Oracle database in a PL/SQL Web application
Produce dynamic Web Pages through scripting via LiveHTML

Course Content


Introduction to PL/SQL Web Applications
Application Structure in OAS
PL/SQL Web Application Architecture

Using HTML to Create a Web Page
Uniform Resource Locators (URLs)
Elements of a Web Page
HTML
Document Links, Images and a Home Page

Using the PL/SQL Web Toolkit
Accessing Package Procedures
HTP and HTF Packages
Basic page Creation
Reusable Page Components
Application Code is .sql Files
Retrieving Database Information

Building Dynamic Tables and Forms
Using HTML for Tables
Building, Populating and Printing Tables
Identifying Form Elements
Creating Form Elements
Handling Multiple Values

Toolkit Utilities
owa_util Procedures
owa_text, owa_pattern and owa_custom Packages
Creating a Home Page

Client Interaction
Cookies
Image Maps

Creating Display Areas
Frame Concepts and Components
Creating a Frameset
Populating a Frame

Data and Transactions
Identifying DML
Handling Concurency
Transaction Management Methods
Configuring an Application for Transaction

LiveHTML
LiveHTML Features

We have used Pentland for a number of years to provide for our needs in a number of areas, including .NET, C Sharp and UML.

Pentland’s ability to provide training tailored to the needs of our group has been critical to our ongoing success.

Software Control Manager
Waters


Enter your email address to register for our newsletter:


IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

follow us on Twitter