SQL Server and XML Query
XML was added to the collection of SQL Server native data types in SQL Server 2005. Being a complex data type, not only is XML accompanied by a set of dedicated T-SQL functions, but also with a complete querying language. In this session you will learn about the Microsoft SQL Server 2008 implementation of the World Wide Web Consortium's XML Query Recommendation, and learn:
- How to compose XML data – from existing SQL Server data or simply "from scratch";
- How to retrieve (relational) data from XML Documents to be used in a SQL Server database; and
- How to manipulate XML data using Transact-SQL and the XML Data Manipulation Language (XML DML).
You've already mastered all the primitive SQL Server data types, why would XML be an exception?
Sorry, there are no downloads available for this session.
Matija Lah is an independent consultant in the general and legal information management domains. Data warehousing represents and essential data management element in practically any business domain and Matija has had the opportunity to solve a variety of data warehousing problems since he started working with data warehouses in 2001. He shares many of his experiences in his blog at http://milambda.blogspot.com
, and is one of the authors in the popular book series SQL Server MVP Deep Dives. He is a frequent speaker on conferences related to technologies built on top of Microsoft platforms, especially conferences dedicated to Microsoft SQL Server. Matija has been a Microsoft Most Valuable Professional for SQL Server since 2007, and is a mentor in SolidQ, a trusted global provider of advanced consulting, mentoring and education solutions for the Microsoft platforms.
The video is not available to view online.