Pluralsight Using XML and XQuery Effectively with SQL Server | 26939A703AEC5BCBF29EB0AF8AFDC876529664F1

Pluralsight Using XML and XQuery Effectively with SQL Server

Name	Pluralsight - Using XML and XQuery Effectively with SQL Server	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	391.9 MB
Total Files	79
Hash	26939A703AEC5BCBF29EB0AF8AFDC876529664F1

/1. XML Intro - The XML Data Type/
01. Introduction.wmv	514.2 KB
02. Overview of XML Support in SQL Server.wmv	5.4 MB
03. Demo Using Linq To XML in SQLCLR (SQL Server 2008).wmv	6.0 MB
04. Details of the XML Data Type.wmv	5.6 MB
05. Demo Details of the XML Data Type.wmv	9.3 MB
06. XML-Specific Technologies Supported by SQL Server.wmv	6.8 MB
07. Summary.wmv	1.3 MB
/2. XML Schema Support/
01. Introduction.wmv	378.3 KB
02. XML Schema Collections - Definition.wmv	2.6 MB
03. Demo Built-In XML Schemas.wmv	9.4 MB
04. Defining and Using XML Schema Collections.wmv	2.9 MB
05. Demo Defining and Using XML Schema Collections.wmv	15.7 MB
06. XML Schema Metadata, Storage, Retrieval.wmv	1.2 MB
07. Demo XML Schema Metadata, Storage, Retrieval.wmv	3.8 MB
08. XML Schema Collection Permissions.wmv	843.3 KB
09. Demo XML Schema Collection Permissions.wmv	5.6 MB
10. XML Schema Support Limitations.wmv	1.9 MB
11. Demo Lax Validation Support (SQL Server 2008).wmv	6.8 MB
12. Versioning XML Schemas through Collections.wmv	1.3 MB
13. Demo Versioning XML Schemas through Collections.wmv	6.9 MB
14. Summary.wmv	940.2 KB
/3. XQuery Introduction/
01. Introduction - XQuery Input and Output.wmv	1.9 MB
02. Demo XQuery Input and Output.wmv	3.2 MB
03. XQuery Schema Support and Static Type Checking.wmv	2.4 MB
04. Demo XQuery Schema Support and Static Type Checking.wmv	6.6 MB
05. Sequences.wmv	677.4 KB
06. Demo Sequences.wmv	3.3 MB
07. Parts of an XQuery Program.wmv	551.7 KB
08. Demo Parts of an XQuery Program.wmv	4.9 MB
09. XPath and FLWOR.wmv	3.3 MB
10. Demo XPath and FLWOR.wmv	2.8 MB
11. Demo XPath Axes.wmv	4.9 MB
12. FLWOR - for and let.wmv	2.8 MB
13. Demo for vs let.wmv	4.2 MB
14. FLWOR - constructors.wmv	4.7 MB
15. Demo FLWOR - constructors.wmv	16.5 MB
16. XQuery Functions and Operators. Summary.wmv	4.1 MB
/4. XQuery Using XQuery with XML data type methods/
01. Introduction. The xml.exist method.wmv	1.4 MB
02. Demo The xml.exist method.wmv	5.4 MB
03. The the xml.value method.wmv	2.4 MB
04. Demo the xml.value method.wmv	4.7 MB
05. The xml.query method.wmv	821.8 KB
06. Demo the xml.query method.wmv	3.9 MB
07. Data Accessors data(), string(), and text().wmv	1.4 MB
08. Demo Data Accessors.wmv	12.5 MB
09. Relational Data in XQuery. sqlvariable and sqlcolumn.wmv	725.1 KB
10. Demo sqlvariable and sqlcolumn.wmv	4.9 MB
11. The xml.nodes method.wmv	1.3 MB
12. Demo the xml.nodes method.wmv	13.2 MB
13. SQL Server internal use of XML.wmv	2.1 MB
14. Demo Practical XML queries.wmv	15.8 MB
15. The xml.modify method.wmv	2.1 MB
16. Demo the xml.modify method.wmv	9.1 MB
17. Summary.wmv	605.1 KB
/5. XQuery Performance and XML Indexes/
01. Introduction.wmv	619.6 KB
02. XQuery processing in SQL query plans. Querying unindexed XML.wmv	5.4 MB
03. Demo Querying unindexed XML.wmv	31.1 MB
04. The primary XML index.wmv	3.3 MB
05. Demo the primary XML index.wmv	12.9 MB
06. Secondary XML indexes.wmv	2.3 MB
07. Demo Secondary XML indexes.wmv	7.8 MB
08. XQuery performance tricks and tips.wmv	3.2 MB
09. Demo XQuery performance tricks and tips.wmv	13.8 MB
10. Summary.wmv	988.0 KB
/6. Hybrid Applications Using XML and Relational Together/
01. Introduction.wmv	787.2 KB
02. Types of database data and XML usage.wmv	5.9 MB
03. Demo Hoisting XML values to computed columns.wmv	3.5 MB
04. Data type choice for large data in database applications.wmv	4.3 MB
05. Hybrid Applications - SELECT... FOR XML.wmv	2.3 MB
06. Demo SELECT... FOR XML dialects.wmv	7.4 MB
07. SELECT... FOR XML - SQL Server 2005 Enhancements.wmv	1.8 MB
08. Demo SELECT... FOR XML enhancements.wmv	15.4 MB
09. Using OpenXML for decomposition.wmv	1.2 MB
10. Demo Using OpenXML for decomposition.wmv	3.7 MB
11. Using SQLCLR with XML.wmv	570.5 KB
12. Demo SQLCLR XSLT example.wmv	1.8 MB
13. Using XQuery in conjunction with Full-Text Search.wmv	843.6 KB
14. Demo Using XQuery in conjunction with Full-Text Search.wmv	12.5 MB
15. XML Usage and SQL Server support for hybrid apps. Summary.wmv	4.4 MB
Total files 79