| Author |
Study Material for 70-229?
|
|
| quasibuddha 2002-04-01, 3:37 am |
| 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 | |
| cross36 2002-04-01, 9:53 am |
| 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 | |
|
| quote:
Originally posted by quasibuddha
Preferably books that cover the entire syllabus for this paper.
Thanks [/B]
Check out Microsoft's training kit (ISBN: 0-7356-1248-x). It contains an eval version of SQL Server 2000 as well, and therefore also Books Online.
Apart from that, go down to the nearest, large book store. They're bound to have a few shelves on certification and a few shelves on SQL Server.
Good luck! | |
| Swigga 2002-04-01, 12:05 pm |
| 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. | |
| quasibuddha 2002-04-02, 1:10 am |
| 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. | |
| bitazoli 2002-04-08, 6:12 am |
| don't waste your time with these books, you need only the SQL Books Online | |
| DivxGuy 2002-04-08, 3:52 pm |
| 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 | |
|
| 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. | |
| bitazoli 2002-04-10, 12:57 am |
| 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. | |
| fattyreflyer 2002-04-22, 7:56 pm |
| 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. | |
| BOLAJIKAMORU 2002-05-01, 7:55 am |
| MS Training kit might be a bit difficult for somebody who is new to T-SQL commands. I would rather suggest you sit for 70-228 b4 70-229, provided it is recognized as one of the electives for MCSD. Or better still, get some Introductory material on SQL in addition to the MS Kit.
Best of luck. | |
| emulti 2002-05-01, 7:42 pm |
| Have to say I am much more interested in 229 than 228 since I much more of a T-SQL/SQL buff.
I think it's a good idea to cover all the new stuff in 2000 compared with v7 such as:
Functions
XML output
Indexed views
TABLE variables
INSTEAD OF triggers
And review DERIVED TABLES . This is an SQL technique rather than version upgrade. But they are heavily used in sql select statements.
Also review locking and transactions. |
|
|
|