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 1m
- XML Schema Collections - Definition 4m
- Demo: Built-In XML Schemas 5m
- Defining and Using XML Schema Collections 3m
- Demo: Defining and Using XML Schema Collections 12m
- XML Schema Metadata, Storage, Retrieval 2m
- Demo: XML Schema Metadata, Storage, Retrieval 3m
- XML Schema Collection Permissions 1m
- Demo: XML Schema Collection Permissions 4m
- XML Schema Support Limitations 3m
- Demo: Lax Validation Support (SQL Server 2008) 4m
- Versioning XML Schemas through Collections 2m
- Demo: Versioning XML Schemas through Collections 5m
- Summary 1m
- Introduction - XQuery Input and Output 3m
- Demo: XQuery Input and Output 3m
- XQuery Schema Support and Static Type Checking 4m
- Demo: XQuery Schema Support and Static Type Checking 5m
- Sequences 1m
- Demo: Sequences 3m
- Parts of an XQuery Program 1m
- Demo: Parts of an XQuery Program 4m
- XPath and FLWOR 5m
- Demo: XPath and FLWOR 2m
- Demo: XPath Axes 3m
- FLWOR - for and let 4m
- Demo: for vs let 4m
- FLWOR - constructors 7m
- Demo: FLWOR - constructors 11m
- XQuery Functions and Operators. Summary 6m
- Introduction. The xml.exist method 2m
- Demo: The xml.exist method 3m
- The the xml.value method 3m
- Demo: the xml.value method 4m
- The xml.query method 1m
- Demo: the xml.query method 2m
- Data Accessors: data(), string(), and text() 2m
- Demo: Data Accessors 9m
- Relational Data in XQuery. sql:variable and sql:column 1m
- Demo: sql:variable and sql:column 3m
- The xml.nodes method 2m
- Demo: the xml.nodes method 10m
- SQL Server internal use of XML 3m
- Demo: Practical XML queries 9m
- The xml.modify method 3m
- Demo: the xml.modify method 5m
- Summary 1m
- Introduction 1m
- XQuery processing in SQL query plans. Querying unindexed XML 7m
- Demo: Querying unindexed XML 21m
- The primary XML index 4m
- Demo: the primary XML index 8m
- Secondary XML indexes 3m
- Demo: Secondary XML indexes 5m
- XQuery performance tricks and tips 5m
- Demo: XQuery performance tricks and tips 8m
- Summary 1m
- Introduction 1m
- Types of database data and XML usage 7m
- Demo: Hoisting XML values to computed columns 2m
- Data type choice for large data in database applications 5m
- Hybrid Applications - SELECT... FOR XML 3m
- Demo: SELECT... FOR XML dialects 6m
- SELECT... FOR XML - SQL Server 2005 Enhancements 3m
- Demo: SELECT... FOR XML enhancements 5m
- Using OpenXML for decomposition 2m
- Demo: Using OpenXML for decomposition 3m
- Using SQLCLR with XML 1m
- Demo: SQLCLR XSLT example 2m
- Using XQuery in conjunction with Full-Text Search 1m
- Demo: Using XQuery in conjunction with Full-Text Search 4m
- XML Usage and SQL Server support for hybrid apps. Summary 4m
About the author
Bob Beauchemin is a database-centric application practitioner and architect, instructor, course author, writer, and Developer Skills Partner for SQL skills. Over the past few years he's been writing and teaching his SQL Server 2005 and 2008 courses to students worldwide through the Ascend program, the Metro (SQL Server 2008 Jumpstart) program, and client-centric classes. 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", ... more