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.

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.

• 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