Ramping Up On SQL

If you're new to SQL Server 7.0, this guide will take you through the product in preparation for the exam. Just add hands-on.

The series from which MCSE SQL Server 7 Administration Training Guide derives provides detailed exam preparation information for the MCSE core and elective exams. Included with the book is a CD containing a TopScore test simulation software suite that provides self-testing tools and simulations. It's aimed primarily at providing information needed to pass the exam. The SQL Server 7.0 Administration test (70-028) is a difficult and long exam and includes some complex scenario questions that require not only knowledge of SQL, but also of Windows NT and network issues. The stated goal is to cover the exam matrix well enough to pass the test.

MCSE SQL Server 7 Administration has Microsoft's blessing as an approved study guide for the exam. The exam topics are covered thoroughly. The only area with weak coverage is replication (which gets just 29 pages). You'll come across the whole gamut of question types, including scenario, multiple-selection, and single-selection. The book is actually structured around the exam matrix. A convenient foldout section at the start of the volume maps all of the exam objectives to the various part of the book.

Those new to SQL Server will find this structure conducive to ramping up on the product and preparing for the exam. Each chapter corresponds to one of the exam areas (such as configuring and managing security) and begins with a list of objectives directly from the matrix. Next, the material is covered in a gradual method with basic concepts presented first and then expanded. The chapters include review breaks and "step-by-step" exercises to help reinforce the concepts. At the conclusion of each section, the authors provide a case study along with hands-on "apply-your-knowledge" exercises and review questions.

The big bonus is the CD, which provides an electronic version of the book, as well as four different types of computer-aided self-testing methods, including flashcards, study cards, a practice exam, and a powerful simulator. These simulations are challenging as well as amazingly realistic and accurate. Although the SQL 7.0 Admin exam doesn't currently include simulation questions, I heartily recommend them. They help verify mastery of the knowledge needed to pass the exam. The traditional-type questions are also good. My only gripe is that the Adobe Acrobat-formatted electronic book is protected against printing. It would be useful to be able to print particular sections to read on the road instead of lugging the entire book.

If you have extensive experience and knowledge of SQL Server, you may find this book rudimentary and too detailed. In addition, you'll stumble across some over-simplifications and incorrect generalizations. For example, the planning chapter indicates RAID 5 should never be used for write-intensive databases because of the performance penalty. However this is an over-simplification; using RAID 5 for data files with RAID 1 for the transaction log is a generally accepted approach, even for OLTP environments.

Overall, MCSE SQL Server 7 Administration should be helpful for those preparing for the exam, especially if you're new to SQL Server. In spite of minor criticisms, I wouldn't hesitate to recommend this for both training and exam preparation. Using this book along with gaining practical experience and delving into SQL Server 7 Books Online should be adequate preparation for the 70-028 exam.

The simulations are so real in this SQL training guide, they may fool you into thinking you're in the real thing!

About the Author

Robert Leithiser, MCDBA, MCSD, MCSE+I, MCT, OCP DBA is a database consultant/technical trainer currently residing in Montgomery, Alabama. In his spare time, he takes his family on outings to Barnes and Nobles to read books.

Featured

  • Microsoft Releases Windows 10 Version 1909

    Microsoft on Tuesday announced the release of Windows 10 version 1909, a new operating system product that's also known as the "Windows 10 November 2019 Update."

  • November Microsoft Security Bundle Addresses 75 Vulnerabilities

    Of that number, 13 vulnerabilities are rated "Critical" to patch, while 62 vulnerabilities are deemed "Important."

  • The Future of Office 365 Pricing

    With a raft of new Office 365 features in the pipeline, Microsoft also seems ready to change the way it bills its subscribers. Will it replicate Azure's pay-per-use model, or will it look like something else entirely?

  • Microsoft Offers 1 Year of Free Windows 7 Extended Security Updates to E5 Licensees

    Microsoft is offering one year of free support under its Extended Security Updates program to Windows 7 users if their organizations have E5 licensing.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.