Microsoft 70-461: Querying SQL Server 2012

Select currency

Microsoft 70-461: Querying SQL Server 2012
Test scorm
Enquire Now

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries. 

This course provides the knowledge and understanding for some of these important job functions:

  • Apply built-in scalar functions
  • Apply ranking functions
  • Combine datasets
  • Creates and alters
  • Design T-SQL stored procedures, views
  • Implementing aggregate queries, error handling, sequence generation and data types
  • Manage transactions
  • Modify data by using INSERT, UPDATE, DELETE and MERGE statements
  • Optimizing queries
  • Query data using SELECT statements and Managing XML data
  • OUTPUT clause to return data

This learning course provides the knowledge for the 70-461 Exam on Queries on Microsoft SQL Server 2012:

read more

Lesson 1: Getting Started with SQL Server 2012

Lesson 2: Working with T-SQL

Lesson 3: Writing SELECT Queries

Lesson 4: Working with SQL Data Types

Lesson 5: Sorting and Filtering Data

Lesson 6: Querying Data from Multiple Tables

Lesson 7: Modifying Data

Lesson 8: Working with SQL Server Built-in Functions

Lesson 9: Programming in T-SQL

Lesson 10: Implementing Stored Procedures

Lesson 11: Working with Subqueries and Table Expressions

Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions

Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets

Lesson 14: Managing Error Handling and Transactions

Lesson 15: Querying SQL Server System

Lesson 16: Optimizing Query Performance

  • otlxlfvp (not verified)
    user_default
    1
    1
  • karinedeva
    user_default
    Microsoft 70-461: Querying SQL Server 2012 | iCollege
    Everything is very open with a precise description of the challenges. It was really informative. Your site is very helpful. Thank you for sharing! Look at my web site - Maglie Da Calcio
  • karinedeva
    user_default
    Add New Discussion | iCollege
    Everything is very open with a precise description of the challenges. It was really informative. Your site is very helpful. Thank you for sharing! My page ... Maglie Da Calcio
  • Marcia (not verified)
    user_default
    Microsoft 70-461: Querying SQL Server 2012 | iCollege
    I needed to thank you for this excellent read!! I absolutely loved every little bit of it. I've got you bookmarked to check out new things you post… Feel free to surf to my web blog; Jacqueline
  • Marcia (not verified)
    user_default
    Add New Discussion | iCollege
    I needed to thank you for this excellent read!! I absolutely loved every little bit of it. I've got you bookmarked to check out new things you post… Also visit my blog post ... Jacqueline