Pluralsight - Using XML and XQuery Effectively with SQL Server

1. XML Intro - The XML Data Type/01. Introduction.wmv

502.1 KB

1. XML Intro - The XML Data Type/02. Overview of XML Support in SQL Server.wmv

5.11 MB

1. XML Intro - The XML Data Type/03. Demo Using Linq To XML in SQLCLR (SQL Server 2008).wmv

5.7 MB

1. XML Intro - The XML Data Type/04. Details of the XML Data Type.wmv

5.3 MB

1. XML Intro - The XML Data Type/05. Demo Details of the XML Data Type.wmv

8.82 MB

1. XML Intro - The XML Data Type/06. XML-Specific Technologies Supported by SQL Server.wmv

6.53 MB

1. XML Intro - The XML Data Type/07. Summary.wmv

1.2 MB

2. XML Schema Support/01. Introduction.wmv

369.47 KB

2. XML Schema Support/02. XML Schema Collections - Definition.wmv

2.45 MB

2. XML Schema Support/03. Demo Built-In XML Schemas.wmv

8.95 MB

2. XML Schema Support/04. Defining and Using XML Schema Collections.wmv

2.81 MB

2. XML Schema Support/05. Demo Defining and Using XML Schema Collections.wmv

14.94 MB

2. XML Schema Support/06. XML Schema Metadata, Storage, Retrieval.wmv

1.18 MB

2. XML Schema Support/07. Demo XML Schema Metadata, Storage, Retrieval.wmv

3.59 MB

2. XML Schema Support/08. XML Schema Collection Permissions.wmv

823.56 KB

2. XML Schema Support/09. Demo XML Schema Collection Permissions.wmv

5.33 MB

2. XML Schema Support/10. XML Schema Support Limitations.wmv

1.77 MB

2. XML Schema Support/11. Demo Lax Validation Support (SQL Server 2008).wmv

6.46 MB

2. XML Schema Support/12. Versioning XML Schemas through Collections.wmv

1.23 MB

2. XML Schema Support/13. Demo Versioning XML Schemas through Collections.wmv

6.56 MB

2. XML Schema Support/14. Summary.wmv

918.18 KB

3. XQuery Introduction/01. Introduction - XQuery Input and Output.wmv

1.83 MB

3. XQuery Introduction/02. Demo XQuery Input and Output.wmv

3.06 MB

3. XQuery Introduction/03. XQuery Schema Support and Static Type Checking.wmv

2.33 MB

3. XQuery Introduction/04. Demo XQuery Schema Support and Static Type Checking.wmv

6.29 MB

3. XQuery Introduction/05. Sequences.wmv

661.56 KB

3. XQuery Introduction/06. Demo Sequences.wmv

3.12 MB

3. XQuery Introduction/07. Parts of an XQuery Program.wmv

538.81 KB

3. XQuery Introduction/08. Demo Parts of an XQuery Program.wmv

4.66 MB

3. XQuery Introduction/09. XPath and FLWOR.wmv

3.1 MB

3. XQuery Introduction/10. Demo XPath and FLWOR.wmv

2.67 MB

3. XQuery Introduction/11. Demo XPath Axes.wmv

4.64 MB

3. XQuery Introduction/12. FLWOR - for and let.wmv

2.71 MB

3. XQuery Introduction/13. Demo for vs let.wmv

4 MB

3. XQuery Introduction/14. FLWOR - constructors.wmv

4.52 MB

3. XQuery Introduction/15. Demo FLWOR - constructors.wmv

15.72 MB

3. XQuery Introduction/16. XQuery Functions and Operators. Summary.wmv

3.93 MB

4. XQuery Using XQuery with XML data type methods/01. Introduction. The xml.exist method.wmv

1.32 MB

4. XQuery Using XQuery with XML data type methods/02. Demo The xml.exist method.wmv

5.17 MB

4. XQuery Using XQuery with XML data type methods/03. The the xml.value method.wmv

2.29 MB

4. XQuery Using XQuery with XML data type methods/04. Demo the xml.value method.wmv

4.48 MB

4. XQuery Using XQuery with XML data type methods/05. The xml.query method.wmv

802.58 KB

4. XQuery Using XQuery with XML data type methods/06. Demo the xml.query method.wmv

