- Course
Using XML and XQuery Effectively with SQL Server
Using XML Technologies in SQL Server to create hybrid relational-XML applications
Intermediate
- Course
Using XML and XQuery Effectively with SQL Server
Using XML Technologies in SQL Server to create hybrid relational-XML applications
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
Using XML and XQuery Effectively with SQL Server
Intermediate
Table of contents
-
Introduction | 33s
-
XML Schema Collections - Definition | 3m 33s
-
Demo: Built-In XML Schemas | 4m 46s
-
Defining and Using XML Schema Collections | 3m 20s
-
Demo: Defining and Using XML Schema Collections | 11m 35s
-
XML Schema Metadata, Storage, Retrieval | 1m 40s
-
Demo: XML Schema Metadata, Storage, Retrieval | 2m 53s
-
XML Schema Collection Permissions | 1m 9s
-
Demo: XML Schema Collection Permissions | 4m 15s
-
XML Schema Support Limitations | 2m 58s
-
Demo: Lax Validation Support (SQL Server 2008) | 4m 16s
-
Versioning XML Schemas through Collections | 1m 47s
-
Demo: Versioning XML Schemas through Collections | 5m 10s
-
Summary | 1m 1s
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.