Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463) - Softcover

Carpenter, Tom

Softcover

ISBN 10: 1118487168 ISBN 13: 9781118487167

Publisher: Sybex, 2013

Synopsis

Implement, maintain, and repair SQL Server 2012 databases

As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them.

• Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification
• Explores the skills you'll need on the job as a SQL Server 2012 DBA
• Discusses designing and implementing database solutions
• Walks you through administrating, maintaining, and securing SQL Server 2012
• Addresses implementing high availability and data distribution
• Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBA

Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.

About this title

About the Author

Tom Carpenter, MCSA: SQL Server 2012, is founder and senior consultant for SysEdCo, a training and consulting firm located in central Ohio. He is the author of several books on technical topics including networking infrastructure, database management, and VoIP. Having worked as a systems analyst in a large corporation with more than 20,000 network nodes, Tom brings a wealth of real-world experience to his books and presentations.

From the Back Cover

Take Your Career to the Next Level with This Practical Guide

SQL Server expert Tom Carpenter teaches you skills to help you excel in your job as a SQL Server 2012 database administrator. From designing and implementing database solutions with SQL Server 2012 to querying, repairing data, maintaining high availability, and managing always-on technology, he explores the real-world tasks and scenarios you'll face as a SQL Server database administrator and shows you how to handle them. This book also serves as an ideal resource for those preparing for their MCSA: SQL Server 2012 certification.

• Install and configure SQL Server 2012
• Design, implement, and effectively manage database solutions
• Learn basic and advanced querying techniques
• Understand triggers, stored procedures, and indexing
• Standardize, automate, and update jobs, operators, and alerts
• Monitor and manage a SQL Server cluster and learn mirroring
• Initiate backup and restore, and learn security best practices
• Plan for high availability, data warehousing, and business intelligence
• Discover how to clean data and improve data quality

ACCESS practice exams, electronic flashcards, and author videos of critical tasks at www.sybex.com/go/sqlserver12admin

An ideal supplement to help you prepare for:

Exam 70-461: Querying Microsoft SQL Server 2012

Exam 70-462: Administering a Microsoft SQL Server 2012 Database

Exam 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012

From the Inside Flap

Take Your Career to the Next Level with This Practical Guide

SQL Server expert Tom Carpenter teaches you skills to help you excel in your job as a SQL Server 2012 database administrator. From designing and implementing database solutions with SQL Server 2012 to querying, repairing data, maintaining high availability, and managing always-on technology, he explores the real-world tasks and scenarios you'll face as a SQL Server database administrator and shows you how to handle them. This book also serves as an ideal resource for those preparing for their MCSA: SQL Server 2012 certification.

• Install and configure SQL Server 2012
• Design, implement, and effectively manage database solutions
• Learn basic and advanced querying techniques
• Understand triggers, stored procedures, and indexing
• Standardize, automate, and update jobs, operators, and alerts
• Monitor and manage a SQL Server cluster and learn mirroring
• Initiate backup and restore, and learn security best practices
• Plan for high availability, data warehousing, and business intelligence
• Discover how to clean data and improve data quality

ACCESS practice exams, electronic flashcards, and author videos of critical tasks at www.sybex.com/go/sqlserver12admin

An ideal supplement to help you prepare for:

Exam 70-461: Querying Microsoft SQL Server 2012

Exam 70-462: Administering a Microsoft SQL Server 2012 Database

Exam 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012

Edition details

• Publisher: Sybex
• Publication date: 2013
• Language: English
• ISBN 10: 1118487168
• ISBN 13: 9781118487167
• Binding: Paperback
• Edition number: 1
• Number of pages: 936