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:


Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Learn how to use and execute the Transact-SQL language.

Vendor# M2778

GK# 6177

Course Overview

Gain the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008 in this course that incorporates material from the Official Microsoft Learning Product (OMLP) 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL.

Delivery Format Options

  • Classroom Live

    Classroom Live

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


    $1995 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.


    $1995 CAD

    3 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

  • Uses of and ways to execute the Transact-SQL language
  • Use querying tools
  • Write SELECT queries to retrieve data
  • Group and summarize data by using Transact-SQL
  • Join data from multiple tables
  • Write queries that retrieve and modify data by using subqueries
  • Modify data in tables
  • Query text fields with full-text search
  • Create programming objects
  • Use various techniques when working with complex queries

Follow-On Courses

Who Needs To Attend

SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries

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