XQuery for Developers

2 Day Instructor-led
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

Dates & Availability

We currently don’t have any dates scheduled for this training course but offer it as a corporate, private course for your own team.

Please use the enquire button below.

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 good trainer. He made the training interesting and fun.

Wendy Sipson - Hampshire Constabulary

Very good, trainer was excellent.

Mike Hartley-Bingle - XPS Pensions Group

Very informative course, very useful tips on how to work with SQL Management Studio. A lot of SQL quirks explained, a lot of good examples.

Magdalena Piekarska - Veolia

A great course. The trainers experience and knowledge is a great asset.

Nancy Shering - Equinix Group Ltd

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

Felicity Howdle - Health Education England

This has been by far one of the most useful and well planned/executed training courses I have ever attended. For this to have been achieved remotely just adds to how impressive it was managed.

Trevor Stratton - Lincolnshire County Council

Related Courses

Format:
Virtual or Classroom
Length:
2 Days
This course provides a full introduction to Extensible Mark-up Language (XML). XML is particularly useful for passing data between business appliications.
Format:
Virtual or Classroom
Length:
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.
Format:
Virtual or Classroom
Length:
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.