{"product_id":"9780735623774","title":"MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Database Administrator Core Requirements","description":"\u003cp\u003eEXAM PREP GUIDES\u003cbr\u003eAce your preparation for the skills measured by three core MCITP exams—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 practice exercises. \u003c\/p\u003e\u003cp\u003ePRACTICE TESTS\u003cbr\u003eAssess 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.\u003c\/p\u003e\u003cp\u003eMaximize your exam performance with preparation for:\u003c\/p\u003e\u003cp\u003eEXAM 70-431\u003cbr\u003eMicrosoft SQL Server 2005—Implementation and Maintenance\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eInstall and configure SQL Server\u003c\/li\u003e\n\u003cli\u003eSet up tables, indexes, columns, and constraints\u003c\/li\u003e\n\u003cli\u003eUse Transact-SQL to implement functions, stored procedures, and triggers \u003c\/li\u003e\n\u003cli\u003eWork with relational and XML data\u003c\/li\u003e\n\u003cli\u003eMonitor, troubleshoot, and tune queries\u003c\/li\u003e\n\u003cli\u003eMaintain database availability with log shipping, mirroring, and replication \u003c\/li\u003e\n\u003cli\u003ePrepare a backup strategy and restore a database\u003c\/li\u003e\n\u003cbr\u003e\n\u003c\/ul\u003e\u003cp\u003eEXAM 70-443\u003cbr\u003eDesigning a Database Server Infrastructure Using Microsoft SQL Server 2005\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eInstall, consolidate, and configure multiple database instances\u003c\/li\u003e\n\u003cli\u003eDesign tables, file groups, and indexes for a physical database\u003c\/li\u003e\n\u003cli\u003eDevelop and implement security policies at the server, database, and object levels \u003c\/li\u003e\n\u003cli\u003eDesign, implement, and configure clustering, log shipping, mirroring, and replication\u003c\/li\u003e\n\u003cli\u003eDevelop plans for data archiving, backups, and disaster recovery\u003c\/li\u003e\n\u003cbr\u003e\n\u003c\/ul\u003e\u003cp\u003eEXAM 70-444\u003cbr\u003eOptimizing and Maintaining a Database Administration Solution Using Microsoft SQL Server 2005\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eMonitor and troubleshoot queries, databases, and servers\u003c\/li\u003e\n\u003cli\u003eManage security strategies and perform audits\u003c\/li\u003e\n\u003cli\u003eHelp defend against attacks, worms, and viruses\u003c\/li\u003e\n\u003cli\u003eDetect and resolve data conflicts\u003c\/li\u003e\n\u003cli\u003eDiagnose faults and recover from database failures and disasters\u003c\/li\u003e\n\u003cli\u003eOptimize availability with failover clustering, mirroring, log shipping, and replication\u003c\/li\u003e\n\u003cli\u003eCustomize maintenance and automate routine tasks\u003c\/li\u003e\n\u003cli\u003eBuild, debug, and deploy SQL Server Integration Services packages\u003c\/li\u003e\n\u003cbr\u003e\n\u003c\/ul\u003e\u003cp\u003eYour all-in-one kit includes:\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eOfficial self-paced study guides for the three required exams.\u003c\/li\u003e\n\u003cli\u003ePractice tests with multiple, customizable testing options and a learning plan based on your results.\u003c\/li\u003e\n\u003cli\u003e1200+ practice and review questions.\u003c\/li\u003e\n\u003cli\u003eCase scenarios, best practices, and practice exercises.\u003c\/li\u003e\n\u003cli\u003e15% exam discount from Microsoft; good for three exams. (Limited time offer). Voucher inside.\u003c\/li\u003e\n\u003cli\u003e180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.\u003c\/li\u003e\n\u003cli\u003eFully searchable eBooks for all three guides.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"Microsoft Press","offers":[{"title":"Default Title","offer_id":47018306011376,"sku":"9780735623774","price":139.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9780735623774_p0.jpg?v=1763793571","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9780735623774","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}