5 comments about MCSE/MCSD: SQL Server 7 Database Design Study Guide.

1. When I bought it in November the rating was 3.5-4 stars, so I decided that if I go through it I would be ready, I was very mistaken. After wasting months preparing, I FINALLY understood that there are so many errors, that it is worthless. And now after passing an exam, I can say that the text is not even close to the content of the exam. Do not waste you time with this book, buy Transcender exams (what I did eventually) and study them, and you will pass.



2. I find the book is reasonably systematic and as long as getting your certification is more a formality than it is about learning a lot of new stuff, this book should be fine. Most of the errors stand out. But is nonetheless ridiculous sending out a book with so many mistakes. All they really needed to do was to run all SQL expressions thru' the Query Analyzer right before deadline.

   And don't count on the errata list on the Sybex site. It's far from a comprehensive list.

   If you expect you have to learn a lot of new stuff, go for some other book. Wrox, Osborne has great books.




3. I've used Sybex books exclusively for MS exams and have alwayspassed with flying colors. With that in mind, I bought this book,expecting the same quality. This book is in sad shape, and PLEASE takemy words and everyone else who has posted on this book.... DON'T WASTEYOUR MONEY...This was the first exam that I've failed and this bookdoesn't hold a candle to the information and detail you mustcomprehend to successfully sit this 3 hourexam. (MCP,MCSE,MCP+I,MCSE+I,A+,N+,I-Net+,CCNA, and hopefully soonwill be MCDBA!)



4. I agree with a lot of the reviews here, the editing is not up to par, but the content and the writing style are! How do I know? I passed the exam on the first try.



5. The book is well-written and easy to understand. However, it's also very elementary. It would be a great beginner's intro to SQL Server, but as a MCDBA study guide - no way !! If this is your test preparation, you don't have a prayer of passing the exam

No comments about IBM WebSphere and VisualAge for Java Database Integration with DB2, Oracle, and SQL Server (IBM Redbook).

No comments about Administration et Optimisation de Microsoft SQL 2000 Server.

No comments about A Fondo Microsoft SQL Server 7.0 - Con 1 CD-ROM.

5 comments about MCSE SQL 7 Database Design and Administration Practice Tests Exam Cram (Exam: 70-028, 70-079).

1. I would not purchase this book then expect to automatically pass the exam(s), but you will not find 300 exam-style review questions spanning 2 exams for this price anywhere. I wrote and passed exam 70-029 which was my last for the MCSD designation. If the core exams for the MCSD are considered difficult, then 70-029 is near impossible. No one single studying source will get you through it. There are some errors in this book, and believe me, you will never get a question on the real exam testing your knowledge of the SQL syntax for simply creating a table. But those are minor complaints paired against the value this book brings in its explanations for each question, and the sheer number of questions contained within.

   I must give this book a high rating simply by virtue of the fact that I used it as one of my studying resources for the 70-029, and I passed.




2. Agree with previous reviewer: lots of questions for low price. However, some questions used terms (like deadly embrace) for which I can find no reference in any other material (including BOL). After scoring my answers, I reviewed their expla- nation of why the answers are right/wrong. I frequently verified these answers using BOL and discovered that about 3 to 5 answers for each exam disagreed with BOL. Having looked at some of the braindump websites, I would expect this of those sources, but not from this kind of published book. Next I will use Transcender. If I have time before my DBA and D&I exams, I will go back and verify **all** answers.



3. I just recently passed the 70-029 test on my first attempt with this book as one of my resources for practice. The questions are thought provoking and difficult, but with many errors in the questions and answers I would hesitate to recommend it. I spent too much valuable study time trying to figure out whether their questions were wrong or not. The publishers need to add erata to their site to help with this issue. That aside, this book did help me to identify some areas where I needed more study.



