|
$29.00 List price:
Used Hardcover
Ships in 1 to 3 days
 available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
More copies of this ISBNOther titles in the Pro-Certification series:
Mcts Self-paced Training Kit (Exam 70-431): Implementing and Maintaining Microsoft SQL Server - With DVD and CD (06 Edition)by Sql
Synopses & ReviewsPlease note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.
Publisher Comments:Exam Prep Guide Ace your preparation for the skills measured by MCTS Exam 70-431—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what youve learned by applying your knowledge to real-world case scenarios and practices. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to:
Practice Tests Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers?including a customized learning path that describes how and where to focus your studies. Your training kit includes:
A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. Synopsis:Exam Prep Guide Ace your preparation for the skills measured by MCTS Exam 70-431—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practices. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: Install and configure SQL Server Create tables and indexes, define columns, and implement constraints Implement functions, stored procedures, and triggers by using Transact-SQL Work with relational and XML data Monitor, troubleshoot and tune queries Maintain database availability with log shipping, database mirroring, and replication Prepare a backup strategy and restore a database Practice Tests Assess your skills with practice tests on CD. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers?including a customized learning path that describes how and where to focus your studies. Your training kit includes: 15% exam discount from Microsoft. Offer expires 12/31/10. Details inside. Official self-paced study guide. Practice tests with multiple, customizable testing options and a learning plan based on your results. 450 practice and review questions. Case scenarios, practice exercises, and best practices. 180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition. Fully searchable eBook. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. Synopsis:Get in-depth exam preparation for Exam 70-431, the core MCTS exam for the new Microsoft IT Professional certifications--as you build real-world job skills. Includes 300 test questions, reviews, case studies, code samples, an exam discount, and more. Announcing an all-new MCTS Training Kit designed to help maximize your performance on Exam 70-431, a core exam for the new Microsoft IT Professional certifications. This kit packs the tools and features that exam candidates want most--including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Focusing on SQL Server 2005, this official study guide covers topics such as installing and configuring SQL Server, implementing database mirroring, managing database snapshots, working with XML and flat files, managing replication, backing up and restoring a database, monitoring and troubleshooting, and creating and implementing database objects. Ace your exam preparation and ramp up quickly on SQL Server 2005 database administration by working at your own pace through the lessons, hands-on exercises, and practice tests. The flexible, best-of-class test engine on CD features 300 practice questions and pre-assessment and post-assessment capabilities. Choose timed or untimed testing mode, generate random tests, or focus on discrete objectives or chapters, and get detailed explanations for right and wrong answers--including pointers back to the book for further study. You also get a 180-dayevaluation version of SQL Server 2005 Enterprise Edition and a 15 percent exam discount voucher--making this kit an exceptional value and a great career investment. SQL Server 2005 is Microsoft's next-generation data management and analysis solution that delivers enhanced sca Table of ContentsAcknowledgmentsAbout the AuthorsIntroductionChapter 1: Installing SQL Server 2005Chapter 2: Configuring SQL Server 2005Chapter 3: Creating Tables, Constraints, and User-Defined TypesChapter 4: Creating IndexesChapter 5: Working with Transact-SQLChapter 6: Creating PartitionsChapter 7: Implementing ViewsChapter 8: Managing XML DataChapter 9: Creating Functions, Stored Procedures, and TriggersChapter 10: Working with Flat FilesChapter 11: Backing Up, Restoring, and Moving a DatabaseChapter 12: Using Transact-SQL to Manage DatabasesChapter 13: Working with HTTP EndpointsChapter 14: Working with SQL Server Agent JobsChapter 15: Monitoring and Troubleshooting SQL Server PerformanceChapter 16: Managing Database SnapshotsChapter 17: Implementing Database MirroringChapter 18: Implementing Log ShippingChapter 19: Managing ReplicationChapter 20: Working with Service BrokerChapter 21: Creating Full-Text CatalogsAnswersGlossarySystem RequirementsExam 70-431: Microsoft SQL Server 2005—Implementation and MaintenanceAdditional Resources for IT ProfessionalsMicrosoft® SQL Server™ 2005 Training Kits
What Our Readers Are SayingBe the first to add a comment for a chance to win!Product Details
Other books you might like
Related Aisles
|
|||||||||
|
|
||||||||||
|
Follow us on...
|
||||||||||
Don't Miss
