XQuery Training Course

Primary tabs

Course Language

This course is delivered in Polish or English.

Course Code

xquery

Duration Duration

14 hours (usually 2 days including breaks)

Requirements Requirements

Some knowledge of XML basics. Advanced knowledge of XML-related technologies is beneficial but not required.

Overview Overview

This training provides:

  • A high-level overview and quick tour of XQuery
  • Information to write sophisticated queries, without being bogged down by the details of types, namespaces, and schemas
  • Advanced concepts for users who want to take advantage of modularity, namespaces, typing and schemas
  • Guidelines for working with specific types of data, such as numbers, strings, dates, URIs and processing instructions
  • A complete alphabetical reference to the built-in functions and types

Participants will also learn about XQuery's support for filtering, sorting, and grouping data, as well as how to use FLWOR expressions, XPath, and XQuery tools for extracting and combining information. During the training they will find out how to apply all of these tools to a wide variety of data sources, and how to recombine information from multiple sources into a single final output result.

Course Outline Course Outline

XQuery Introduction

  • What Is XQuery?
  • Path Expressions
  • FLWOR (for, let, where, order by, return)
  • Functions
  • Joins

XQuery Basics

  • The Design of the XQuery Language
  • XQuery in Context
  • Processing Queries
  • The XQuery Data Model
  • Types
  • Namespaces

Expressions

  • Categories of Expressions
  • Keywords and Names
  • Whitespace in Queries
  • Literals
  • Variables
  • Function Calls
  • Comments
  • Evaluation Order
  • Comparison Expressions
  • "if-then-else" Expressions
  • "and/or" Expressions

Paths

  • Path Expressions
  • Predicates
  • Dynamic Paths
  • Input Documents
  • Context

Constructors

  • Including Elements and Attributes from the Input Document
  • Direct Constructors
  • Computed Constructors

Selecting and Joining Using FLWORs

  • Selecting with Path Expressions
  • FLWOR Expressions
  • Quantified Expressions
  • Selecting Distinct Values
  • Joins

Sorting and Grouping

  • Sorting in XQuery
  • Grouping
  • Aggregating Values

Functions

  • Built-in Functions
  • User-Defined Functions

Advanced Queries

  • Copying Input Elements with Modifications
  • Working with Positions and Sequence Numbers
  • Combining Results
  • Using Intermediate XML Documents

XML Namespace

  • XQuery and an Namespace 
  • Namespace Declaration

Types

  • The XQuery Type System
  • The Built-in Types
  • Types, Nodes, and Atomic Values
  • Type Checking in XQuery
  • Automatic Type Conversions
  • Sequence Types
  • Constructors and Casting

Prolog and Module

  • Structure of a Query: Prolog and Body
  • Assembling Queries from Multiple Modules
  • Variable Declarations
  • Declaring External Functions

Using Schemas

  • What Is a Schema?
  • Why Use Schemas with Queries?
  • W3C XML Schema: A Brief Overview
  • In-Scope Schema Definitions
  • Schema Validation and Type Assignment
  • Sequence Types and Schemas

Static Typing

  • What Is Static Typing?
  • The Typeswitch Expression
  • The Treat Expression
  • Type Declarations
  • The zero-or-one, one-or-more, and exactly-one Functions

Principles of Query Design

  • Query Design:
    • Clarity
    • Modularity
    • Robustness
  • Error Handling
  • Performance

Numbers

  • Constructing and comparing Numeric Values
  • Arithmetic Operations
  • Functions on Numbers

Strings

  • xs:string Type
  • Constructing, comparing and manipulating Strings
  • Substrings, length
  • Concatenating and Splitting Strings
  • Whitespace
  • Internationalization

Regular Expressions

  • The Structure of a Regular Expression
  • Representing Individual Characters
  • Representing Any Character
  • Representing Groups of Characters
  • Character Class Expressions
  • Reluctant Quantifiers
  • Anchors
  • Back-References
  • Using Flags
  • Using Sub-Expressions with Replacement Variables

Date and Time Types

  • Extracting Components of Dates, Times, and Durations
  • Using Arithmetic Operators on Dates, Times, and Durations
  • The Date Component Types

Qualified Names

  • Working with Qualified Names
  • URIs, IDs

Other XML Components

  • Documents
  • Text Nodes
  • Comments
  • PI (Processing Instructions)
  • XML Entity
  • CDATA

