Part I: Oracle Application Server: Develop Web-Based Applications 

Description:
This course introduces PL/SQL programmers to features in Oracle Application Server for building dynamic Web applications that access an Oracle database. The course introduces the concepts of Web-enabling Oracle databases by using the PL/SQL Web Toolkit to generate HTML. In addition, participants will use scripting features to build web pages that include dynamic content, such as other Web pages.

Incorporate Oracle database information into PL/SQL Web applications; Generate dynamic Web pages using the scripting features of LiveHTML; Produce interactive Web pages through the PL/SQL Software Development Kit

Course Topics:

• Introduce PL/SQL Web Applications

Identify application structures in OAS; Identify the PL/SQL Web application architecture; Describe the course application
• Creating a Web Page with HTML

Identify the elements of a Web page; Use HTML body tags: headings, lists, formatting; Create document links; Add inline images; Set up a home page
• Using the PL/SQL Web Toolkit

Access package procedures through a URL; Use HTP and HTF packages: an introduction; Create a basic page; Build a package with reusable page components; Write and access application code in .sql files; Select database information; Building a Dynamic HTML Table; Use HTML tags for tables; Build a table using HTP/HTF; Populate tables dynamically; Print tables;
• Building Dynamic Forms

Identify the elements of a form; Create form elements with HTP; Handle multiple values
• Adding Functionality with Toolkit Utilities

Use additional owa_util procedures; Enter dates in forms; Use owa_text and owa_pattern packages; Use owa_custom package; Create a dynamic home page
• Enhancing Client Interaction

Use cookies in applications; Implement image maps; Use an image to submit a form
• Validating Data and Executing Transactions

Identify DML and data validation issues; Utilize validation methods; Handle concurrency; Utilize transaction management methods; Configure an application for transactions
• Creating Display Areas with Frames

Identify frame concepts and components; Create a frame-based document using HTP; Populate a frameCreate a frameset; Frames: utilizing design considerations
• Implementing Functionality through LiveHTML

Identify LiveHTML features; Include another file; Display environment variables; Execute external scripts; Embed Perl scripts in LiveHTML documents

Course ID: 45320

Description:
In this course, participants will be introduced to the features in Oracle Application Server for building dynamic World Wide Web applications that leverage an Oracle database. Participants will examine the concept of Web-enabling applications by using the Java Web Toolkit to generate HTML (Hypertext Markup Language). In addition, participants will learn how to use AppBuilder for Java and scripting features to provide dynamic content in Web pages.

Course Topics:

• Introduction to Java Applications on Oracle Application Server (OAS)

Explore OAS application structure; Examine Java Web cartridges; View the AppBuilder for Java; Examine wizards for OAS and Web publishing
• Deploy Java Code on OAS

Examine virtual and physical paths; Use the Java Web Toolkit; Generate HTML with oracle.html package; Examine class hierarchy; Map HTML elements to Java classes; Create headings, text, lists, images, links, and frames
• Access the Database

Introduction to PL2JAVA; Invoke PL/SQL stored procedures; Build dynamic tables and forms; Populate HTML tables with database information; Discuss Java classes for HTML form elements and table generation
• Manage Activity in an Application

Maintain a persistent state and database connection in Java; Implement functionality through LiveHTML; Configure commands tags, displaying environment variables; Execute external scripts

Course ID: 45220

Description:
In this course, participants will examine the administration, concepts, and installation of Oracle Application Server (OAS). Participants will learn how to manage the components of OAS, use the administration tools, and implement security to support applications. This course also provides the necessary background for Web developers and three-tier developers who will build applications for OAS.

Course Topics:

• Introduction to Oracle Application Server (OAS)

Explore the role of Oracle Application Server; Examine the main components of OAS: process model, listeners, adapters/dispatchers, cartridge servers, and factories; Compare single versus multi-node configurations; Study the architecture of Web and CORBA applications
• Install and Manage Oracle Application Server

Introduction to OAS Manager; Discuss hardware and software requirements; Identify pre and post installation tasks; Demonstrate installation steps; Use Site Manager to manage the Web site
• Examine and Manage Web Listeners

Start and stop listeners; Create and modify Web listeners; Implement Web listener security
• Discuss Application Server Security

Examine security mechanisms; Explore the Authentication Server; Discuss authentication schemes and restriction schemes; Establish secure Web sessions; Implement inter-node security
• Manage and Monitor Applications

Configure application types: LiveHTML, ODBC, Perl, and VRML; Set up transactions; Define Database Access Descriptors (DADs); Create and configure DADs; Start and stop the database server; Configure PL/SQL and Java applications; Review and use the Log Server

Course ID: 65402

Description:
One of the key components of Oracle’s Network Computing Architecture (NCA) is Oracle Application Server (OAS). With OAS, developers benefit from an open, distributed and multi-tier architecture which is ideal for developing and deploying applications on the Web. This seminar begins with an introduction to Enterprise Developer Suite (EDS) and NCA and then moves forward to focus on the key architecture and application development benefits of OAS. It’s an essential session for those who want to get the most out of the Internet application development options available with OAS.

Course Topics:
Define the key elements in Oracle NCA; Describe Oracle EDS; Understand the functionality of OAS; Identify key steps in building OAS applications such as PL/SQL, Java and JCORBA

Textbooks:

(1) Oracle Web Application Server Handbook (Oracle Series)
by Barry Johnson
List Price: $39.99; Avg. Customer Review: 5 stars

(2) Oracle Application Server Web Toolkit Reference (Oracle Series)
by Bradley D. Brown, Richard J. Niemiec, Joseph C. Trezzo
List Price: $44.99; Avg. Customer Review: 5 stars