MCSE Database Design on SQL Server 7 Exam Cram (Exam: 70-029) [Paperback]

Jeffrey R. Garbus (Author), David Pascuzzi (Author), David Pacuzzi (Author), Alvin Chang (Author)

Book Description

Series: Exam Cram (Coriolis Books) | Publication Date: July 5, 1999

Covers how to implement, administer, and troubleshoot information systems that incorporate Microsoft SQL Server 7.0. The book goes beyond simple knowledge of SQL Server 7 to include SQL Server 7 concepts and procedures as tested on the exam. Analyzes SQL Server 7's configuration, optimization, and troubleshooting decisions and solutions.

Editorial Reviews

About the Author

Jeff Garbus (Tampa, FL) has been in consulting for twelve years, training for seven, and in thedatabase business for sixteen. He is well known, having spoken at user conferences and having written numerous articles and books.

David Pacuzzi (Denver, CO) has specialized in design, development and tuning of SQL Server applications for ten years. He has served as project lead, technical lead, data modeler, and production DBA.

Product Details

• Paperback: 350 pages
• Publisher: Coriolis Group Books (July 5, 1999)
• Language: English
• ISBN-10: 1576102289
• ISBN-13: 978-1576102282
• Product Dimensions: 8.9 x 6 x 1.2 inches
• Shipping Weight: 1.6 pounds (View shipping rates and policies)
• Average Customer Review: 3.0 out of 5 stars  See all reviews (20 customer reviews)
• Amazon Best Sellers Rank: #4,691,380 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

12 of 12 people found the following review helpful:

3.0 out of 5 stars Rather a disappointment for Exam Cram, January 2, 2000

By 

D. Young (Tokyo, Japan) - See all my reviews
(REAL NAME)   

This review is from: MCSE Database Design on SQL Server 7 Exam Cram (Exam: 70-029) (Paperback)

I've purchased the Exam Cram for Java 2 and loved it. However, this one is rather a disappointment, as the book failed to cover some of the detailed questions on the exam and hands-on practice on database design. The exam itself is extremely difficult (took me 3 tries, each failing by a margin of 1 or 2 questions). There are some questions asking you how to identify a flawed database design w/ scripts, E-R diagrams, listing you 7+ choices of requirements. One wrong, all wrong. Consult the BOL, but be aware that even the BOL does not have all of the answers. To pass, you need 1)experience with RDBMS, including familiarity w/ T-SQL syntax to create and design DB objects 2)the braindumps - be sure to check the answers with the BOL 3)consult the SQL Server web site and download the whitepapers, particularly on Performance Tuning and Storage 4)lots of patience and dilligence. Best of luck to all of you.

10 of 10 people found the following review helpful:

4.0 out of 5 stars Right directions, February 1, 2000

By 

Anatoly Korzun "a_k" - See all my reviews

Amazon Verified Purchase

This review is from: MCSE Database Design on SQL Server 7 Exam Cram (Exam: 70-029) (Paperback)

Today I passed the exam and this book was my main instrument during preparation.

The book gives right directions and touches all the topics that you may encounter on exam. No unnecessary topics, and no topics missed. It is of a comparatively moderate volume and allows to focus on exam preparation.

Of course, nothing is ideal in this world, this book isn't too. Not everything is covered with a depth necessary for exam. Sample test in the book is noticeably easier than a real exam. I also noticed some minor errors.

BTW, it was my 8th MS exam (previous were 4 MCSE core exams, TCP/IP, IIS 4, Proxy 2) and I found it the most difficult. Before reading this book, I had read Special Edition Using SQL 7 (QUE) and played with MS SQL 7 for a couple of months (but I had an experience with other DBMS).

SUMMARY: I recommend this book for the exam preparation but I don't recommend to rely on it as the only source of information, use at least SQL Books Online as a supplement, and of course play with SQL Server, trying and checking all unclear moments on a test database.

7 of 7 people found the following review helpful:

4.0 out of 5 stars An excellent choice for a second book., November 29, 1999

By 

Dr. Robert C.A. Goff, MCSD, MCSE, MCDBA "Coun... (Blacksburg, VA USA) - See all my reviews

This review is from: MCSE Database Design on SQL Server 7 Exam Cram (Exam: 70-029) (Paperback)

First, I read the New Riders book, then read the Exam Cram to fill in the (many) holes. I sailed through the [3-hour!] test with flying colors. Since I have found numerous typos in each of the 9 MCSD books that I've read (from New Riders, Syngress, and ExamCram), I can rate this one among the better edited of the lot. Since this series is not intended to be your sole resource, you should be able to spot the occasional errors with little difficulty. I guess the deadlines on these exam books preclude all but the most cursory proof-reading.