Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

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

Tom Carpenter
1.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £47.50
Kindle Price: £36.10 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £11.40 (24%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £36.10  
Paperback £38.00  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

Implement, maintain, and repair SQL Server 2012databases

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

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

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

Product Description

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 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

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.

Product details

  • Format: Kindle Edition
  • File Size: 63471 KB
  • Print Length: 936 pages
  • Publisher: Sybex; 1 edition (3 Jun. 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 1.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #547,076 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5 star
4 star
3 star
2 star
1.0 out of 5 stars
1.0 out of 5 stars
Most Helpful Customer Reviews
1.0 out of 5 stars waste of money - it doesn't help for the exams 8 July 2014
Format:Paperback|Verified Purchase
waste of money - it doesn't help for the exams.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.9 out of 5 stars  9 reviews
10 of 11 people found the following review helpful
2.0 out of 5 stars Not for Exams 5 Dec. 2013
By HTT - Published on
Format:Kindle Edition|Verified Purchase
I had passed 70-461 and 70-462 when I bought this book because my teacher used this book to teach SQL 2012 at a community college. This book offers very little practice and lot of of mistakes in the exercises. I tried to submit errata on but it doesn't have a feature to view/submit errata like I can do with books at If you already work daily with SQL and want to read more , this is a book for you. If you want to pass exams with this book, I am afraid you will be dissappointed.
5 of 6 people found the following review helpful
2.0 out of 5 stars False advertising 12 Nov. 2013
By Dimitri Shvorob - Published on
Let's be clear: this book will not get you in the zip code of passing any of the three exams needed for the MCSA: SQL Server 2012 certification. If you are considering MCSA, pass without a second thought.

If not ... the title still does not fit, as a book about SQL Server administration should not have this much non-administration-related, occasionally basic, content. What this book is, then, is a SQL Server book with a focus on administrator tasks, plus a helping of SSIS. In my opinion, in this capacity it's actually not bad and could be a decent beginner's choice.

PS. I am an MCSE: BI.
6 of 8 people found the following review helpful
5.0 out of 5 stars Framework for the Cert and great beginner DBA book 19 July 2013
By Amazon Customer - Published on
Format:Kindle Edition|Verified Purchase
First and foremost I was rusty on DBA work and needed something to get me back into the game slowly but surely. Truthfully, I haven't taken the certification tests. At this point it is highly unlikely that I will do that. On the other side this book is GREAT for a beginner DBA. It really starts from Point A and takes you to about Point F. Yes, T-SQL and a whole lot of other elements such as best practices, security, etc,... are lacking. If you have to learn ALL of that then you should be looking at multiple books/sources anyway.

If you have any passion for DBA work and want to be reasonably good at it and be in the right path towards your certification then I highly recommend this book. The fundamentals presented actually apply to other DB's I have and currently use as well (i.e. Oracle, MySQL, etc,.).

I do recommend this to anyone who believes that need to learn from the beginning. If you are already moderately skilled and just want the cert guide then I would consider other options only because this is not a pure certification guide.

I have no regrets. It is exactly as presented. A beginner guide to MS SQL and a mild guide to the certificaiton.
2 of 3 people found the following review helpful
5.0 out of 5 stars Worth it. 22 July 2014
By Michael Ryan Manzelmann - Published on
Format:Paperback|Verified Purchase
I've used Sybex books for all of my Comptia certifications, and the MCSA series doesn't disappoint. This book has all the information and practice tests that you need to pass the MCSA certification. Definitely recommend if you're interested in being a SQL administrator.
3.0 out of 5 stars Three Stars 16 Feb. 2015
By L Wilson (TN) - Published on
Format:Paperback|Verified Purchase
The book seems to provide indepth SQL knowledge but I ended up selling due to a career change.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category