Microsoft SQL Server 2012 Administration: Real World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)
- 14h 42m
- Tom Carpenter
- Sybex
- 2013
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
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 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.
In this Book
-
Introduction
-
Understanding SQL Server's Role
-
Installing SQL Server 2012
-
Working with the Administration Tools
-
SQL Server Command-Line Administration
-
Querying SQL Server
-
Database Concepts and Terminology
-
ERD and Capacity Planning
-
Normalization and other Design Issues
-
Creating SQL Server Databases
-
Creating Tables
-
Indexes and Views
-
Triggers and Stored Procedures
-
Implementing Advanced Features
-
Creating Jobs, Operators, and Alerts
-
Performance Monitoring and Tuning
-
Policy-Based Management
-
Backup and Restoration
-
Security Threats and Principles
-
Authentication and Encryption
-
Security Best Practices
-
AlwaysOn and High Availability
-
SQL Server Failover Clustering
-
Database Mirroring and Snapshots
-
Implementing Replication
-
Data Warehousing
-
SQL Server Integration Services
-
Data Quality Solutions
