Using XML and XQuery Effectively with SQL Server

373.76 MB | 00:21:27 | wmv | 1024X768 | 4:3
Genre:eLearning |Language:English

Files Included :
01 Introduction.wmv (502.1 KB)
02 Overview of XML Support in SQL Server.wmv (5.11 MB)
03 Demo Using Linq To XML in SQLCLR (SQL Server 2008).wmv (5.7 MB)
04 Details of the XML Data Type.wmv (5.3 MB)
05 Demo Details of the XML Data Type.wmv (8.82 MB)
06 XML-Specific Technologies Supported by SQL Server.wmv (6.53 MB)
07 Summary.wmv (1.2 MB)
01 Introduction.wmv (369.47 KB)
02 XML Schema Collections - Definition.wmv (2.45 MB)
03 Demo Built-In XML Schemas.wmv (8.95 MB)
04 Defining and Using XML Schema Collections.wmv (2.81 MB)
05 Demo Defining and Using XML Schema Collections.wmv (14.94 MB)
06 XML Schema Metadata, Storage, Retrieval.wmv (1.18 MB)
07 Demo XML Schema Metadata, Storage, Retrieval.wmv (3.59 MB)
08 XML Schema Collection Permissions.wmv (823.56 KB)
09 Demo XML Schema Collection Permissions.wmv (5.33 MB)
10 XML Schema Support Limitations.wmv (1.77 MB)
11 Demo Lax Validation Support (SQL Server 2008).wmv (6.46 MB)
12 Versioning XML Schemas through Collections.wmv (1.23 MB)
13 Demo Versioning XML Schemas through Collections.wmv (6.56 MB)
14 Summary.wmv (918.18 KB)
01 Introduction - XQuery Input and Output.wmv (1.83 MB)
02 Demo XQuery Input and Output.wmv (3.06 MB)
03 XQuery Schema Support and Static Type Checking.wmv (2.33 MB)
04 Demo XQuery Schema Support and Static Type Checking.wmv (6.29 MB)
05 Sequences.wmv (661.56 KB)
06 Demo Sequences.wmv (3.12 MB)
07 Parts of an XQuery Program.wmv (538.81 KB)
08 Demo Parts of an XQuery Program.wmv (4.66 MB)
09 XPath and FLWOR.wmv (3.1 MB)
10 Demo XPath and FLWOR.wmv (2.67 MB)
11 Demo XPath Axes.wmv (4.64 MB)
12 FLWOR - for and let.wmv (2.71 MB)
13 Demo for vs let.wmv (4 MB)
14 FLWOR - constructors.wmv (4.52 MB)
15 Demo FLWOR - constructors.wmv (15.72 MB)
16 XQuery Functions and Operators Summary.wmv (3.93 MB)
01 Introduction The xml exist method.wmv (1.32 MB)
02 Demo The xml exist method.wmv (5.17 MB)
03 The the xml value method.wmv (2.29 MB)
04 Demo the xml value method.wmv (4.48 MB)
05 The xml query method.wmv (802.58 KB)
06 Demo the xml query method.wmv (3.72 MB)
07 Data Accessors data(), string(), and text().wmv (1.29 MB)
08 Demo Data Accessors.wmv (11.94 MB)
09 Relational Data in XQuery sqlvariable and sqlcolumn.wmv (708.09 KB)
10 Demo sqlvariable and sqlcolumn.wmv (4.68 MB)
11 The xml nodes method.wmv (1.26 MB)
12 Demo the xml nodes method.wmv (12.55 MB)
13 SQL Server internal use of XML.wmv (1.98 MB)
14 Demo Practical XML queries.wmv (15.07 MB)
15 The xml modify method.wmv (2.01 MB)
16 Demo the xml modify method.wmv (8.68 MB)
17 Summary.wmv (590.95 KB)
01 Introduction.wmv (605.08 KB)
02 XQuery processing in SQL query plans Querying unindexed XML.wmv (5.13 MB)
03 Demo Querying unindexed XML.wmv (29.69 MB)
04 The primary XML index.wmv (3.16 MB)
05 Demo the primary XML index.wmv (12.34 MB)
06 Secondary XML indexes.wmv (2.15 MB)
07 Demo Secondary XML indexes.wmv (7.41 MB)
08 XQuery performance tricks and tips.wmv (3.07 MB)
09 Demo XQuery performance tricks and tips.wmv (13.2 MB)
10 Summary.wmv (964.8 KB)
01 Introduction.wmv (768.71 KB)
02 Types of database data and XML usage.wmv (5.59 MB)
03 Demo Hoisting XML values to computed columns.wmv (3.34 MB)
04 Data type choice for large data in database applications.wmv (4.12 MB)
05 Hybrid Applications - SELECT FOR XML.wmv (2.22 MB)
06 Demo SELECT FOR XML dialects.wmv (7.07 MB)
07 SELECT FOR XML - SQL Server 2005 Enhancements.wmv (1.76 MB)
08 Demo SELECT FOR XML enhancements.wmv (14.66 MB)
09 Using OpenXML for decomposition.wmv (1.14 MB)
10 Demo Using OpenXML for decomposition.wmv (3.53 MB)
11 Using SQLCLR with XML.wmv (557.11 KB)
12 Demo SQLCLR XSLT example.wmv (1.69 MB)
13 Using XQuery in conjunction with Full-Text Search.wmv (823.79 KB)
14 Demo Using XQuery in conjunction with Full-Text Search.wmv (11.89 MB)
15 XML Usage and SQL Server support for hybrid apps Summary.wmv (4.24 MB)]
Screenshot