I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those topics. If you have any questions, let me know!
Working with XML Data (12 percent)
-
Retrieve relational data as XML.
This objective may include but is not limited to: FOR XML - Check out articles on FOR XML AUTO, FOR XML RAW, FOR XML PATH, and FOR XML EXPLICIT
-
Transform XML data into relational data.
This objective may include but is not limited to: OPENXML, sp_xml_preparedocument, sp_xml_removedocument - I need to add some articles on these, until then, check out books online.
-
Query XML data.
This objective may include but is not limited to: XQUERY, XPATH -
Manage XML data.
This objective may include but is not limited to: XML datatype, XML indexes, XML schema collections