Microsoft SQL Server 7.0 System Administration Online Training Kit (It-Online Training Kit) [Paperback]

Microsoft Corporation (Author)

Book Description

Publication Date: August 1, 1999 | Series: It-Online Training Kit

System administrators learn how to install, configure, and support SQL Server 7.0 in enterprise networks using this official Online Training Kit. This fully interactive, next-generation learning system packs a full, multiple-session instructor-led training course onto a single CD-ROM! Readers work at their own pace through the modular courseware to gain practical experience with critical SQL Server 7.0 administration tasks and to prepare for MCP Exam 70-028, a core credit for the Microsoft Certified Database Administrator certification. Kit includes a copy of the SQL Server 7.0 System Administration Readiness Review -- a Microsoft Certified Professional exam readiness assessment book and CD.

Editorial Reviews

Amazon.com Review

Microsoft SQL Server 7.0 System Administration Online Training Kit is a great resource to use in preparing for the Administering Microsoft SQL Server 7 exam (70-028) as you work toward a Microsoft Certified Professional (MCP) certification. Because it's primarily a CD-ROM presentation, this product is particularly great for candidates who want to study while traveling, commuting, or in any situation that doesn't lend itself to carrying a big book.

The CD-ROM doesn't put much stock in multimedia gewgaws, employing instead a logical structure that helps you identify and correct deficiencies in your SQL Server knowledge. For each section of the presentation--"Creating a Database" is one example--there's a brief introduction to the topic and an assessment quiz. Based on your performance on the pre-test, the software highlights specific modules you should focus on (say, "Using Transact-SQL to Create a Database" or "Setting Database Options"). The training modules themselves are concise, relying on static conceptual drawings to help drive facts home.

Because you log in to the software, you can keep track of your progress over time. One small beef: in some situations, you have to mouse-click the Forward button after each page of the presentation. Other segments allow you to hit Enter or the space bar instead. This inconsistency could easily be fixed. Though the training CD-ROM itself doesn't include a full exam simulation, the CD-ROM that's bound with MCSE Readiness Review: Administering Microsoft SQL Server 7.0 (also included in this package) has a test simulator on it. --David Wall

Topics covered: The material that appears on the Administering Microsoft SQL Server 7 exam (70-028), including planning, installation, security, backups and restores, monitoring, and troubleshooting.

Product Details

• Paperback: 450 pages
• Publisher: Microsoft Press (August 1, 1999)
• Language: English
• ISBN-10: 0735606781
• ISBN-13: 978-0735606784
• Product Dimensions: 9.3 x 7.6 x 2.2 inches
• Shipping Weight: 2.3 pounds
• Average Customer Review: 4.4 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #4,839,057 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

42 of 45 people found the following review helpful:

5.0 out of 5 stars By far the best MS Press training to date., October 12, 1999

By A Customer

This review is from: Microsoft SQL Server 7.0 System Administration Online Training Kit (It-Online Training Kit) (Paperback)

I COULD STAY AWAKE!

As a MCT I appriciate good training and in a nut shell this is it! It uses a very good training engine that has built-in presentations.

All sections are easy to follow and very well thought out. They all have a presentaion window, most have a sim(all very good hands on), and have full audio to follow the instruction. When you fininsh a section your quized. Finish(?) you can use the practice test software included!

This training follows the MOC training so close I broke out my trainers book and could follow section by section changing very little!

Best part you can replay where the class you can't! So what's better $179 or $1079???

As a Sr Systems Analyst and current MCP+I,MCSE+I,MCSD,MCT,CNE,VCE,HPSTAR I can tell you this one is well worth the money! I passed this exam after watching this ONE time and taking the included practice tests (yes they too are good). The sims do one thing good, teach you the right way to do things and give hands on without installing this beast on your system.

Just have to wait it out for the Imp and Design Online Training Kit.

Good Luck! One away form MCDBA...

16 of 16 people found the following review helpful:

4.0 out of 5 stars Great for learning SQL Server, but not for passing the exam., May 24, 2000

By 

Cade Bryant (Fort Lauderdale, FL) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Microsoft SQL Server 7.0 System Administration Online Training Kit (It-Online Training Kit) (Paperback)

I found this kit (along with its companion, SQL Server Database Implementation Training Kit) to be great for learning how to use and administer SQL Server. Both kits are very engaging, with graphic illustrations, quizzes, assessments, and simulation exercises, which do a good job of reinforcing the learning material.

If you're simply looking to get trained on SQL Server (or acquire a job as a SQL administrator), then these kits are more than sufficient (The simulations are especially helpful in this regard). Certainly, they helped me obtain my present job as a database analyst. And the price is very reasonable when compared with other software-simulation training kits such as those offered by CBT Systems and NETg (which cost about 4X more than the MS kits, and aren't really much better).

However....if you're looking to pass the MS SQL exams, you will need more. The SQL exams are notoriously hard. The enclosed Readiness Review is somewhat helpful, but the actual questions on the exam are much harder. Read BOL (included with kit), visit cramsession and similar sites, and take a practice test first.

8 of 8 people found the following review helpful:

4.0 out of 5 stars Good training kit but incomplete coverage of material for ad, January 11, 2000

By 

Adrian Tan - See all my reviews

This review is from: Microsoft SQL Server 7.0 System Administration Online Training Kit (It-Online Training Kit) (Paperback)

I guess a review should really be more critic rather than blessing, so that other readers can use the review to decide and judge whether this kit is suitable for them.

3.5 stars on material and 4 stars for online training presentation.

1. There are mistakes in the quiz's questions and answers, such as:- 'All three drives' should be 'All four drives' instead, 'DLL' which should be 'DDL', syntax errors and etc.

2. There is also a session 'Publishing Database Data on the Web' under chapter 'Automating Administrative Tasks' with pre-asseement quiz and final quiz questions which are completely irrelevant to the session material.

3. Not enough administrative coverage. Does not covers:- Metadata, Linked Servers, Remote Servers, Full Text Search and etc.

A good overall training kit for the subject of administering SQL Server 7. However, still, this kit itself should be treated as a real-time lecture only. You will need to use other books (such as 'Inside MS SQL Server 7', 'Books Online') as technical references and allow you to do more research into the corresponding readiness review simulation questions and understand the reasons and theory behind it.