XQuery-Related Standards

  • XML Serialization
  • XQueryX
  • XQuery Update Facility
  • Full-Text Search
  • XQJ - XQuery API for Java

Implementation-Specific Features

  • XML Version
  • Setting the Query Context
  • Option Declarations and Extension Expressions
  • Serialization Parameters

XQuery vs. SQL

  • XML Data vs. Relational Data
  • SQL Syntax vs. XQuery Syntax
  • SQL and XQuery

XQuery vs. XSLT

  • XQuery and XPath
  • XQuery vs. XSLT

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From 1263PLN
(78)
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
From 1263PLN
Request quote
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 2590PLN
Request quote

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Classroom Private Remote
1 1263PLN 1263PLN 2590PLN
2 857PLN 857PLN 1520PLN
3 721PLN 721PLN 1163PLN
4 653PLN 653PLN 985PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Course Venue Course Date Course Price [Remote/Classroom]
Java Spring Kraków, ul. Rzemieślnicza 1 Mon, 2016-08-29 09:00 7039PLN / 5245PLN
Java Spring Szczecin, ul. Małopolska 23 Mon, 2016-09-05 09:00 7039PLN / 5044PLN
Programming in WPF 4.5 Warszawa, ul. Złota 3/11 Mon, 2016-09-05 09:00 2809PLN / 1805PLN
Web Application Development in PHP Szczecin, ul. Małopolska 23 Tue, 2016-09-06 09:00 2688PLN / 2081PLN
Building Web Apps using the MEAN stack Szczecin, ul. Małopolska 23 Mon, 2016-09-12 09:00 4388PLN / 3003PLN
Java Spring Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2016-09-12 09:00 7039PLN / 5153PLN
Java Spring Poznan, Garbary 100/63 Mon, 2016-09-12 09:00 7039PLN / 4961PLN
Access Intermediate Bydgoszcz, ul. Dworcowa 94 Tue, 2016-09-13 09:00 1218PLN / 910PLN
Java Spring Warszawa, ul. Złota 3/11 Mon, 2016-09-19 09:00 7039PLN / 4961PLN
Java Performance Gdynia, ul. Ejsmonda 2 Mon, 2016-09-19 09:00 4150PLN / 2866PLN
Java Spring Wroclaw, ul.Ludwika Rydygiera 2a/22 Mon, 2016-09-19 09:00 7039PLN / 4961PLN
BPMN 2.0 for Business Analysts Wroclaw, ul.Ludwika Rydygiera 2a/22 Tue, 2016-09-27 09:00 3110PLN / 2337PLN
ITIL® Foundation Certificate in IT Service Management Warszawa, ul. Złota 3/11 Mon, 2016-10-10 09:00 2639PLN / 2076PLN
Visual Basic for Applications (VBA) in Excel - Advanced Wroclaw, ul.Ludwika Rydygiera 2a/22 Mon, 2016-10-10 09:00 1689PLN / 1296PLN
Market Forecasting Poznan, Garbary 100/63 Thu, 2016-10-13 09:00 2936PLN / 2112PLN
Effective working with spreadsheet in Excel Rzeszów, Plac Wolności 13 Tue, 2016-10-18 09:00 918PLN / 843PLN
A Practical Guide to Successful Pricing Strategies Poznan, Garbary 100/63 Wed, 2016-10-26 09:00 1427PLN / 1093PLN
Agile Project Management with Scrum Kraków, ul. Rzemieślnicza 1 Wed, 2016-11-02 09:00 1746PLN / 1449PLN
Visual Basic for Applications (VBA) in Excel - Advanced Białystok, ul. Malmeda 1 Mon, 2016-11-14 09:00 1689PLN / 1413PLN

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
Kraków, ul. Rzemieślnicza 1Thu, 2016-09-08 09:00985PLN / 820PLN
Katowice ul. Opolska 22Thu, 2016-09-08 09:00985PLN / 791PLN
Gdynia, ul. Ejsmonda 2Tue, 2016-09-13 09:00985PLN / 768PLN
Szczecin, ul. Małopolska 23Mon, 2016-09-19 09:00985PLN / 733PLN
Toruń, ul. Żeglarska 10/14Wed, 2016-09-21 09:00985PLN / 745PLN

Some of our clients