XML
in ORACLE
Length: 1 Day
Prerequisites:
Students must have attended the following courses or have
equivalent experience:
"Introduction to Oracle for
Developers and "introduction to XML. They must also have a
basic understanding in;
both SQL and PL/SQL plus a
basic foundation in XML.
Overview
Oracle provides a
suite of features collectively labeled “XML DB”. XML DB
provides native support for XML within the Oracle
database. This includes the XMLType datatype for both
structured and unstructured storage, XSchema and data
validation within the database, XPath and XQuery searches,
the XML repository, conversion between XML and relational
data, and more.
This class will
provide a technical and practical introduction to the use
of XML in Oracle. Workshops will provide hands-on
experience using both relational and XML data within an
Oracle environment. Special attention will be paid to
generating XML documents from relational data, and
generating relational data from XML documents.
Key Benefits: This course will provide you with
a firm grounding in the techniques needed to design and
develop
and tune applications using XML in Oracle.
Audience: Developers and Database
Administrators who will build or support XML-based
applications using Oracle Database
Outline
Chapter 1. Introduction to Oracle XML DB
Chapter 2. Introduction to the
SQL/XML standards
Chapter 3. Options for storing XML Data:
XML tables, XML columns, XML DB Repository
Chapter 4. XMLType: Structured vs.
Unstructured Storage
Chapter 5.
Advantages/Disadvantages of structured vs. unstructured
storage
Chapter 6. Namespace support
Chapter 7. Loading XML data:
insert, update, piecewise update
Chapter 8.
XSchema support
Chapter 9.
Validation
Chapter 10. XQuery and XPath
support
Chapter 11. XML functions:
extract, extractValue, existsNode, XMLSequence, etc.
Chapter 12. ora functions: view,
contains, matches, replace, sqrt
Chapter 13. XML DB Repository
support: fn:doc, fn:collection
Chapter 14.
XQuery
FLOWR support
Chapter 15.
XMLQuery & FLOWR : XML
document joins
Chapter 16.
XMLQuery and ora:view :
Generating XML data from relational data
Chapter 17. XTable function:
Generating relational data from XML data
Chapter 18. XML Performance
Issues: tuning, indexes, function-based indexes, etc.
Chapter 19. New XML features in
Oracle 11g
Back to Course Listing
