Kurs informasjon: Query XML data with DB2 9 - Web Based

This is a self-paced online course. The average amount of time to complete this course is 24 hours. Once you receive your access information, you will have 1 year to complete this course.

Please do not make travel arrangements for this course. After you receive confirmation that you are enrolled, you will be sent further instructions to access the course.

This course is designed to introduce the students to non-traditional ways of using DB2 to work with native XML data. It is also designed to enable database administrators to manage the DB2 - native XML environment.

The students query XML data stored in DB2 tables and create XML documents from traditional DB2 data. They 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.

Training Path

This course is part of an IBM Training Path. Taking this course in the recommended sequence allows you to maximize the benefits from your education.

The self-paced format gives you the opportunity to complete the course at your convenience, at any location, and at your own pace. The course is available 24 hours a day. Once you have accessed the course, instructor help is available via the course forum Monday through Friday; questions will be responded to within 24 hours.

IThis is the Web-based version of Classroom course Query and Manage XML Data with DB2 9 (CL121NO).

View this course in other countries

Roadmaps:

• XML

Til top

This course is for:

• Users
• Database administrators
• Anyone interested in learning how to retrieve native XML data and how to handle native XML data in DB2

This course is appropriate for students using DB2 in a z/Linux environment.

Til top

You should have a working knowledge of:

• SQL and DB2 concepts.

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.

Til top

• 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

Til top

XML basics

• Explain the business value of using XML technology
• Describe why and when XML can be advantageous
• Differentiate between relational data and XML
• Determine whether a given XML document follows the basic XML standards

XML Namespaces

• Explain the need for and importance of namespaces
• List the rules for defining and using namespaces within an XML document
• Use namespaces in common scenarios

XML Schemas

• Describe the alternative approaches to schemas for XML
• Identify the components of a DTD and how they are used
• Define the components and constructs that make up an XML schema
• Identify approaches to using XML schemas for XML document processing
• Create a simple XML schema
• Validate an XML document against an XML schema

Introduction to XPath

• Describe the reasons for using XPath
• Define the components and constructs that make up the XPath language
• Identify abbreviated XPath expressions
• Write simple XPath expressions to navigate through XML documents

Introduction to XQuery

• Describe the XQuery and XPath data model
• Retrieve DB2 data using XQuery functions
• Construct the most often used FLWOR (for, let, where, order by, and return) expression

SQL/XML

• using the SQL/XML built-in functions: Retrieve XML data, Publish XML data, and Shred XML data

Updating and Transforming XML Documents

• List the common methods that can be used to update or transform XML documents
• Describe the reasons for using TRANSFORM
• Use the TRANSFORM clause to COPY, MODIFY, and RETURN results
• Use the TRANSFORM clause to replace values and nodes, to insert nodes, delete nodes, and rename nodes in an existing XML document
• Describe the purpose and functionality of XSLT transformations

Introduction to Programming with XML

• Use IBM Optim Development Studio to develop basic stored procedures, triggers, and user-defined functions that handle XML documents
• Pass XML parameters to stored procedures and user-defined functions
• Compare modes of access to XML data from common programming languages
• List XML features that are available through various programming languages
• List XML capabilities available through Java programming

Advanced queries

• Use conditional (if-then-else) logic
• Include arithmetic calculations
• Join XML data in different tables
• Join relational and XML data
• Embed XQuery inside SQL
• Pass parameters

Optim Development Studio and XML Queries

• Create XML queries (XMLQUERY) using the query builder
• Create queries containing SQL/XML using the query builder

Agenda

• Welcome
• Unit 1: XML Basics
• Exercise #1
• Unit 2: XML Namespaces
• Exercise #2
• Unit 3: XML Schemas
• Exercise #3
• Unit 4: Introduction to XPath
• Exercise #4
• Unit 5: Introduction to XQuery
• Exercise #5
• Unit 6: SQL/XML
• Exercise #6
• Unit 7: Updating and Transforming XML Documents
• Exercise #7
• Unit 8: Introduction to Programming with XML
• Exercise #8
• Unit 9: Advanced Queries
• Exercise #9
• Unit 10: Optim Development