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

Very good course. I've been using the software constantly in the last three months and still learnt a lot.

George Martin - NHS North of England

Got a really good and rounded training session. It met more than my original needs, and has given me great confidence.

Debbie Seymour - FatFace

Cannot fault the content & delivery of the course at all. A brilliant service from start to finish. Thank you Systematix.

Claire Mitchell - Denbighshire County Council

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

Harry Finch - Lancashire Insurance

Course was well adjusted to consider the business perspective - considering commonly needed calculations, time based data analysis etc.

Suvi Salminen - Crane CPE

Very clear instruction, pace was kept moving, great snippets of advice given.

Robert Montgomery - Liberty Aluminium Technologies

XML Introduction - Intermediate

XSLT Introduction - Intermediate

XQuery for Developers

2 Day Instructor-led

Course Information

Course Outline