STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online! STUDY FROM HOME! All Courses Available Online!

Querying Microsoft SQL Server 2014 Databases/20461C/70-461

Overview

This module will teach students how to write necessary Transact-SQL queries for MS SQL Server 2014. This module is planned for Database Developers, Database Administrators, and Business Intelligence professionals. After completing this module, students will be able to: explain the basic architecture and concepts of MS SQL Server and comprehend the differences and similarities between Transact-SQL and other computer languages.

This course prepares you for Exam 70-461. Download Course Contents
Schedule & Prices
Course Details Schedule
Live Online Training (Instructor-Led)
Duration : 5 Days (10 Day for 4 Hours/Day)
Fee : USD 1,700 (1-on-1)†



April

8 Hours/Day
4 Hours/Day
13-17
20-24
13-22
20-29
May

8 Hours/Day
4 Hours/Day
04-08
18-22
04-13
18-27
June

8 Hours/Day
4 Hours/Day
01-05
01-10
July

8 Hours/Day
4 Hours/Day
06-10
06-15
Fly-Me-a-Trainer
Duration : 5 Days
Fee : On Request
Client's Location
As per mutual convenience
Classroom Training*
Duration : 5 Days
Fee : Sydney : USD 3,000 London : USD 3,200 Dubai : USD 2,700 India : USD 1,700
May
18-27 (Chennai) (Venue)
June
01-10 (Birmingham) (Venue)
01-05 (Brisbane) (Venue)
01-05 (London) (Venue)
01-05 (Manchester) (Venue)
01-05 (Melbourne) (Venue)
01-05 (Sydney) (Venue)
July
06-15 (Delhi) (Venue)
06-10 (London) (Venue)

Enquire Now




Input symbols

Upon Completion of this Course, you will accomplish following:

  • Using Books Online. Understanding Predicate Logic.
  • Understanding the Logical Order of Operations in SELECT statements.
  • Executing queries which sort data using ORDER BY.
  • Using Column and Table Aliases.
  • Querying with Cross Joins and Self Joins.
  • Working with Unknown and Missing Values.
  • Writing Queries That Use Character Functions.
  • Using Inline Table-Valued Functions.
  • Exploring Window Functions.
  • Writing Queries with UNPIVOT and PIVOT.

Give an edge to your career with Microsoft certification training courses. Students can join the classes for Querying Microsoft SQL Server 2014 Databases Training & Certification Course at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.

)