XML on SQL Server Training Course

forgot my password

Search:

Menu

Home

How it works?

Buy this course

	Discuss! Add a comment
	Add this course to my favorites
	Add a personal note
	RSS Feeds

Course's author:

Ruy Bentes Pimentel Neto

Ruy Bentes Pimentel Neto (ruy.pimentel@gmail.com) is a Senior Database Administrator, Dell Computers Employee, Hold MCDBA, MCSE+I Certifications. Experience of 10 years in Networking, Operational Systems and Database Administration.

Go to author's Space

Course stats:


Favorited:	0 times

no vote received

Features

	Textual content
	Video tutorial
	Exercise
	Source code
	Downloads
	Recommended post

Content

Notes

Discuss

Online course
E-learning- XML on SQL Server

This XML on SQL Server training course shows you how to retrieve and modify XML data, and describes how to convert between XML and relational data. You also see how you can optimize the new XML data type in SQL Server 2005 for data retrieval by using different types of indexes. Unlike relational data, XML data can represent structured, semi structured, and unstructured data. XML support in SQL Server 2005 is fully integrated with the relational engine and query optimizer, allowing the retrieval and modification of XML data and even the conversion between XML and relational data representations.

XML structures

V�deo
1) XML structures
Description: In this lesson you will learn about the XML structures, the storage options and the use of text columns to store XML. |
[Mark this item as viewed]

Data

V�deo
2) Store data using XML data type.
Description: In this lesson you will learn how to store data using XML data type. |
[Mark this item as viewed]

V�deo
3) XML Schemas
Description: In this lesson you will learn how to type and validate data unsing XML Schemas. |
[Mark this item as viewed]

V�deo
4) FOR XML RAW
Description: In this lesson will learn how to retrieve and modify XML data and describes how to convert between XML and relational data. |
[Mark this item as viewed]

V�deo
5) FOR XML AUTO
Description: In this lesson you will learn how to retrieve relational data formatted as a XML Fragment using the FOR XML AUTO clause. |
[Mark this item as viewed]

V�deo
6) FOR XML PATH
Description: In this lesson you will learn how to retrieve relational data formatted as a XML Fragment using the FOR XML PATH clause. |
[Mark this item as viewed]

V�deo
7) FOR XML EXPLICIT
Description: In this lesson you will learn how to retrieve relational data formatted as a XML Fragment using the FOR XML EXPLICIT clause. |
[Mark this item as viewed]

V�deo
8) XML Data Type, Xml Data Type Methods and FLWOR Expressions Clauses
Description: In this lesson you will learn how to retrieve data from XML Data Type, Xml Data Type Methods and FLWOR Expressions Clauses. |
[Mark this item as viewed]

Methods

V�deo
9) value() method, the exist() method and the modify() method
Description: In this lesson you will learn how to use the value() method, the exist() method and the modify() method. |
[Mark this item as viewed]

Relational Data

V�deo
10) Transform XML Data into Relational Data and How to use OPENXML
Description: In this lesson you will learn How to transform XML Data into Relational Data and How to use OPENXML. |
[Mark this item as viewed]