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,610 , India : $1,796


December
08-12 (Dubai)
09-13 (Chennai)
09-13 (London)
16-20 (Bangalore)
31-04 (London)
January
06-10 (Delhi)
06-10 (Dubai)
06-10 (London)
12-16 (Dubai)
13-17 (Bangalore)
13-17 (London)
20-24 (Chennai)
February
10-14 (Bangalore)
Instructor-Led Online Training
Duration : 5 Days
Fee :  $2,330


December
08-12
09-13
16-20
31-04
January
06-10
12-16
13-17
20-24
February
10-14
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.