Description:

This is a full day course (8 hours) that covers the XML capabilities of SQL Server in detail. Topics covered includes SQL Server's capability to generate XML (FOR XML), Query XML (XQuery), Validate XML (XML Schema Collections - XSD), Load XML (OPENROWSET, XMLBulkLoad and SSIS), XML Best Practices, Optimization tips and tricks, XML Indexes etc.