Here is the high-level outline of the talk I am planning on presenting. Note that there is lots of ground to cover and only limited time. Thus, I am not planning on giving an in-depth XQuery tutorial but rather show several XQuery statements to give a feel for the language and talk about how to use it in the context of SQL Server and how to optimize it by use of XML indices.
Title: XQuery Deep Dive
Slides & Demos:
- XML and Relational Data Today
- XML Scenarios
- XML or Relational?
- XML and Relational!
- SQL Server 2005 XML Architecture
- Why XQuery?
- What is XQuery?
- Demo: XQuery Introduction
- Key XQuery Features
- XQuery Type System
- Static Typing in XQuery
- XML Data Modification
- XML-DML: replace, insert and delete
- Demo: XQuery and XML-DML in SQL Server 2005
- XQuery and XML-DML in SQL Server 2005
- XQuery methods
- XQuery: nodes()
- sql:column()/sql:variable()
- XQuery: modify()
- Combined SQL and XQuery/DML Processing
- XML Indices
- Example Index Contents
- Primary XML Index
- Architectural Blueprint: Indexing
- Demo: XQuery Optimizations with XML Indices
- Take-away: XML Indices
- Session Summary
- Community Resources
Speaking of XQuery tutorials, Michael Kay and StylusStudio just made a short XQuery primer available (a bit Saxon and StylusStudio-centric). Or you can get my two favorite XQuery books (although both are based on slightly older draft versions of the language, they should still be useful for understanding the language).
Hope to see you all in LA...