3.72 MB

4. XQuery Using XQuery with XML data type methods/07. Data Accessors data(), string(), and text().wmv

1.29 MB

4. XQuery Using XQuery with XML data type methods/08. Demo Data Accessors.wmv

11.94 MB

4. XQuery Using XQuery with XML data type methods/09. Relational Data in XQuery. sqlvariable and sqlcolumn.wmv

708.09 KB

4. XQuery Using XQuery with XML data type methods/10. Demo sqlvariable and sqlcolumn.wmv

4.68 MB

4. XQuery Using XQuery with XML data type methods/11. The xml.nodes method.wmv

1.26 MB

4. XQuery Using XQuery with XML data type methods/12. Demo the xml.nodes method.wmv

12.55 MB

4. XQuery Using XQuery with XML data type methods/13. SQL Server internal use of XML.wmv

1.98 MB

4. XQuery Using XQuery with XML data type methods/14. Demo Practical XML queries.wmv

15.07 MB

4. XQuery Using XQuery with XML data type methods/15. The xml.modify method.wmv

2.01 MB

4. XQuery Using XQuery with XML data type methods/16. Demo the xml.modify method.wmv

8.68 MB

4. XQuery Using XQuery with XML data type methods/17. Summary.wmv

590.95 KB

5. XQuery Performance and XML Indexes/01. Introduction.wmv

605.08 KB

5. XQuery Performance and XML Indexes/02. XQuery processing in SQL query plans. Querying unindexed XML.wmv

5.13 MB

5. XQuery Performance and XML Indexes/03. Demo Querying unindexed XML.wmv

29.69 MB

5. XQuery Performance and XML Indexes/04. The primary XML index.wmv

3.16 MB

5. XQuery Performance and XML Indexes/05. Demo the primary XML index.wmv

12.34 MB

5. XQuery Performance and XML Indexes/06. Secondary XML indexes.wmv

2.15 MB

5. XQuery Performance and XML Indexes/07. Demo Secondary XML indexes.wmv

7.41 MB

5. XQuery Performance and XML Indexes/08. XQuery performance tricks and tips.wmv

3.07 MB

5. XQuery Performance and XML Indexes/09. Demo XQuery performance tricks and tips.wmv

13.2 MB

5. XQuery Performance and XML Indexes/10. Summary.wmv

964.8 KB

6. Hybrid Applications Using XML and Relational Together/01. Introduction.wmv

768.71 KB

6. Hybrid Applications Using XML and Relational Together/02. Types of database data and XML usage.wmv

5.59 MB

6. Hybrid Applications Using XML and Relational Together/03. Demo Hoisting XML values to computed columns.wmv

3.34 MB

6. Hybrid Applications Using XML and Relational Together/04. Data type choice for large data in database applications.wmv

4.12 MB

6. Hybrid Applications Using XML and Relational Together/05. Hybrid Applications - SELECT... FOR XML.wmv

2.22 MB

6. Hybrid Applications Using XML and Relational Together/06. Demo SELECT... FOR XML dialects.wmv

7.07 MB

6. Hybrid Applications Using XML and Relational Together/07. SELECT... FOR XML - SQL Server 2005 Enhancements.wmv

1.76 MB

6. Hybrid Applications Using XML and Relational Together/08. Demo SELECT... FOR XML enhancements.wmv

14.66 MB

6. Hybrid Applications Using XML and Relational Together/09. Using OpenXML for decomposition.wmv

1.14 MB

6. Hybrid Applications Using XML and Relational Together/10. Demo Using OpenXML for decomposition.wmv

3.53 MB

6. Hybrid Applications Using XML and Relational Together/11. Using SQLCLR with XML.wmv

557.11 KB

6. Hybrid Applications Using XML and Relational Together/12. Demo SQLCLR XSLT example.wmv

1.69 MB

6. Hybrid Applications Using XML and Relational Together/13. Using XQuery in conjunction with Full-Text Search.wmv

823.79 KB

6. Hybrid Applications Using XML and Relational Together/14. Demo Using XQuery in conjunction with Full-Text Search.wmv

11.89 MB

6. Hybrid Applications Using XML and Relational Together/15. XML Usage and SQL Server support for hybrid apps. Summary.wmv

4.24 MB

资源详情

免责声明