Using XML and XQuery Effectively with SQL Server

Using XML Technologies in SQL Server to create hybrid relational-XML applications
Course info
Rating
(92)
Level
Intermediate
Updated
Aug 20, 2010
Duration
5h 29m
Table of contents
XML Intro - The XML Data Type
XML Schema Support
XQuery Introduction
XQuery: Using XQuery with XML data type methods
XQuery Performance and XML Indexes
Hybrid Applications: Using XML and Relational Together
Description
Course info
Rating
(92)
Level
Intermediate
Updated
Aug 20, 2010
Duration
5h 29m
Description

This course covers SQL Server's integration with XML technologies including the XML data type, XQuery implementation, XML Schema support, and XML index performance considerations. It also covers different ways of integrating XML with related SQL Server features.

About the author
About the author

Bob Beauchemin is a database-centric application practitioner and architect, instructor, course author, writer, and Developer Skills Partner for SQLskills. He is lead author of the books "A Developer's Guide to SQL Server 2005" and "A First Look at SQL Server 2005 For Developers", author of "Essential ADO.NET" and has written articles and whitepapers on SQL Server and other databases, database security, ADO.NET, and OLE DB for MSDN, SQL Server Magazine, and other publications.

Section Introduction Transcripts
Section Introduction Transcripts

XML Intro - The XML Data Type
Welcome to the class on XML support in SQL Server. I'm Bob Beauchemin. In this module, I'll be talking about an introduction to that support and a little bit about the history and the scope of the support. And the intricacies of the XML data type. Specifically, I'll discuss storage of the XML data type, the implementation details, and conversion of XML to and from other data types in SQL Server. I'll do an overview of composition and decomposition that's XML to relational and relational to XML. I'll talk about loading XML from a file on the file system. And finally, mention standards that are covered in this support, including ANSI standards and W3C XML standards.

XML Schema Support
In this module, I'm going to talk about XML schema support that is built into SQL Server versions 2005 and above. This includes XML schema collections, talking about the built-in XML schema collections, and user schema collections, storing and using schemas, schema collection security, support for XML schema productions in SQL Server, they don't support all of them, and versioning XML schemas using XML schema collections.

XQuery Performance and XML Indexes
In this module, I'm going to talk about XQuery performance, XQuery processing, and XML indexes. Knowing how this works is key if you want to build a performant application that uses XQuery and the XML data type. I'll discuss XQuery methods and processing, including querying non-indexed XML. Then I'll go on to talk about XML indexes, the types of XML indexes there are, how to create and maintain them, what the XML Node Table is, and how to query index XML, also usage of XML indexes. So there is one primary XML index and three possible secondary XML indexes. I'll discuss which index to use for each use case or for a specific use case. Then finally I'll end with some XQuery phrasing performance hints.

Hybrid Applications: Using XML and Relational Together
So far in this course, you've looked at the XML data type. XML schema support for XML data type. XQuery and XPath support. And performance considerations, of using the XML data type. Including XML indexes. In this module I'm going to wrap up by talking about hybrid applications. That is using relational and XML together. These are the type of applications that you will be building if you use XML and store your data in SQL Server database. So first we'll talk about data type choices. Including XML and SQL Server. Using relational and XML in conjunction. And BLOB storage considerations. Finally we'll talk about the hybrid apps. Including composition and decomposition routines. Like SELECT. . . FOR XML, OpenXml, and xml. nodes. And mixing XQuery and full-Text Search.