Read the outline from MS and then search on those topics (hopefully here ) and study each area. We have a book for sale, Two Minute SQL Server Stumpers, that will quiz you on all aspects of SQL Server. Measure Up and Transceder have good preparation products as well.