Querying Microsoft SQL Server 2014 Databases

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
Classroom Training*
Duration : 5 Days
Fee :  London: £4,500, Dubai : $2,600 , India : $1,800


February
03-07 (Delhi)
03-07 (Goa)
03-07 (london)
09-13 (Dubai)
09-13 (Goa)
10-14 (Bangalore)
10-14 (Goa)
10-14 (london)
March
02-06 (Delhi)
02-06 (Goa)
02-06 (london)
08-12 (Dubai)
08-12 (Goa)
09-13 (Bangalore)
09-13 (Goa)
09-13 (london)
16-20 (Chennai)
16-20 (Goa)
April
06-10 (Goa)
06-10 (London)
13-17 (Bangalore)
13-17 (Goa)
20-24 (Chennai)
20-24 (Goa)
Instructor-Led Online Training
Duration : 5 Days
Fee :  $2,300


February
03-07
09-13
10-14
March
02-06
08-12
09-13
16-20
April
06-10
13-17
20-24
Fly-Me-a-Trainer
Duration : 5 Days
Fee : On Request
Client's Location
As per mutual convenience

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.

)