MCSE : SQL Server 7 Administration: Training Guide : Exam : 70-028 (MCSE [Textbook Binding]

Christoph Wille (Author), Rob Scrimger (Author), Tim Crothers (Author)

Book Description

Series: MCSE Training Guide | Publication Date: June 1999

PLEASE PROVIDE COURSE INFORMATION The SQL Server 7 Administration Exam, Exam 70-028, is one of the most popular electives on the MCSE certification track. Candidates must take two electives, in addition to four core exams to get their MCSE certification. The Training Guide series from New Riders is the best way for students to prepare. Organized around the exam objectives, Training Guides make it easy for you to focus on areas where you need to improve. It also helps you identify what the key topics on the exam will be. This boo k offers concise, clearly delineated coverage of the key concepts necessary to pass the SQL Server 7 Administration exam. An added bonus is the exclusive Top Score test engine and unique software simulator provide you with a testing situation similar to what you will find on the actual exam. Approved by Microsoft as an Official Study Guide.

Editorial Reviews

Amazon.com Review

Microsoft SQL Server 7 has found a place in many organizations. It's tightly integrated with Windows NT and Access and can handle high database transaction volume. To distinguish yourself from other Microsoft Certified Systems Engineers (MCSEs), you'll need to pass the SQL Server 7 Administration test (exam 70-028). SQL Server 7 Administration Training Guide exposes you to the material on the test, provides you with the answers you need, and gives you plenty of practice questions.

This book covers all the topics specified by Microsoft in its published guidelines for the SQL Server test--indeed, Microsoft has even approved the book's contents. The book's material mixes explanatory prose with stepped procedures. In a typical section, it describes the purpose of a particular feature, outlines its operation in a typical scenario, and presents one or more procedures that show exactly how to carry out tasks related to the feature. Where it's appropriate, option tables and conceptual diagrams are included.

Each chapter concludes with a very brief summary, followed by more stepped procedures and some multiple-choice questions like those featured on the exam. Best of all, an annotated answer key follows the questions--readers get an explanation of how the authors arrived at the correct answer, which should help them improve their understanding of the subject. --David Wall

From the Back Cover

Microsoft Certified Systems Engineer (MCSE) certification continues to increase in popularity. Employers often require this certification because it proves applicants have mastered the ability to design, develop, implement, and support solutions with Microsoft products and technologies. Having MCSE credentials increases an administrator's salary potential by thousands of dollars. Candidates are required to pass six exams-four core exams and two elective exams. This curriculum is very rigorous and extremely challenging. The MCSE exams cost $100 each, and it has been rumored that for the Enterprise exam there are 4.3 failures for every one pass. The Training Guide books are designed to offer all the information needed to prepare for the exams. This book offers solid objective-based content, along with sample questions and exercises to allow the reader to learn the information in-depth.

Product Details

• Textbook Binding: 736 pages
• Publisher: New Riders Publishing (June 1999)
• Language: English
• ISBN-10: 0735700036
• ISBN-13: 978-0735700031
• Product Dimensions: 9.4 x 8.2 x 2 inches
• Shipping Weight: 3.8 pounds
• Average Customer Review: 3.6 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #5,334,265 in Books (See Top 100 in Books)

More About the Author

Brad M. McGehee is a MCSE+I, MCSD, and MCT (former) with a Bachelors' degree in Economics and a Masters in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is an accomplished Microsoft SQL Server MVP and DBA with over 16 years' SQL Server experience, over 8 years' training experience, and has been involved in the industry since 1982. A well-respected and trusted name in SQL Server literature, Brad is the author or co-author of more than 14 technical books and over 275 published articles.

Customer Reviews

Most Helpful Customer Reviews

15 of 15 people found the following review helpful:

2.0 out of 5 stars Too much enterprise manager, August 19, 1999

By A Customer

This review is from: MCSE : SQL Server 7 Administration: Training Guide : Exam : 70-028 (MCSE (Textbook Binding)

If you want to learn how to do things with Enterprise Manager it's great. However is has severe shortcomings on replication and full text search. Most of the info you need to pass their sample tests and exams require other documentation. The best book for that is Books Online or MS SQL Training Kit.

8 of 8 people found the following review helpful:

3.0 out of 5 stars A bit simplistic in places..., May 31, 2000

By 

"sherrian" - See all my reviews

This review is from: MCSE : SQL Server 7 Administration: Training Guide : Exam : 70-028 (MCSE (Textbook Binding)

As previous reviewers noted, this book concentrates on the Enterprise Manager interface. Some of the instructions are *very* detailed, right down to the "Click OK" level, which makes me worry; nobody who has any business administering a database server should need to be told "Click Next to proceed with the Wizard."

This kind of detail wouldn't be so bad, except that other, more useful information, is left out. There's very little attention given to T-SQL, even when using a simple T-SQL statement is much more efficient than working through the Enterprise Manager GUI.

And there's an assumption that you're familiar with previous versions of SQL Server (especially 6.5) and with basic database concepts.

There are a few too many assumptions for the rank novice, and a bit too much emphasis on the GUI for seasoned pros. However, it's set up in about the same format as the exam, and the questions are worthwhile.

When I studied for the exam, I found this book useful as *one* aspect of my study strategy -- but, like other reviewers, I can't imagine passing the exam with this book alone.

6 of 6 people found the following review helpful:

4.0 out of 5 stars good for starter, no for exam, February 24, 2000

By 

Raymond Lee (Hong Kong) - See all my reviews

This review is from: MCSE : SQL Server 7 Administration: Training Guide : Exam : 70-028 (MCSE (Textbook Binding)

This is a good book for people never touch SQL server before. This book will provide you a good lads. However, this book will not make you pass the exam 70-028. This book give you only 60% of necessary information. It didn't teach you T-SQL. Need extra material.