MCDBA SQL Server 2000 Database Design Study Guide (Exam 70-229) - Hardcover

Syngress Media Inc; Anil Desai; Jeffery Bane; Craig Robinson

Hardcover

ISBN 10: 0072126949 ISBN 13: 9780072126945

Publisher: McGraw-Hill Osborne Media, 2001

Synopsis

Includes 100% complete coverage of all exam objectives, hundreds of practice questions, and hands-on exercises This exam is required for MCDBA certification and a popular elective for both the MCSE and MCSD certifications Previous edition sold more than XX,XXX copies CD-ROM contains CertTrainer software with interactive tutorials and lab simulations and ExamSim practice exam software

About this title

From the Back Cover

The Only Certification Study System Based on 200,000+ Hours of IT Training Experience

• 100% Complete Coverage--All official test objectives for Exam 70-229 are covered in detail
• Hands-on Exercises--Step-by-step instruction modeled after classroom labs
• Exam Watch--Warnings based on thorough post-exam research identifying the most troublesome exam topics and how to answer them correctly
• Three Types of Practice Questions--Knowledge, scenario, and lab-based questions, all with in-depth answers
• From the Classroom--Discussions of important issues direct from the classrooms of Global Knowledge's award-winning instructors

Full coverage of the topics you need to review, including how to:

• Develop a logical database design
• Design for referential integrity
• Manage entity relationships
• Implement the physical database and ensure data integrity
• Implement advanced database objects and features
• Manipulate data using Transact-SQL
• Tune and optimize database performance
• Monitor database activity with SQL Profiler
• Transfer data between systems
• Design and implement database security

CD-ROM features full CertTrainer CBT software and the new ExamSim test engine--more than 150 questions on CD

CertTrainer

• e-Training--Self-paced review of key SQL Server 2000 topics, including exam tips
• CertCams--Instructional SQL Server 2000 video animations demonstrate key topics
• In-depth Links--Need more explanation? Topically relevant links provide detailed instruction
• Skill Assessment--Test your knowledge with more than 110 challenging practice exam questions
• Score Reports--Indicate subject areas requiring further study

ExamSim

• Complete Practice Exam--A realistic MCDBA exam with questions found only on the CD-ROM
• Review Mode--Analyze what you got wrong and why
• Detailed Answers--Explain why the correct options are right and why the incorrect options are wrong
• Score Report--Provides an overall assessment of your performance

PLUS

• E-book--Electronic, searchable version of the Study Guide

About the Author

Anil Desai, MCSE, MCSD, MCDBA, is Technical Architect at QuickArrow, Inc. He is the author of numerous computer books, among them SQL Server 7 Backup & Recovery; MCSE Windows 2000 Directory Services Administration Exam Guide; and Windows NT Network Management: Reducing Total Cost of Ownership. Jeff Bane, MCSE, MCDBA, is a database consultant who specializes in e-commerce and SQL Server.

Edition details

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2001
• ISBN 10: 0072126949
• ISBN 13: 9780072126945
• Binding: Hardcover
• Language: English
• Number of pages: 608