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.