Below info from Steve Cable:
Microsoft’s websitefor this exam has a long list of training materials.
For me, Step 1 was to read the book that Microsoft calls the Self-Paced Training Kit. That book is definitely mandatory. I read that at least twice. And just as important, I did ALL the practices too.
But when I took the assessment test on the disk included with that book, it was like I didn't know anything. There are 200 sample questions. I would try, say 10 questions, and get 1 right. The book simply did not cover anywhere near the amount of material referenced by those questions.
Step 2. I happened to have a copy of the SQL Server 2008 Internalsbook by Delaney et.al, which covers a lot of these same topics. That helped fill-in a number of gaps. Sometimes that book went WAY further into the internals than anyone needs to know for this test. When that happened it was easy-enough to turn the page until it related to me again. After that I could get 3 out of 10 questions right.
Step 3. I read The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit: Database Design, edited by Horniger. I’m willing to say that was helpful. If you are going to take this test, I think it is definitely worth reading. I have to admit it really irritated me that some chapters seemed to have a misspelled word or grammatical error on every page. If we have all the time in the world, I have to think a team of us can write a better book than they did. But it was helpful. After that I could get 5 out of 10 right.
Step 4. I read DeBetta's free Introduction to SQL Server 2008. You can’t read the same thing over and over again. Every additional author gives you a new way of thinking about things. He has provided a great service to our community by providing a readable, good quality explanation full of good ideas. It may be free, but it’s a keeper on my bookshelf.
Step 5. After all that, it was still not enough. So basically I decided I had to write, or at least assemble, my own book. I mean, I would read a question, and say to myself, "Wow, I just do NOT know enough about that yet." So I would do a Google Search, and find some article or blog about it, and paste that into a Word document for the things I needed to know more about myself. I assembled over 180 pages of such notes.
Step 6. After that, the only thing left I could do was build my test-taking muscles. The book(s) will tell you what you CAN do. But the practice questions will help you see the LIMITs.
For example, I knew you can insert into view (with restrictions), and you can use the OUTPUT clause to return changed data back to the screen, or insert it to a table, or into a table variable, but OUTPUT cannot insert into a view. I can only remember such factoids if a practice question gives me a reason to.
Or, do you know that SET SHOWPLAN ON will show you the ACTUAL execution plan, while SET SHOWPLAN_XML ON will show you the ESTIMATED execution plan. I cringe to think about what my brain has to do to remember such details!
Because, practice does not make perfect. PERFECT PRACTICE makes perfect. If I didn't know the answer to a practice question, there is no point in guessing. Nor is there any point to simply learning the answer to 1 question. The best way to meet the challenge is to go study that on the spot.