Hi All,

Im looking at giving 70-229 as an elective for MCSD. I dont know much about SQL 2000. I tried reading the MS training kit for this paper but it seems to b quite advanced as the material after the first chapter started going right over my head.

what books did the ppl who have cleared this paper use to study??

Preferably books that cover the entire syllabus for this paper.

Would app any feedback on this.

Thanks

Report this post to a moderator

Here's a good site to look for books,

www.bookpool.com
www.bn.com
www.amazon.com

These sites all have reviews and recommendations, MS books are clear for the break everything into lesson summaries. Just read into it slowly and pacely.

Best of luck to you

__________________
Riding the endless light of fortunes...

http://www.darkroads.com

Report this post to a moderator

quote:

---

Originally posted by quasibuddha

Preferably books that cover the entire syllabus for this paper.


Thanks [/B]

---

Report this post to a moderator

The best place t oget info for 70-229 is right from the horses mouth. Microsoft's 70-229 book is great. If you just want to learn about SQL, point blank, get "SQL fro Dummies" It explains all about Structured Query language. IBM, Oracle, Microsoft has their own interpretation of it. 229 deals with database design, so a book on Database design would be great too. Consider 228 or 028 over 229 it's like crawling before walking.

__________________
Click here to email me

Report this post to a moderator

hi.

thanks guys for ur input. Well im giving this exam as an elective for MCSD. I dont know if 228 is included there. I have the MS Press Training Kit. Just dont know if it covers everything in the syllabus and if its the best study guide around.

Atleast in the case of VB exams (70-175,70-176), Books by other publishers beat MS Press Training Kit hands-down. Thats why i was wondering if there is a similar case for the SQL paper too.

Although it would b nice to get some real foundations in Database Design before revving up to give this paper, unfortunately i dont have that luxury as i have to get this paper over n done with ASAP. So it would b nice if any 1 book could really get me up n ready for this exam.

Report this post to a moderator

don't waste your time with these books, you need only the SQL Books Online

Report this post to a moderator

70-229 is likely similar in level of difficulty to 70-029, the hardest of the 7 MCP exams I have passed in the last 5 months. From the feedback I've seen, one or more failed attempts at this exam is common.

I used the Sybex book, the official MS self-paced training kit, and Transcenders to pass 70-029 on the first attempt. The last tool was extremely important in my success here, as there were important areas on the exam not covered by either the Sybex or MS tools.

If you are a newbie to SQL Server and SQL, I sincerely doubt that you would be able to pass the exam using just the Books Online.

RD

Report this post to a moderator

I managed to pass 70-229 last week. I didn't get the score I expected, but hey - I passed!

You need to be very familiar with TSQL (duh), since a lot of questions require you to read and understand code snippets.

As for preparing - SQL Server Books Online have all the info, but are hard to study from. I kinda like the MSPress training kit book. As usual it's quite shallow, but gives you a good sense of direction and coupled with BOL it makes for a good course.

Report this post to a moderator

don't forget, there is a new version (2001.09) of Books Online

I've got the mspress training kits, and I read braindumps, there are questions you cannot answer from these.

Report this post to a moderator

quasibuddha,
your comments about the MS training kits reasonably match the book review comments of those at amazon.com for the MS 70-229 study guide i.e that this one isnt so good. I would recommend using amazon.com to read the reviews of people's comments on other SQL Server books for this exam and any other exam - it doesnt necessarily make the choice clear cut but it does give an indication...
I used Inside SQL Server 2000 but i wouldnt recommend it as a read from start to finish, more as a reference to use with BOL.

Report this post to a moderator