MCDBA SQL Server 2000 All-in-One Exam Guide (Book/CD Set) - Hardcover

Perkovich, Dave

Hardcover

ISBN 10: 0072131586 ISBN 13: 9780072131581

Publisher: McGraw-Hill Osborne Media, 2001

Synopsis

All-in-One is all you need! This authoritative reference offers complete coverage of all material on the two core MCDBA SQL Server 2000 exams. You'll find exam objectives at the beginning of each chapter, helpful exam tips, end-of-chapter practice questions, and photographs and illustrations. The bonus CD-ROM contains practice tests, hundreds of questions, and LearnKey(tm) video clips. This comprehensive guide will not only help you pass the MCDBA SQL Server 2000 certification exams, but will also serve as an invaluable on-the-job reference.

About this title

From the Back Cover

Now you can prepare for the two required MCDBA exams --Installing, Configuring, and Administering (#70-228) and Designing and Implementing Databases (#70-229) -- using this comprehensive reference. You'll also get an overview of the various editions of SQL Server, including which operating systems each edition supports, as well as full details on some of the advanced features of SQL Server 2000. Learn how to perform both local and remote installations, administer both Windows 2000 Server as well as SQL Server 2000, manage and maintain data, and much more. Each chapter contains detailed exam objectives, practice questions, and test-taking tips from a Microsoft-certified trainer, making this a premier study tool. Filled with practical advice, as well as case studies to help illustrate concepts and techniques you've just read about, this book is highly useful as both an exam preparation guide and an on-the-job resource.

Get complete details on exam topics including how to:

Install, configure, and upgrade to SQL Server 2000 Plan for a SQL Server database implementation Create a user-defined database using both SQL Server Enterprise Manager and Transact-SQL Monitor security functions--set database permissions, manage user accounts and logon information Modify, optimize, and troubleshoot a SQL Server 2000 database Develop the logical data model and physical design of a SQL database

About the Author

Dave Perkovich (Mesa, AZ) is a Microsoft Certified Solution Developer as well as a Microsoft Certified Trainer. His company, Training Associates, has written more than twenty Microsoft "official" courses and books covering topics such as Visual Basic 5 and 6, Office 2000 Administration, and Windows 2000 MCSE certification materials. Dave is also involved in Training Associates online training business. Co-developer of the edCenter online learning system, Dave works closely with other Microsoft training centers to help them enter into the world of online training.

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2001
• ISBN 10: 0072131586
• ISBN 13: 9780072131581
• Binding: Hardcover
• Language: English
• Number of pages: 1200