- Course
- Data
Using XML and XQuery Effectively with SQL Server
Using XML Technologies in SQL Server to create hybrid relational-XML applications
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.
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
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.