XQuery for Developers

Course Information

Overview

XQuery provides the means to extract and manipulate data from XML documents or any data source that can be viewed as XML, such as relational databases or office documents.

XQuery uses XPath expression syntax to address specific parts of an XML document. It supplements this with a SQL-like "FLWOR expression" for performing joins. A FLWOR expression is constructed from the five clauses after which it is named: FOR, LET, WHERE, ORDER BY, RETURN.

The language also provides syntax allowing new XML documents to be constructed. Where the element and attribute names are known in advance, an XML-like syntax can be used; in other cases, expressions referred to as dynamic node constructors are available. All these constructs are defined as expressions within the language, and can be arbitrarily nested.

The language is based on a tree-structured model of the information content of an XML document, containing seven kinds of node: document nodes, elements, attributes, text nodes, comments, processing instructions, and namespaces.

Prerequisites

Completion of XML Introduction/Intermediate training course or equivalent knowledge.

1. XQuery Quick Introduction

What is XQuery For?
Playing with XQuery
Literals and Comments in XQuery
Your First XQuery
Accessing XML Documents with XQuery

2. XQuery FLWOR Expressions

An Introduction to the XQuery FLWOR
Expression
Simple FLWOR Expressions
The Principal Parts of an XQuery FLWOR
Expression
F is for FOR
L is for LET
Using 'Variables' in XQuery
W is for WHERE
O is for ORDER BY
R is for RETURN
Other parts of the XQuery FLWOR
Expression
Declaring XQuery types
XQuery Position variables
Multiple assignments
What about Grouping in XQuery?
XQuery FLWOR: A Summary

3. Generating XML Output with XQuery

Show Me the Database!

4. Creating Nodes XQuery

Eliminating Duplicate Subtrees with
distinct-values() and FLWOR Expressions
Inverting Hierarchies
Quantifiers
Conditional Expressions

5. XQuery Operators

Arithmetic Operators
Comparison Operators
Sequence Operators
XQuery Built-in Functions

6. Defining your own Functions in XQuery

A simple XQuery function
The Anatomy of an XQuery Function
Declaration
The XQuery Function Name
XQuery Function Arguments
The result type
The XQuery Function Body
Documentation

7. Variable Definitions in XQuery

8. Library Modules in XQuery

Creating a Database Connection
Supported Databases
The Connection Settings Dialog Box
Using the Server URL Field
How to Create a Database Connection
How to Edit a Database Connection

9. Creating a collection() Statement

collection() Function Syntax
What Happens When You Create a
collection() Statement?
Creating Multiple Connections
How to Create a collection() Statement

Private Courses

We can arrange your own private XML course.

Tailored

Have us build a custom private course tailored to your needs.

Cost Effective

If you are looking to training a group of people private courses can be very cost effective.

Post Course Support

Unlimited post course email support on the course topics.

Delivery Options:

At Your Offices

Virtual Online

Training Centres

What Our Clients Think

This course was great, the trainer was very knowledgeable and has improved my knowledge considerably. The facilities are fantastic. Thank You!

Kurtis Fleming - HM Revenue & Customs

This course was excellent and I am delighted with how much I have achieved. The trainer was very friendly and approachable.

Rosie Heath - Licensed Trade Charity

The trainer was a really good instructor, he took the time to help us with individual issues and also tried to cater the course to meet our collective needs.

Ben Knight - Atlas Copco Ltd

Very informative and was at a good pace. Lots of extra useful tips too.

Harry Finch - Lancashire Insurance

The trainer was fantastic and very knowledgable!

Harriet Woollam - Galloping Gourmet

Really enjoyed this course. It delivered exactly what I wanted out it.

Malkit Singh - Regatta Ltd

XML Introduction - Intermediate

XSLT Introduction - Intermediate

XQuery for Developers

2 Day Instructor-led

Course Information

Course Outline