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

Desai, Anil

Hardcover

ISBN 10: 0072126949 ISBN 13: 9780072126945

Publisher: Osborne/McGraw-Hill, 2001

Synopsis

An integrated study system based on proven instructional methodology, this book includes special pedagogical elements such as step-by-step exercises, exam watch and on-the-job notes, and quick reference scenario and solution tables. More than 250 practice exam questions that match the actual exam questions in content and feel, while all answer options, correct and incorrect, receive detailed explanations as to why the answer is or is not the correct one. A self-test section includes knowledge- and scenario-based questions that match the actual exam questions. The CD-ROM features instructional graphical animations with audio explanations and an eBook, the electronic version of the study guide.

About this title

About the Author

Anil Desai (Austin, TX), 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 (Sarasota, FL), MCSE, MCDBA, is a database consultant who specializes in e-commerce and SQL Server.

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

Edition details

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