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

Overview

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

Read More