SQLSP3 - Microsoft SQL Server 2012: Database Querying (Exam 70-461) (Self Paced)

Getting Started with SQL Server 2012, Overview of SQL Server 2012, Work with SSMS, Working with T-SQL, Overview of T-SQL, Work with T-SQL Statements, Manage SQL Server Constraints, Writing SELECT Queries, Write SELECT Statements, Assign Aliases Using Queries, Write CASE Expressions, Working with SQL Data Types, Work with String and Numeric Data Types, Work with Date and Time Data Types, Work with Binary Data Types, Work with the XML Data Type, Sorting and Filtering Data, Sort the Queried Data, Filter the Queried Results, Work with Predicates, Perform Advanced Filtering, Querying Data from Multiple Tables, Combine Data Using Simple Joins, Create Queries Using Join Algorithms, Modifying Data, Insert Data, Update Data, Delete Data, Merge Data, Working with SQL Server Built-in Functions, Create Queries Using Built-in Functions, Create Queries to Test Nullability, Group and Aggregate Data, Programming in T-SQL, Work with Variables and Batches, Control Program Flow, Manage Triggers, Work wit