Query XML Data with DB2 9

start > courses and registration > training feature sheet

code.

CG100

length.

2 days

type.

Instructor-Led

partner.

IBM

price.

$1,300

This course introduces you to non-traditional ways of using DB2 to work with native Extensible Markup Language (XML) data.

Learn to query XML data that is stored in DB2 tables and how to create XML documents from traditional DB2 data. Search XML documents stored in DB2 tables and access XML documents as though the documents were relational tables.

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.

who can benefit

This is a basic course for end users, database administrators, and anyone interested in learning how to retrieve native XML data and perform text searching of native XML.

prerequisites

You should have at least an introductory knowledge of XML, XML-related concepts, and DB2 concepts. You should also have working knowledge of SQL.

skills gained

	Set up XML Query Language (XQuery) to retrieve documents from an XML column
	Execute SQL/XML retrieval, publishing, and shredding functions
	Use developer workbench to understand how to build XML queries and queries that contain SQL/XML

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

course content details

	XML basics review

	Differentiate between relational data and XML
	Explain the importance of XML
	Describe why and when XML can be advantageous

	Introduction to XML Path Language (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 for, let, where, order by, and return (FLWOR) expression

	SQL/XML

Using the SQL/XML built-in functions, you should be able to: retrieve XML data and publish XML data

	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

	Developer Workbench XML tools - Build XML query (XMLQUERY)

	Create XML queries (XMLQUERY) using the XML Query Builder
	Create queries containing SQL/XML using the SQL Builder

	Day 1

	Welcome
	Unit 1 - XML basics review
	Lab Exercise
	Unit 2 - Introduction to XPath
	Unit 3 - Introduction to XQuery
	Lab Exercise

	Day 2

	Unit 4 - SQL/XML
	Lab Exercise
	Unit 5 - Advanced queries
	Lab Exercise
	Unit 6 - Developer Workbench (Build XML Query)
	Lab Exercise