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.
Author Name: Christopher Harrison
Author Description:
Christopher Harrison is a Microsoft Certified Trainer, focusing on SharePoint and SQL Server. He’s the owner and Head Geek at GeekTrainer, Inc. He’s been training for the last 12+ years, with a couple breaks in the middle to take on full time developer jobs. These days he focuses mostly on training, presenting at conferences and consulting. He first fell in love with technology when his father brought home a Vic-20. After graduating on to a Commodore 64 he realized there was a career to be ha… more

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