Querying Microsoft SQL Server 2012 – 70-461

Useful links whilst studying for 70-461

Exam Syllabus

Querying Microsoft SQL Server 2012 – 70-461 

https://www.microsoft.com/learning/en-us/exam-70-461.aspx

Skills Measured

Create database objects (24%)

Work with data (27%)

Modify data (24%)

Troubleshoot and optimize (25%)

Exam Prep Videos

MCSA Certification Prep | Exam 461: Querying Microsoft SQL Server 2012

Microsoft Virtual Academy 

http://www.microsoftvirtualacademy.com/

Querying Microsoft SQL Server 2012 Databases Jump Start

https://www.microsoftvirtualacademy.com/en-US/training-courses/querying-microsoft-sql-server-2012-databases-jump-start-8241

Querying with Transact-SQL

http://www.microsoftvirtualacademy.com/training-courses/querying-with-transact-sql

Using XML in SQL Server and Azure SQL Database

https://www.microsoftvirtualacademy.com/en-US/training-courses/using-xml-in-sql-server-and-azure-sql-database-8747

Training Kit Book

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

Books online for SQL Server 2012

https://msdn.microsoft.com/en-us/library/ms130214%28v=sql.110%29.aspx