Relational database management systems serve a critical role—allowing organizations to organize, store, and manage large volumes of data. The database administrators who oversee these systems must be well versed in a broad range of topics, including database architecture and design, security, data integrity, performance optimization, backup and recovery, and system monitoring. Skilled database administrators are in high demand across every industry—a trend likely to continue as the volume of data grows. With a sizeable share of the market and tight integration with the Windows family of operating systems, Microsoft SQL Server provides an ideal learning environment and offers a path for the aspiring student to rewarding career opportunities. MCSA Guide to Microsoft SQL Server 2012 (Exam #70-462) is designed to teach the core skills and develop the confidence necessary to become an effective database administrator on Microsoft SQL Server 2012.
The catalyst for embarking on this project was the growing need for a high-quality, academic textbook that covers the core database administration principles and practices for Microsoft SQLServer 2012. While there are a variety of books written about Microsoft SQL Server 2012, the majority are focused either on serving existing practitioners or exclusively on exam certification. This book is written with the objective of providing a thorough introduction to database administration principles and practices necessary to perform Microsoft SQL Server administration in an enterprise environment and prepare for the Microsoft Certified Solutions Associate Exam 70-462.
Brief Table of Contents
chapter 1 Introduction to SQL Server 2012 1
chapter 2 Deploying SQL Server 2012 27
chapter 3 Architecture and Configuration 73
chapter 4 Creating SQL Server 2012 Databases 115
Chapter 5 Transact-SQL Primer 151
chapter 6 SQL Server Security 197
chapter 7 Performance Monitoring and Optimization 237
chapter 8 Backup and Recovery 273
chapter 9 Data Integration 319
chapter 10 Monitoring SQL Server 2012 361