FileMood

Download Pluralsight - Using XML and XQuery Effectively with SQL Server

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


Copyright © 2025 FileMood.com