Not Quite Complete
Missing T-SQL coverage mars an otherwise thorough reference
- By Gerry O'Brien
While preparing to take my SQL 2000 exams, I was looking for an all-in-one
book that would or could help me on this quest. Based on the cover of
the book, I thought I had found what I was looking for. It claimed to
have complete coverage of all material on both exams, 70-228 and 70-229.
First of all, let me say that the book does indeed provide information
on all exam objectives. There is sufficient coverage to give you a good
grounding in SQL Server 2000 Administrative and Design aspects. There
was a contradiction, however, in what the book cover stated and what the
author stated in the book. In order to pass the Designing exam and, indeed,
the Administration exam, you need to be well versed in Transact-SQL, which
is the SQL dialect used by Microsoft's SQL Server products. The author
states that this book does not cover T-SQL in depth and that you will
need to look elsewhere for in-depth SQL knowledge.
I can tell you that I did indeed pass both exams on the first try. This
book was an excellent source of information for the exam, if only because
it compliments the other two required factors for exam success: hands-on
and test practice. With the use of the exam tips, the hands-on exercises,
as well as the help of some practice tests—both in the book and those
you'd have to acquire from third parties—you should be able to pass
the SQL exams. Nothing beats hands on experience with any product to get
a feel for it.
There are areas on the exams that require you to have a firm understanding
of the concepts of the software and its use that no book can give you.
The author, Dave Perkovich, brings his experiences to the book and provides
good tips and pointers throughout the text to relevant topics as they
relate to the exam. The fact that he is an MCSD and MCT I feel has only
helped the book to be more complete as each certification provides its
own advantages to a project such as this.
Writing a book to cover an entire product such as SQL Server 2000, especially
for exam preparation, is no easy task. I have used books from various
publishers and authors as well as books written specifically for Microsoft
Press that are indicated as being Microsoft Approved Study Guides. Some
do not even come close to preparing you for an exam. Somehow they always
leave your short.
There are really only two issues that really stand out for me in this
book that need to be looked at if there is to be a second edition or second
printing. First: Gather some more technical reviewers and proofreaders
to clean up some minors errors in the text. Second: Either add more T-SQL
content or remove the reference that the book contains "complete coverage."
Other than these two points, I'd recommend this book to anyone looking
for an all-in-one study guide for the SQL 2000 exams. Hey, I passed them;
you can too!
About the Author
Gerry O'Brien, MCSE, MCSD, MCDBA, MCT, has been working with computers since the days of the Commodore VIC-20. Over the past five years he's done network administration for The Hardman Group Ltd., a real estate management/development company, and owns Canadian-Based GK ComputerConsulting, which provides hardware and software sales, consulting, and development services to a wide range of clients.