Using XML and XQuery Effectively with SQL Server
Pluralsight
Course Summary
Using XML Technologies in SQL Server to create hybrid relational-XML applications
-
+
Course 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.
-
+
Course Syllabus
XML Intro - The XML Data Type- 40m 54s
—Introduction 0m 47s
—Overview of XML Support in SQL Server 7m 43s
—Demo: Using Linq To XML in SQLCLR (SQL Server 2008) 4m 43s
—Details of the XML Data Type 7m 44s
—Demo: Details of the XML Data Type 8m 21s
—XML-Specific Technologies Supported by SQL Server 10m 29s
—Summary 1m 7sXML Schema Support- 48m 56s
—Introduction 0m 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 1sXQuery Introduction- 1h 4mXQuery: Using XQuery with XML data type methods- 1h 3mXQuery Performance and XML Indexes- 1h 3mHybrid Applications: Using XML and Relational Together- 47m 51s
This course is listed under
Development & Implementations
and Data & Information Management
Community
Related Posts: