Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases
Orin Thomas, Peter Ward, and boB Taylor
(Microsoft Press, paperback with CD)
Exam 70-462 is one of three required examinations you must pass to get a Microsoft Certified Solutions Associate (MCSA) certification for Microsoft SQL Server 2012.
This well-structured, 593-page book is designed for self-paced training and includes a CD with practice tests. The CD offers several testing modes to choose from and hundreds of test questions. The text is amply illustrated with screenshots, bullet points and numbered steps, and each lesson concludes with a lesson summary and lesson review. Answers to the lesson review questions are at the back of the book, and explanations also are provided for why the incorrect answers are wrong.
The book’s introduction covers such topics as system requirements, practice setup instructions, errata and book support links, and how to prepare for the exam.
The book’s 12 chapters focus on the following topics:
- Planning and Installing SQL Server 2012
- Configuring and Managing SQL Server Instances
- Configuring SQL Server 2012 Components
- Migrating, Importing, and Exporting
- SQL Server Logins, Roles, and Users
- Securing SQL Server 2012
- Mirroring and Replication
- Clustering and AlwaysOn
- Troubleshooting SQL Server 2012
- Indexes and Concurrency
- SQL Server Agent, Backup, and Restore
- Code Case Studies
The authors caution that you should consider this study guide just “one part of your exam preparation plan. You require meaningful, real-world experience with SQL Server 2012 to pass this exam.”
They also recommend using Hyper-V, a feature of Windows Server 2008, Windows Server 2008 R2, Widows Server 2012, and certain editions of Windows 8, “[t]o minimize the time and expense of configuring physical computers for this training kit. You can use other virtualization software instead, but the instructions are written assuming that you are using a solution that supports 64-bit operating systems hosted as virtual machines.”
— Si Dunn