Oracle and XML

Course Number:  594-JK
Recommended Duration:  3 days

Intended Audience
Experienced Oracle developers who need to add and/or enhance XML data in their Oracle-based applications.

Course Overview
Course appropriate for Oracle 11g and 10g.  Course can be taught with Oracle version 9i.  There are ten machine exercises and three optional exercises.

Objectives
Attendees will learn to use XML with the Oracle database.  Students will learn how XML DB is used to store and retrieve XML data inside the Oracle database.

Prerequisites
Working Oracle SQL and general XML experience of at least six months or completion of “Oracle SQL for Developers”, “Oracle SQL and PL/SQL for Developers”, and “XML Introduction” (or equivalent) course.

Topics

• XML DB concepts & features

• Oracle XML and SQL/X functions

• XML DB repository & versioning

• XMLType: properties and methods

• XML Schema

• Structured and Unstructured XML

• Hybrid XML Data

• Oracle 11g Binary XMLType

• Loading data into XMLType

• Using XPath with XMLType

• XMLTransform() & XMLType.transform()

• UpdateXML(), InsertXML(), AppendChildXML(), InsertXMLBefore(), DeleteXML() and existsNode()

• Create and Use XMLType views

• Indexes and XMLType

• HTTPURIType, DBURIType, XDBURIType

• XQuery expressions

• XQuery FLOWR, XPath, XQuery

• SQL XMLQuery() & XMLTable()

• Oracle XQuery extension functions

• Queries: Relational, XMLType, CLOB

• XML document searches

• XML and PL/SQL

• PL/SQL APIs for XMLType

• XSQL Pages Publishing Framework

• XQuery with ODP.Net and C#

• XDB and WebDAV

• Import/Export XMLType Data

• Using SQL*Loader with XMLType data

• XML performance issues