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
"synopsis" may belong to another edition of this title.
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.
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 this title" may belong to another edition of this title.