Course Description:

The first part of the course covers the nuts and bolts of XML and the related standards XSLT and XPath. This is followed by an overview of the various XML components and tools for developing Oracle XML applications, such as JDeveloper, Oracle XML Parser, XSLT Processor, XSQL pages and the XML SQL Utility, as well as the role of XML in Oracle Business Components for Java (BC4J).

The main part of the course is concerned with using SQL, XML and XSLT for processing and transforming data and documents.

Who Needs to Attend:

Experienced Oracle developers who need to get up to speed with XML and its uses in an Oracle context.

Prerequisites:

Attendees are expected to have a good working knowledge of SQL and Oracle, and at least a basic knowledge of PL/SQL and Java.

Participants will learn to …

• Understand the fundamentals of XML

• Develop XML applications using JDeveloper and Java

• Process XML with PL/SQL

• Transform XML data and XSQL Pages using XSLT

• Serve XML Datagrams over the web

• Search XML Documents

Course Contents:

Fundamentals of XML

• origins and uses of XML

• building blocks of XML

• well formed XML documents

• resources and links

• document models and DTDs

• event based and tree based processing of XML documents

• searching XML with XPath

• style sheets and XSLT

Developing XML applications using JDeveloper and Java

• editing XML, XSQL and JSP files

• parsing XML documents using DOM or SAX

• transforming documents using XSLT

• searching XML documents using XPath

• Constructing XML documents using DOM

• implementing servlets to process or return XML

• running and processing XSQL pages

Processing XML with PL/SQL

• loading external XML files

• parsing XML

• searching XML with XPath

• generating and transforming XML query results

• XML Messages

XSLT and XML data transformation

• how XSLT processing works

• single and multiple-template style sheets

• input - output options

• XSLT variables

• grouping repeated data using SQL

• sorting and grouping repeated data using XSLT

XSQL Pages

• overview of XSQL

• transforming XSQL page results using XSLT

XML Datagrams

• generating XML using PL/SQL or Java

• serving XML datagrams over the web

• generating XML automatically from SQL queries

• storing and retrieving XML datagrams

Searching XML documents

• overview and uses of interMedia

• understanding the interMedia query language

• advanced interMedia queries

Advanced topics

• extending XSQL and XSLT using Java

• XSQL based document publishing

• XSLT based web portals