did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780764504808

MCSE SQL Server 2000 Administration For Dummies

by ;
  • ISBN13:

    9780764504808

  • ISBN10:

    0764504800

  • Edition: CD
  • Format: Paperback
  • Copyright: 2001-04-29
  • Publisher: For Dummies
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $34.99

Summary

MCSE SQL Serve 2000 Administration For Dummies brings you concise coverage of the Microsoft exam objectives. This book is a valuable resource for experienced users who are seeking a quick review of the exam material. And, for the less-experienced user, this book will provide accessible information as well as extensive self-assessment and practice question opportunities in both written and electronic format. The real-world experience of the authors enables them to present information that underlies the key concepts and ideas of the exam objectives. You can rely on this friendly ...For Dummies guide to prepare you for the SQL Server 2000 Administration exam (70-228). Covers: Exam 070-228

Author Biography

Rozanne Whalen and Dan Whalen, both MCSE, MCDBA, and MCT, teach MCSE and MCDBA exam-preparation courses. Rozanne also writes instructor training manuals and is the editor of the Inside Microsoft Windows 2000 journal.

Table of Contents

Introduction 1(6)
Part I: Getting Started 7(24)
The Microsoft SQL Server 2000 System Administration Exam
9(8)
Exam Prep Roadmap: A SQL Server 2000 Primer
17(14)
Part II: Installing and Configuring SQL Server 2000 31(80)
Planning to Implement SQL Server 2000
33(20)
Installing SQL Server 2000
53(16)
Upgrading to SQL Server 2000
69(12)
Troubleshooting Installation Problems
81(12)
Configuring SQL Server to Send E-Mail
93(18)
Part III: Creating SQL Server Databases 111(82)
Designing Databases
113(16)
Creating Databases
129(20)
Managing Databases
149(22)
Creating and Managing Database Objects
171(22)
Part IV: Managing, Monitoring, and Troubleshooting Databases 193(112)
Managing and Optimizing Database Performance
195(28)
Optimizing Data Storage
223(12)
Backing Up Databases
235(26)
Restoring Databases
261(20)
Using Database Monitoring and Troubleshooting Tools
281(24)
Part V: Transferring Data 305(68)
Integrating SQL Server with Internet Information Services
307(10)
Importing and Exporting Data
317(24)
Installing, Configuring, and Troubleshooting Replication
341(32)
Part VI: Securing SQL Server 373(48)
Configuring Login Security
375(14)
Implementing Permissions
389(20)
Auditing SQL Server
409(12)
Part VII: Managing, Monitoring, and Troubleshooting SQL Server 2000 421(44)
Automating Administrative Tasks and Alerts
423(20)
Optimizing Hardware Resources
443(10)
Monitoring and Troubleshooting SQL Server
453(12)
Part VIII: The Part of Tens 465(10)
Ten Terrific Exam Day Tips
467(4)
Ten MCSE Certification Resources
471(4)
Part IX: Appendix 475(8)
Appendix: About the CD
477(6)
Index 483(18)
Hungry Minds, Inc. End-User License Agreement 501(2)
Installation Instructions 503

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program