• The best place to find approved study materials is from Microsoft. The exam page is here. http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-451&locale=en-us#tab3

    They list some resources but not a lot for direct prep materials for this exam. Apparently there is nothing from MS press on this one either.

    They do list the topics covered. This might be a good place to start. As far as pointing to you a specific location I am afraid I am not going to be much, if any, help.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/