Microsoft 70-461: Querying SQL Server 2012

299 USD 19.02 USD 94%
Test scorm

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:

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

It would be helpful to have a play all

by Freddie Bakkes

Hi there, I am enjoying your course, I have added Microsoft SQL Server Managment Studio, how do I add SQL Server (MSSQ), for the engine backend.?

by martin amtman
  • Daniel Schotter
    user_default
    Course Materials
    Hello, Do you not think that text files of some of the information discussed but not shown would be helpful? Also text files of the scripts etc. given?
  • Arlette (not verified)
    user_default
    Microsoft 70-461: Querying SQL Server 2012 | iCollege
    I have checked your blog and i've found some duplicate content, that's why you don't rank high in google's search results, but there is a tool that can help you to create 100% unique articles, search for; boorfe's tips unlimited content Also visit my web-site ... EsmeraldaChief
  • Arlette (not verified)
    user_default
    Add New Discussion | iCollege
    I have checked your blog and i've found some duplicate content, that's why you don't rank high in google's search results, but there is a tool that can help you to create 100% unique articles, search for; boorfe's tips unlimited content Also visit my web blog EsmeraldaChief
  • martin amtman
    user_default
    Installation:-
    Hi there, I have installed SQL Studio Managment Studio, trying to install SQL Server Installation with Configuration on the backend, I need some help here.!
martin amtman
user_default
Installation:-
Hi there, I have installed SQL Studio Managment Studio, trying to install SQL Server Installation with Configuration on the backend, I need some help here.!
Daniel Schotter
user_default
Course Materials
Hello, Do you not think that text files of some of the information discussed but not shown would be helpful? Also text files of the scripts etc. given?

Add New Discussion

How do you rate this product?

Select currency