Book description
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.
Note: The ebook version does not provide access to the companion files.
Table of contents
- Cover
- Contents
- Title
- Copyright
- Dedication
- Acknowledgments
- About the Author
- Table of Exercises
- Introduction
- Part I: Introducing SQL Server 2012
- Part II: Designing Database Solutions
- Part III: Implementing Database Solutions
- Part IV: Administering and Maintaining SQL Server 2012
- Part V: SQL Server Security
- Part VI: Implementing High Availability and Data Distribution
- Part VII: Implementing Business Intelligence and Reporting
- Appendices
Product information
- Title: Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)
- Author(s):
- Release date: June 2013
- Publisher(s): Sybex
- ISBN: 9781118487167
You might also like
book
SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond
The ideal on-the-job reference guide for SQL Server 2008 database administrators If you manage and administer …
video
MCSA Querying Microsoft SQL Server 2012 (Exam 70-461): Required Knowledge for SQL Server 2012 and 2014
Lesson Files: http://www.informit.com/content/images/9780789753984/downloads/Code_70-461.zip More than 12 hours of video instruction on Querying Microsoft SQL Server 2012 …
book
Training Kit Exam 70-462: Administering Microsoft® SQL Sever® 2012 Databases
EXAM PREP GUIDE Ace your preparation for the skills measured by Exam 70-462—and on the job—with …
video
Microsoft SQL Server 2012 Certification - Exam 70-461
In this Microsoft SQL Server 70-461 Exam training course, expert author Mark Long teaches you everything …