[   e s c a l a ]

Course - XQuery and XML Storage using IBM DB2 v9

Course overview:

This course is designed specifically for people who will be practically involved with the native storage and processing of XML documents in XML databases. IBM DB2 version 9 is the focus of this course and DB2v9 tools will be used to assist in the development of XML applications using XQuery. XQuery, the W3C standard querying language, is more extensive and powerful than SQL. Most of the features of XQuery will be covered in detail, including programmatic approaches to working with XQuery. Other revelant tools with XQuery capabilities, e.g. XML Spy, will also be used. The course will be run in the context of SOA style development.
This is a highly practical course with numerous workshops.

Who should attend:

Programmers, designers and architects who need to work with DB2 version 9 using the native XML storage and XQuery processing capabilities.

Course objectives:

• Introduce and work with native XML storage
• Review relevant aspects of XML syntax, XML Schema, XPath, XSLT
• Store and query native XML structures
• The programming model of XQuery
• Explore and use major features of XQuery
• Using SQL in combination with XQuery
• Install and run the product and tools
• Introduce development facilities

Prerequisites:

Working knowledge of XML syntax, XML Schema, XPath & XSLT anda basic understanding of SQL.

Duration:

3 days

Course contents:

• Evolution of XQuery
• Overview pureXML Storage Capabilities
• Overview of Relevant XML Technologies
• XQuery Processing Overview
• XQuery Basic Syntax
  • comments, literals, variables, functions, operators, types
• Sequences, FLOWR Expressions
  • iteration, conditions, filter expressions, scoping, quantified expressions
• Working with Nodes
  • node functions, constructors direct and computed, combinations, comparison, namespaces
• User Defined Functions
• Working with DB2 XML Databases
  • creating and working with native databases, combining SQL and XQuery
  • SQLX
• Further Features of DB2 XML Databases
  • schema validation, XML indexing
• W3C XQuery Use Cases
• Other XQuery Tools

On successful completion of this course:

Attendees will be able to use the native XML storage and XQuery processing capabilities in the context of DB2 v9 development and have gained an intimate knowledge of XQuery, its programming model and range of facilities.

For more information send an email with your queries. See our contacts page.