2012
VTC
Mark Long
~8.5h
English
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. This VTC course is intended for SQL Server database administrators, implementers, system engineers, and developers who are preparing to take the 70-461 exam as well as those who are just beginning to learn Transact-SQL. Mark Long is the instructor and will take you through the various tools and concepts needed to help you get ready for the 70-461 exam.
Introduction
Getting Set Up
SQL Server 2012 Management Studio
Creating Database Objects
Basic Select Queries
More Advanced Select Statements
SQL Server 2012 Data Types
Using Joins
Querying Metadata
Inserts / Updates / Deletes
Subqueries
Table Expression
Stored Procedures
Functions
Transactions
Conclusion
Credits
http://www.vtc.com/products/Querying-Microsoft-SQL-Server-2012-Exam-70-461-Tutorials.htm
Download File Size:883.77 MB