Microsoft 70-461: Querying SQL Server 2012

$99.00

This course provides students with the technical skills required to be prepared for the 70-461 Querying SQL Server 2012 exam. Students will acquire the skills to write basic Transact-SQL queries for Microsoft SQL Server 2012, which is the foundation for all SQL Server-related disciplines; namely Database Administration, Database Development and Business Intelligence.

To see more Microsoft related training, click here.

Course Outline

Lesson 1: Getting Started with SQL Server 2012
  •  Course Introduction
Lesson 2: Working with T-SQL
  •  Creating Queries-Part 1
  •  Creating Queries-Part 2
  •  Creating Queries-Part 3
  •  Creating Queries-Part 4
  •  Creating Queries-Part 5
  •  Constraints-Part 1
  •  Constraints-Part 2
  •  Constraints-Part 3
  •  Constraints-Part 4
  •  Constraints-Part 5
Lesson 3: Writing SELECT Queries
  •  Select Statement-Part 1
  •  Select Statement-Part 2
  •  Select Statement-Part 3
  •  Select Statement-Part 4
Lesson 4: Working with SQL Data Types
  •  Data Types-Part 1
  •  Data Types-Part 2
  •  Data Types-Part 3
  •  Data Types-Part 4
  •  Data Types-Part 5
  •  Data Types-Part 6
  •  Data Types-Part 7
  •  Data Types-Part 8
  •  Data Types-Part 9
  •  Data Types-Part 10
Lesson 5: Sorting and Filtering Data
  •  Sorting Results-Part 1
  •  Sorting Results-Part 2
  •  Sorting Results-Part 3
  •  Sorting Results-Part 4
  •  Sorting Results-Part 5
  •  Sorting Results-Part 6
Lesson 6: Querying Data from Multiple Tables
  •  Tables Part 1
  •  Tables Part 2
  •  Tables Part 3
  •  Tables Part 4
  •  Tables Part 5
  •  Tables Part 6
Lesson 7: Modifying Data
  •  Inserting Data-Part 1
  •  Inserting Data-Part 2
  •  Inserting Data-Part 3
  •  Inserting Data-Part 4
  •  Inserting Data-Part 5
  •  Inserting Data-Part 6
Lesson 8: Working with SQL Server Built-in Functions
  •  Functions
  •  Parse
  •  Logical Functions
  •  Group By
Lesson 9: Programming in T-SQL
  •  Programming-Part 1
  •  Programming-Part 2
  •  Programming-Part 3
  •  Programming-Part 4
  •  Programming-Part 5
  •  Programming-Part 6
Lesson 10: Implementing Stored Procedures
  •  Storage Procedures-Part 1
  •  Storage Procedures-Part 2
  •  Dynamic SQL-Part 1
  •  Dynamic SQL-Part 2
Lesson 11: Working with Subqueries and Table Expressions
  •  Sub-Queries And Table Expressions-Part 1
  •  Sub-Queries And Table Expressions-Part 2
  •  Sub-Queries And Table Expressions-Part 3
  •  Sub-Queries And Table Expressions-Part 4
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
  •  Set Operators-Part 1
  •  Set Operators-Part 2
  •  Window Functions-Part 1
  •  Window Functions-Part 2
  •  User Defined Functions-Part 1
  •  User Defined Functions-Part 2
  •  Advanced Analytical Functions
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
  •  Pivot
  •  Grouping Sets
Lesson 14: Managing Error Handling and Transactions
  •  Error Handling-Part 1
  •  Error Handling-Part 2
  •  Manage Transactions-Part 1
  •  Manage Transactions-Part 2
  •  Manage Transactions-Part 3
Lesson 15: Querying SQL Server System
  •  System Databases-Part 1
  •  System Databases-Part 2
  •  System Databases-Part 3
  •  System Databases-Part 4
Lesson 16: Optimizing Query Performance
  •  Query Planning-Part 1
  •  Query Planning-Part 2
  •  Index-Part 1
  •  Index-Part 2
  •  Index-Part 3
Microsoft 70-461: Querying SQL Server 2012

12 Hours 22 Minutes

84 Course Videos

53 Test Questions


Save For Later
Add to Wishlist