Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228: Microsoft(r) SQL Server(tm) 2000 System Administration, Exam 70-228, Second Edition
 
 
Share your own customer images
Search inside this book

MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228: Microsoft(r) SQL Server(tm) 2000 System Administration, Exam 70-228, Second Edition [Hardcover]

Microsoft Corporation (Author)
3.2 out of 5 stars  See all reviews (13 customer reviews)

Available from these sellers.


Formats

 Amazon Price New from Used from
Hardcover --   -- --

Product Details

Product Description

Book Description

Learn how to install, configure, and troubleshoot SQL Server 2000—and prepare for the Microsoft Certified Professional (MCP) exam—with this official Microsoft study guide. Work at your own pace through the lessons and hands-on exercises. And use the special exam-prep section and testing tool to measure what you know and where to focus your studies—before taking the actual exam. As you build real-world database administration expertise, you’re also preparing for MCP Exam 70-228—a core exam on the MCDBA track and an elective on the MCSA and MCSE tracks.

Build the skills to:

  • Install or upgrade to SQL Server 2000
  • Configure database options—capacity, connectivity, and performance
  • Automate data transfer and manipulation with Data Transformation Services (DTS) packages
  • Use SQL Server replication services
  • Manage security features—authentication, logins, permissions, and alerts
  • Monitor and fine-tune system performance with tools such as SQL Server Agent, SQL Profiler, and the Windows® System Monitor
  • Perform backups and restorations

Ready for the exam? Take practice tests on the CD.

Your kit includes:

  • Comprehensive self-paced study guide that maps to MCP exam goals and objectives
  • NEW—Test-readiness tool that generates timed, 50-question practice exams with automated scoring
  • NEW—More than 200 pages of exam prep and objective-by-objective review
  • Learn-by-doing exercises for skills you can apply to the job
  • 120-day evaluation version of SQL Server 2000 Enterprise Edition
  • Fully searchable eBook?plus sample databases and technical white papers—on CD

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

From the Publisher

Provides self-paced, from-the-source information and practice with the skills measured by MCP Exam 70-228—an elective on the Windows 2000 MCSE track, and a core exam for MCDBA certification --This text refers to an out of print or unavailable edition of this title.
See all Product Description
Inside This Book (Learn More)
First Sentence
SQL Server 2000 is a family of products designed to meet the data storage requirements of large data processing systems and commercial Web sites, as well as meet the ease-of-use requirements of individuals and small businesses. Read the first page
Explore More
Concordance
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
Your tags: Add your first tag
 
See most popular tags
 

Customer Reviews

13 Reviews
5 star:
 (4)
4 star:
 (3)
3 star:
 (1)
2 star:
 (2)
1 star:
 (3)
 
 
 
 
 
Average Customer Review
3.2 out of 5 stars (13 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most helpful customer reviews

6 of 6 people found the following review helpful
5.0 out of 5 stars If you want to pass the exam or just learn SQL 2000 Server.., Sep 28 2003
By A Customer
This review is from: MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228: Microsoft(r) SQL Server(tm) 2000 System Administration, Exam 70-228, Second Edition (Hardcover)
I have several year of experience with SQL 7.0 and was looking for the resource to tell me the distinct difference between 7.0 and 2000. The book reads well and has plenty of hands on step-by-step labs (if needed). Really the book is two books in one. The second part of the book is preparation for the exam with scenario-based questions. Additionally, the book comes with the usual 120 day Evaluation Edition of SQL 2000 server. Plus a second CD with supplemental course material, electronic version of the book (part 1), scripts for the lab, a test engine ("Electronic Assessment"), ect.

I used the book as the primary source for studying for the 70-228 exam (passed the first time)along with BOL for fine points mentioned in each chapter. I found reading the book forward and then backward increased overall coverage due to interrelationships between chapters (don't worry the book reads fast). Even if you have no experience with SQL server, I think the book will do the trick.

If you have no experience with relational databases, I would suggest picking up a source on database design.

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


2.0 out of 5 stars Incomplete book for the 70-228 exam, Nov 28 2003
This review is from: MCSE Training Kit (Exam 70-228): Microsoft SQL Server 2000 System Administration (Hardcover)
I started studying for the exam with these book and I noticed that this book has poor information for the following areas:

Clustering
DTS packages
Stored procedures, triggers, views.

I recommend to look for the 70-229 training book to complement to this one and study the books online.

This book contains useful information for the following areas:

Installation
Upgrades
Replications

Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


4.0 out of 5 stars Great buy!, Dec 27 2002
This review is from: MCSE Training Kit (Exam 70-228): Microsoft SQL Server 2000 System Administration (Hardcover)
Though I have not yet taken any exam (aiming for mcdba), I find this book really good. I am one of those who wants to learn a bit a theory as well, not just the practical parts. And I find this book to cover all of my expetations... A little minus for the boring chapters about upgrading Sql-s 6.5 and 7.0 though:), I hope that when I get to the age when I am supposed to find me a work (and hopefully something that has with sql-s to do) that they have done the upgrading before I arrive:D
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
Want to see more reviews on this item?
› Go to Amazon.com to see all 27 reviews  3.2 out of 5 stars 
 
 		 Most recent customer reviews











Only search this product's reviews


Listmania!

Create a Listmania! list

Look for similar items by category

Look for similar items by subject























i.e., each book must be in subject 1 AND subject 2 AND ...

Feedback

Would you like to update product info or give feedback on images?