Microsoft Exam 70-433 (part 6)

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
  • 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

By Shannon Lowder

Shannon Lowder is the Database Engineer you've been looking for! Look no further for expertise in: Business Analysis to gather the business requirements for the database; Database Architecting to design the logical design of the database; Database Development to actually build the objects needed by the business logic; finally, Database Administration to keep the database running in top form, and making sure there is a disaster recovery plan.

3 comments

  1. why did you stop with the detailed explanations. i found it very useful and easier to understand then some books

    1. I do have more posts on the 70-433, you’re right though, I need to link these items to articles that relate. I added some links in now. Unfornately I found that there are still many more topics to cover. Are there any specific questions about XML on the 70-433? There are at least 9 topics I found in this article I haven’t covered yet. Is there a particular one you’d like me to cover next?

Leave a comment

Your email address will not be published. Required fields are marked *