Exam 70-461 Querying Microsoft SQL Server 2012

Part 1: Preparing for the Course Lesson 1: Working with SQL Server 2012 Tools Lesson 2: Understanding Processing Sequences Lesson 3: Introducing T-SQL Query Syntax Lesson 4: Understanding the Role of the Query Optimizer Lesson 5: Creating Scripts Lesson 6: Understanding Data Types Part 2: Programming Database Object Queries Lesson 7: Writing Simple SELECT Statements Lesson 8: Querying Multiple Tables Lesson 9: Sorting and Filtering Data Lesson 10: Using Functions Lesson 11: Grouping and Aggregating Data Lesson 12: Using Subqueries Lesson 13: Using Derived Data Structures Lesson 14: Using Set Operators Lesson 15: Controlling with Windows Lesson 16: Pivoting and Grouping SETS Lesson 17 Creating and Working with Full-Text Data Lesson 18: Querying XML Data Part 3: Creating Database Objects Lesson 19: Generating Databases Lesson 20: Generating Tables Lesson 21: Creating Views Lesson 22: Generating Stored Procedures Lesson 23: Generating Functions Lesson 24: Generating Triggers Lesson 25: Programming Access to Database Objects Part 4: Managing System Efficiencies Lesson 26: Using Management Functions Lesson 27: Controlling Transactions and Locks