Course Description

Course name

DB2 PureXML

Course code

DB2XML

Audience

People who wish to use DB2UDB SQL to create queries.

Prerequisites

Familiarity with relational concepts.

Objectives

Upon successful completion, the participant will be able to:

  • review the basic SQL structure of:

Select, From, Group by, Having and Order by

  • Discuss the history of XML and how it relates to SGML and HTML
  • State the Design considerations for XML
  • Design and create document pages using the XML
  • Discuss the ways relational databases implement XML.
  • Discuss the pureXML features and innards.
  • Discuss the differences between SQL and XQuery.
  • Discuss and exploit the XQuery Data Model.
  • Code using XQuery Language Basics and syntax.
  • Code using XPath Expressions.
  • Code using XQuery FLWOR expressions to select, filter and sort results.
  • Use Functions to affect the output of an XQuery.
  • Use the XMLQUERY, XMLTABLE and XMLEXISTS functions for mixing XQuery with SQL.

Duration

3 Days