Audience
This course is intended for business analysts, end users, programmers and team leads who need to use pureXML to access XML data in a Db2 for z/OS table.
Description
Get ready to become a power user of XQuery and XPath expressions in the processing of XML documents. Get ready to understand some of the efficiencies and inefficiencies of XML processing. Db2’s PureXML feature allows you to store well-formed XML documents as a column that has the XML data type. This allows for efficient search, retrieval, and updates within an XML document. This class spends time showing how to query these documents using the XQuery language (with XQuery expressions). Students will have many hands on workshops to reinforce the topics, and learn the most efficient ways to code and process.
Objectives
Upon successful completion of this course, the student will be able to:
- Describe the importance of using XML for storage
- Describe the XML data type and how Db2 for z/OS stores the XML data
- List the advantages of using pureXML over the previous XML implementation
- Explain using the XML “path” type expression to access a portion of an XML document
- Review and discuss sample queries that illustrate SQL/XML capabilities to access XML data
- Build and use SQL/XML queries to access XML data for Select, Insert, Update, and Delete
- Build and use new XQuery features including FLWOR expressions and their join syntax.
- Understand the ‘Best Practices’ for indexing XML documents
- Understand the ‘Best Practices’ for efficient XQuery processing
Prerequisites
Some experience in SQL programming is recommended. Some previous experience in XML documents would be nice, but not required. The features in this course are noted below are for Db2 for z/OS.