Virtual and Classroom Training - All our courses are available virtually. We have also started a safe return to classroom training. Click here to learn more.

XQuery for Developers

2 Day Course
course icon

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.

Course Outline

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.

What Our Clients Think

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

Malkit Singh - Regatta Ltd

Excellent course, The trainer was very helpful and taught the group a wide range of new Word skills.

Ben Cooper - TSS

Very good at tailoring the course to my needs. Very individual and attentive.

Andrew Griffin - Blackfin

Very good introduction. Well paced and suited a range of experience levels.

Felicity Howdle - Health Education England

Really good course. lots of hands on practice and clear explanations.

fiona dawe - Covetrus Global Software Services

The course was fantastic - I couldn't recommend it enough!

Bonnie Donaghue - IRI

Related Courses

Introduction - Intermediate 2 Days
This course provides a full introduction to Extensible Mark-up Language (XML). XML is particularly useful for passing data between business appliications.
Developer 2 Days
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 docs.
Introduction - Intermediate 2 Days
This course teaches you all that you need to begin using XSLT in their XML projects. XSLT enables you to transform XML data from one document type to another.