Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 (MCSA)

Description

Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD–featuring multiple, customizable testing options.

Maximize your performance on the exam by learning how to:

• Create database objects
• Work with data
• Modify data
• Troubleshoot and optimize queries

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Downloads

Downloads

Follow the instructions to download this book's companion files or practice files.

1. Click the Download button below to start the download.
2. If prompted, click Save.
3. Locate the .zip file on your computer. Right-click the file, click Extract All, and then follow the instructions.

Create the Sample Database

1. Start SQL Server Management Studio (SSMS).
2. Open the script file TSQL2012.sql and execute it.
3. When the script finishes executing, you should find the database TSQL2012 listed in the Available Databases drop down box.

The above link does not include the Practice Tests. If you purchased the eBook from this site, the practice test files are available for download on your Account page under the Disc Contents tab.

Sample Content

Sample Pages

Download the sample content

Updates

Errata

We've made every effort to ensure the accuracy of this book and its companion content. Any errors that have been confirmed since this book was published can be downloaded below.

Download the errata

Submit Errata