MCTS Self-Paced Training Kit (Exam 70-431): Microsoft SQL Server 2005 Implementation and Maintenance (Pro-Certification)
by Solid Quality Learning
from Microsoft Press
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 wanted mostincluding 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, and more.
MCITP Self-Paced Training Kit (Exams 70-431, 70-443, 70-444): Microsoft SQL Server 2005 Database Administrator Core Requirements (Pro Certification)
from Microsoft Press
Get in-depth training and practice with the skills measured by the core exams for Microsoft Certified IT Professional: Database Administrator certificationall in one box! Covering Exams 70-431, 70-443, and 70-444, these three training kits include exam prep and practice tests to help you maximize your performance. You get official Microsoft study guides, plus practice tests on CD to help you assess your skills. They come packed with the tools and features that exam candidates want mostincluding in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and customizable testing options. They also provide real-world case scenarios and practice exercises for skills and expertise you can apply to the job.
MCTS Self-Paced Training Kit (Exam 70-445): Microsoft SQL Server 2005
by Erik Veerman
from Microsoft Press
This 2-in-1 training kit delivers in-depth preparation plus practice for 70-445, an exam for the MCTS: SQL Server 2005 Business Intelligence certification. Ace exam prepand build real-world job skillswith lessons, labs, practice tests, and more. Work at your own pace through the lessons and lab exercises.
MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
by Dejan Sarka
from Microsoft Press
This 2-in-1 training kit delivers in-depth preparation plus practice for 70-441, an exam for the MCITP: Database Developer certification. Ace your exam prepand build real-world job skillswith lessons, case scenarios, practice tests, and more.
MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits)
by Sara Morgan
from Microsoft Press
This 2-in-1 training kit includes the official Microsoft study guide, plus practice tests on CD to help you assess your skills. It also delivers in-depth preparation, plus practice for 70-442, an exam for the MCITP Database Developer certification. Ace your exam prepand build real-world job skillswith lessons, labs, practice tests, and more. Then assess yourself using 200+ practice questions on the CD, featuring multiple, customizable testing options designed to meet your specific needs. You also get an evaluation version of Microsoft SQL Server 2005 software and an exam discount vouchermaking this kit an exceptional value and a great career investment.
MCITP SQL Server 2005 Database Administration All-in-One Exam Guide (Exams 70-431, 70-443, & 70-444) (All-in-One)
by Darril Gibson
from McGraw-Hill Osborne Media
All-in-One is All You Need
Get complete coverage of all three Microsoft Certified IT Professional database administration exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.
Get full details on all exam topics including how to:
- Install and configure SQL Server 2005
- Use Transact-SQL
- Manage server infrastructure design
- Optimize databases
- Secure databases and servers
- Ensure high availability
- Implement backup and recovery strategies
- Maximize the built-in administration tools
- Use Business Intelligence tools, including SSIS and SSRS
- Manage concurrency
The CD-ROM features:
- Six full practice exams--two for each exam: 70-431, 70-443, and 70-444
- Scripts from the step-by-step exercises in the book
- Video training clips from the author
- Complete electronic book
MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) (All-in-One)
by Darril Gibson
from McGraw-Hill Osborne Media
All-in-One is All You Need
Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.
Get full details on all exam topics including how to:
- Install and configure SQL Server 2005
- Manage database design
- Use Transact-SQL and XML
- Work with functions, triggers, and CLR integration
- Optimize, monitor, and secure databases
- Create stored procedures
- Handle disaster recovery
- Work with Service Broker, Web Services, and MARS
- Use SQL Server Reporting Services and Notification Services
- Manage locks, deadlocks, and cursors
- Transfer data using Replication and SQL Server Integration Services
The CD-ROM features:
- Six full practice exams-two for each exam: 70-431, 70-441, & 70-442
- Scripts from the step-by-step exercises in the book
- Video training clips from the author
- Complete electronic book
MCTS SQL Server 2005 Implementation & Maintenance Study Guide (Exam 70-431)
by Tom Carpenter
from McGraw-Hill Osborne Media
The Best Fully Integrated Study System Available
With hundreds of practice questions and hands-on exercises, MCTS SQL Server 2005 Implementation & Maintenance Study Guide covers what you need to know--and shows you how to prepare--for this challenging exam.
- 100% complete coverage of all official objectives for Exam 70-431
- Exam Readiness Checklist at the front of the book--you're ready for the exam when all objectives on the list are checked off
- Inside the Exam sections in every chapter highlight key exam topics covered
- Simulated exam questions match the format, tone, topics, and difficulty of the real exam
Covers all the exam topics, including:
Installing and Configuring SQL Server 2005 * Creating Databases and Database Objects * SQL Server Security * Creating Views, Partitions, and Linked Servers * Transact-SQL Programming * Working with Constraints, Triggers, and Stored Procedures * Backup and Restore of SQL Server with SQL Agent Jobs * Data Redundancy and Availability * Using the Service Broker * XML Data Support * SQL Server Performance Monitoring and Tuning * Troubleshooting Server and Database Errors
CD-ROM includes:
- Complete MasterExam practice testing engine, featuring: One full practice exam; Detailed answers with explanations; Score Report performance assessment tool
- Video training clips from the author
- Electronic book for studying on the go
With free online registration:
- One-hour LearnKey video training session
- Bonus downloadable MasterExam practice test
MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 Database Design and Implementation, Exam 70-229, Second Edition (Pro-Certification)
by Microsoft Corporation
from Microsoft Press
PRESS SQL SRV 2000 DB DES IMP 70229 2ED
MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server(TM) 2000 System Administration, Exam 70-228, Second Edition (Pro-Certification)
by Microsoft Corporation
from Microsoft Press
Learn how to install, configure, and administer SQL Server 2000--as you prepare for MCP Exam 70-228, a core requirement for MCDBA certification and an elective for the MCSE and MCSA tracks.
+++
