Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Querying Data with Transact-SQL (M20761)

Learn basic Transact-SQL queries for Microsoft SQL Server 2016.

GK# 4395

Course Overview

Learn how to write basic Transact-SQL queries for Microsoft SQL Server 2016. This course will provide a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines—namely, database administration, database development and business intelligence.

You will learn about: T-SQL elements, writing SQL queries, querying JOINs, sorting and filtering data, SQL Server 2016 data types, T-SQL DML, built-in functions, grouping and aggregating data, subqueries, and set operators.

This course incorporates material from the Official Microsoft Learning Product 20761: Querying Data with Transact-SQL.

• Redeem three SATVs* for a Classroom, Virtual Classroom, or Virtual Classroom Fit session
• Redeem three SATVs for an individual GK Digital Learning course plus digital Microsoft Official Courseware (dMOC)
• Redeem two SATVs for an individual GK Digital Learning course

*For more information on Microsoft SATVs, click here.
GK Digital Learning is also available with digital Microsoft Official Courseware (dMOC). Click here to purchase.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.


    $2295 CAD

    3 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.


    $2195 CAD

    3 day

  • GK Digital Learning

    GK Digital Learning

    Experience high-quality online learning combined with reliable expert guidance and skills development activities.


    $1245 CAD

    90 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • Basic architecture and concepts of Microsoft SQL Server 2016
  • Similarities and differences between Transact-SQL and other computer languages
  • Write SELECT queries
  • Query multiple tables
  • Sort and filter data
  • Using data types in SQL Server
  • Modify data using Transact-SQL
  • Use built-in functions
  • Group and aggregate data
  • Use subquerie
  • Use table expressions
  • Use set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting and grouping sets
  • Execute stored procedures
  • Program with T-SQL
  • Implement error handling
  • Implement transactions

Follow-On Courses


  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Who Needs To Attend

Database administrators, database developers and business intelligence professionals, as well as SQL power users who aren’t necessarily database-focused, such as report writers, business analysts and client application developers.

Course Outline

Download Course Outline

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more