4. I have never asked for my $ back for a book, but I am on this one. I took Practice Test 1: Almost 1 in 4 (13 out of 55) questions either have typos that would make the "correct" answer syntactically invalid, outright wrong "correct" answers, or very questionable "correct" answers. Q3. Typo: "VALUE" instead of "VALUES" Q7. Question is "What is relationship between Actors or Directors and Title." Answer incorrectly says "Many to Many". This would be true if question was "What is relationship between Actors and Directors." (One Actor can be directed by many Directors and one Director can direct many Actors). The title table is the resolution table for the many-to-many relationship between Actors and Directors. But per the question, one Actor can act in many titles; one Director can Direct many Titles. Q11. What is meant by the words "main" or "independent" entities? Where do these words come from? PaintScheme and OptionalEquipment should indeed be entities, but main? or independent? Also, recommends Customer table be keyed on Social Security numbers. These are not really unique (as they are supposed to be). Most pros would say this is a bad idea for a primary key. Q14. Since when is "Many to One" not a valid relationship cardinality? By convention, most people look at relationships like this as One to Many. It depends on which entity is your point of reference. Many to One is simply the inverse of One to Many; both are equally real and valid. Q16: Question refers to data type "text" generically in the question, but in the DDL mixes type text with type varchar. Q17: Question about relationship optionality. "Self-Recursive" is a word? Isn't that a tautology? What does recursive have to do with optionality? Q20: ">" sign is wrong for all answers according to the wording of the question. Should be "<" or "<=". Q22: Typo: "ANDprice" instead of "AND price" Q26: Adding memory to remote clients is not a hardware solution for poor performance? In a client/server environment? What about large, locally cached cursors? Q27. Question presupposes that we know and remember the exact schema of the (I assume) pubs database. Option "b" won't work because of ambiquous column names. This is true only because the particular data model chosen for pubs. It has nothing to do with SQL Server. This data model view is not given to us in the question. Also, the query has no join or where clause so we get nonsensical results (every author's name with every city/state we have & vice-versa). Q32. We are asked to insert 001001001 into an INT column. This is a bogus thing to do, but it works anyway. the value 1001001 is inserted (see Q34). Q34. This question is *exactly* the same as Q32, however this time, we are told the answer is "String or binary data would be truncated..." (see Q32). Which is right? Q40. Two of the answers given are 32,734 (this is the "correct" answer), and 32,768. According to SQL Server Books Online, neither is correct. BOL says: "A maximum of 32,767 databases can be created on a server." Q43. Asks a question about the 401K_Amt column of the Benefits table. All answers incorrectly transpose this to read 401K_Amt.Benefits instead of Benefits.401K_Amt. Q44. Maximum number of files used by a single database. I could not find answer anywhere, BOL, etc. Maybe this book is right. Correct answer given is 32,768. One option was 32,767, which, would agree with BOL's max number of DATABASES (Also incorrectly given in this book). What is a file? I hope they mean physical file, as in mydb.mdf. Q49. Each answer has a DDL statement that will not execute because it refers to a column that does not exist: prod_type(prod)



5. This was my first book in the Exam Cram series, and I'm truly stunned over the absolute rubbish this book contains.

   Luckily someone else has reviewed and posted most of the stuff that is highly questionable in this title, so I can soon throw it away and get on with my life...

   It's packed with syntactical errors, wrong answers, typos, ambigous and subjective scenarios that doesn't rely on facts and blatant statements that are just not true...

   'There is no such thing as a unique clustered index'..???

   I almost fell out of my chair reading that explanation in one of the answers...

   The authors also apparently have no knowledge of SQL Server's security model, as they fail to recognize that one of their 'correct' answers regarding the usage of a view, would not work because of a broken ownership chain..

   and on and on and on...

   I can't reccomend this title to *anyone* - it's so bad that if I could I'd be tempted to sue for mental damage...

No comments about Microsoft SQL Server 2005 für Administratoren.

No comments about DVD Tecnologia del Sistema y Circuitos.

No comments about In The Trenches With SQL Server & .NET.

No comments about Microsoft Access 2002 - Iniciacion y Referencia.

5 comments about Using Microsoft SQL Server 7.0 (Using).

1. This book is long on generalities and short on specifics and advanced topics. The most noticeable was the complete lack of information on interfaces with other database types, replication, external views, etc. If you need an introduction to SQL Server 7.0 the book is excellent. As titled, it leaves much to be desired.



2. I totally agree with one of the reviewers. This book covers everything but definitely not a how-to book. Read it if you need to have a snapshot of SQL server 7.0. If you look for a training book (for MCDBA), look elsewhere.



3. "Using SQL Server 7" is a good book for beginners and still very useful when you got more experience. It describes the features clearly and also gives a lot of good examples. It's one of the best book about the SQL Server 7 I've seen.



4. I found this to be a very cursory reference manual. It did not go into the depth and detail that I would have liked. This book is more geared to beginner/intermediate analysis of SQL Server 7.0. There is no help on DTS ( a huge component of 7.0)



5. I found the publishers synopsis, and espcially the book's title to be very misleading! USING SQL Server 7.0 . . . it is not! The authors start out with "This book is written for IT professionals who want to learn how to administer SQL Server 7" in the introduction, and in chapter one they point out it is for those who want to become a SQL Server Database Administrator (DBA). "Using" SQL Server 7.0 implies to me a totally different view point. I was looking for something in an introductry guide for "users", and developers, to compliment my higher-level SQL Server Programming manual. Instead I found it is an introductry DBA manual. Even in itself, this is contradictory, as prospective DBA's require "in-depth" knowledge that this book is lacking.