Duration: 5 days
You query XML data stored in DB2 tables and create XML documents from traditional DB2 data. You access XML documents as though the documents were relational tables. This content is addressed in the first two days of class and can be taken by users or other personnel who only need to access XML data stored in DB2 tables.
In the last two days of class, you store native XML data in DB2 and create XML indexes. You analyze plan information for queries and take steps for improving query execution. The course also teaches how to manage the XML schemas and the techniques available for decomposing the XML documents.
- List the primary features of XML documents, XML namespaces, and XML schemas
- Use XQuery to retrieve documents from an XML column
- Use SQL/XML retrieval, publishing, and shredding functions
- Develop simple stored procedures and user-defined functions that handle XML documents
- Query XML documents using advanced query techniques
- Use Optim Development Studio to perform both XQuery and SQL queries using SQL/XML
- Establish the environment to store native XML data in DB2
- Create XML indexes for efficient retrieval of XML data
- Work with compression for XML data and XML indexes
- Analyze query executions and what you can do to improve the query performance
- Validate and register XML schemas using commands
- Annotate XML schemas and decompose XML documents using commands
- Use Optim Development Studio to annotate XML schemas for decomposition, and register XML schemas for validation, decomposition, or both
It would be helpful to have an introductory knowledge of XML, XML-related concepts – but the course is designed not to assume any prior knowledge of XML and related matters.
This course is also offered as web-based training. Please contact us for more information.