Course
Skills
SQL Server 2012 Querying (70-461) Part 2
Part 2 of 2 in the SQL Server 2012 Querying (70-461) series is designed to teach students how to query and work with a SQL Server 2012 database.
What you'll learn
Part 2 of 2 in the SQL Server 2012 Querying (70-461) series 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.
Table of contents
Managing Transactions
39mins
Implementing Error Handling
16mins
XML Basics
15mins
Retrieving XML
17mins
Importing XML
13mins
Creating and Altering Tables
16mins
Data Validation with Constraints
37mins
Creating and Modifying Triggers
18mins
Creating and Modifying Views
15mins
Creating and Modifying Stored Procedures
13mins
Creating and Modifying User Defined Functions
16mins