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.

Outline

  • What is XQuery For?
  • Playing with XQuery
  • Literals and Comments in XQuery
  • Your First XQuery
  • Accessing XML Documents with XQuery
  • 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
  • Show Me the Database!
  • Eliminating Duplicate Subtrees with
  • distinct-values() and FLWOR Expressions
  • Inverting Hierarchies
  • Quantifiers
  • Conditional Expressions
  • Arithmetic Operators
  • Comparison Operators
  • Sequence Operators
  • XQuery Built-in Functions
  • 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
  • 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
  • collection() Function Syntax
  • What Happens When You Create a
  • collection() Statement?
  • Creating Multiple Connections
  • How to Create a collection() Statement
Dates and Prices

There are currently no public dates for this course. This course can be run as a private course either at one of our training centers or at your offices. To get pricing for this use our quote wizard to generate a customised quote or call us on 0118 324 3000 to discuss your requirements.

image
2 Days

Testimonials

  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager-Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne-Oracle