Using XML and XQuery Effectively with SQL Server [2010, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

Using XML and XQuery Effectively with SQL Server

Год выпуска: 2010
Производитель: Pluralsight
Сайт производителя: pluralsight.com
Автор: Bob Beauchemin
Продолжительность: 5:29
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: 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.
[spoiler="Содержание"]
XML Intro - The XML Data Type
Introduction
Overview of XML Support in SQL Server
Demo: Using Linq To XML in SQLCLR (SQL Server 2008)
Details of the XML Data Type
Demo: Details of the XML Data Type
XML-Specific Technologies Supported by SQL Server
Summary

XML Schema Support
Introduction
XML Schema Collections - Definition
Demo: Built-In XML Schemas
Defining and Using XML Schema Collections
Demo: Defining and Using XML Schema Collections
XML Schema Metadata, Storage, Retrieval
Demo: XML Schema Metadata, Storage, Retrieval
XML Schema Collection Permissions
Demo: XML Schema Collection Permissions
XML Schema Support Limitations
Demo: Lax Validation Support (SQL Server 2008)
Versioning XML Schemas through Collections
Demo: Versioning XML Schemas through Collections
Summary

XQuery Introduction
Introduction - XQuery Input and Output
Demo: XQuery Input and Output
XQuery Schema Support and Static Type Checking
Demo: XQuery Schema Support and Static Type Checking
Sequences
Demo: Sequences
Parts of an XQuery Program
Demo: Parts of an XQuery Program
XPath and FLWOR
Demo: XPath and FLWOR
Demo: XPath Axes
FLWOR - for and let
Demo: for vs let
FLWOR - constructors
Demo: FLWOR - constructors
XQuery Functions and Operators. Summary

XQuery: Using XQuery with XML data type methods
Introduction. The xml.exist method
Demo: The xml.exist method
The the xml.value method
Demo: the xml.value method
The xml.query method
Demo: the xml.query method
Data Accessors: data(), string(), and text()
Demo: Data Accessors
Relational Data in XQuery. sql:variable and sql:column
Demo: sql:variable and sql:column
The xml.nodes method
Demo: the xml.nodes method
SQL Server internal use of XML
Demo: Practical XML queries
The xml.modify method
Demo: the xml.modify method
Summary

XQuery Performance and XML Indexes
Introduction
XQuery processing in SQL query plans. Querying unindexed XML
Demo: Querying unindexed XML
The primary XML index
Demo: the primary XML index
Secondary XML indexes
Demo: Secondary XML indexes
XQuery performance tricks and tips
Demo: XQuery performance tricks and tips
Summary

Hybrid Applications: Using XML and Relational Together
Introduction
Types of database data and XML usage
Demo: Hoisting XML values to computed columns
Data type choice for large data in database applications
Hybrid Applications - SELECT... FOR XML
Demo: SELECT... FOR XML dialects
SELECT... FOR XML - SQL Server 2005 Enhancements
Demo: SELECT... FOR XML enhancements
Using OpenXML for decomposition
Demo: Using OpenXML for decomposition
Using SQLCLR with XML
Demo: SQLCLR XSLT example
Using XQuery in conjunction with Full-Text Search
Demo: Using XQuery in conjunction with Full-Text Search
XML Usage and SQL Server support for hybrid apps. Summary
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 4:3, 15fps, 150kbps
Аудио: WMA, 44.1kHz, 48kbps, mono
[spoiler="Скриншоты"]

[/spoiler]