Please contact us
for GSA pricing.

Contract #

Please see our complete list of Microsoft Official Courses

XQuery Training: Mastering XPath and XQuery

4.5 out of 5 (109 reviews)

Course Number: XML-130
Duration: 2 days
view course outline

XQuery Training Overview

Accelebrate's XQuery training teaches attendee how to find, retrieve, and manipulate data in XML documents using XPath and XQuery.

Location and Pricing

Most Accelebrate courses are delivered as private, customized, on-site training at our clients' locations worldwide for groups of 3 or more attendees and are custom tailored to their specific needs. Please visit our client list to see organizations for whom we have delivered private in-house training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote for private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. See a schedule of online courses.

XQuery Training Prerequisites

All attendees should understand the fundamentals of XML.

Hands-on/Lecture Ratio

This XQuery training class is 50% hands-on, 50% lecture, with the longest lecture segments lasting for 30 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

XQuery Training Materials

All XQuery training students receive a copy of Ms. Walmsley's XQuery book and related courseware. The book is published by O'Reilly and has been the #1 selling XQuery book since its release.

Software Needed on Each Student PC

  • The XML/XSLT/XQuery editing and transformation environment that your developers will be using after class.

XQuery Training Objectives

  • Understand the XQuery/XPath data model
  • Master the fundamentals of the XQuery/XPath language
  • Use path expressions to refer to elements
  • Select and filter using FLWORs
  • Group combine, and join results
  • Work with namespaces
  • Manipulate strings of text
  • Use functions and modules

XQuery Training Outline

  • XQuery in Context
    • What is XQuery?
    • Use Cases
    • Background and language design
    • Easing into XQuery
  • The XQuery/XPath Data Model
    • Nodes
    • Atomic values
    • Sequences
  • XQuery/XPath Language Basics
    • XQuery syntax and keywords
    • Variables
    • Function calls
    • Comments
    • Comparisons
    • Conditional expressions (if-then-else)
    • The query prolog
  • Path Expressions
    • Axes
    • Node tests
    • Predicates
    • The position() and last() functions
    • The doc() and collection() functions
  • Adding Elements and Attributes Using Constructors
    • Direct element constructors
    • Direct attribute constructors
    • Computed constructors
  • Selecting and Filtering Using FLWORs
    • The for clause
    • The let clause
    • The where clause
    • The return clause
    • The order by clause
    • Quantified expressions (some/every satisfies)
  • Grouping, Combining and Joining Results
    • Selecting distinct values
    • Joining two documents
    • Outer joins
    • Combining sequences (union, except, intersect)
    • Grouping
  • Working with Namespaces
    • Namespaces in XML
    • Namespaces in XQuery
  • Working with Text and Strings
    • Comparing strings
    • Matching with regular expressions
    • Manipulating strings (concatenating, splitting, replacing)
    • Understanding whitespace
  • Functions and Modules
    • Calling built-in functions
    • User-defined functions
    • Library modules
    • Global variables
  • A Closer Look at Types and Schemas
    • The XQuery/XPath type system
    • Constructors and casting
    • Using schemas with XQuery
  • Conclusion