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 : Online : $2,300  (1-on-1), London : £2,500, Dubai : $2,600 , India : $1,800

March
02-06 (Birmingham)
02-06 (london)
02-06 (Manchester)
08-12 (Dubai)
09-13 (london)
April
06-10 (Birmingham)
06-10 (London)
06-10 (Manchester)
May
04-08 (Birmingham)
04-08 (London)
04-08 (Manchester)
June
01-05 (Birmingham)
01-05 (London)
01-05 (Manchester)
July
06-10 (london)
12-16 (Dubai)
13-17 (london)
Instructor-Led Online Training
Duration : 5 Days
Fee :  $2,300


March
02-06
08-12
09-13
April
06-10
May
04-08
June
01-05
July
06-10
12-16
13-17
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.

)