This course is designed to teach students how to query and work with a SQL Server 2012 database. Skills gained will include querying a database using joins and data aggregations and query optimization. This course includes basic management of database objects and using XML SQL Server.

The 2012 Microsoft MCSA Certification track includes Exam 70-461 Querying Microsoft SQL Server 2012. The ability to work with Transact-SQL and understand the specifics of querying Microsoft SQL server is a fundamental skill.

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.

This series will take you from front-end user to back-end wizard. You'll learn the ins and outs of working with SQL Server 2012 programmatically, covering in great detail both sides of the T-SQL language -- from creating database objects using DDL (Data Definition Language) to becoming a data ninja by writing queries that slice and dice the information stored in these database objects using DML (Data Manipulation Language).