Microsoft Course 2778 - Writing Queries Using Microsoft SQL Server 2008/2005 Transact-SQL — A 3 day course

contact usEnquire about this course
Retired Course; no longer available


This course has been retired. Please review the M10774 - Querying Microsoft SQL Server 2012 course here.

This Microsoft M2778 instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

The Microsoft M2778 course primarily covers SQL 2008, however it also applies to SQL 2005. Our instructors will highlight the differences and explain how things apply to SQL 2005.


On completion of the Microsoft 2778 training course, delegates should be able to:

Suitable For

The Microsoft MS2778 course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries.


Before attending this course, students should have the following prerequisites:

Knowledge of data integrity concepts

Core Windows Server skills

Relational database design skills

Programming skills


This course has been retired and is no longer available.


Getting Started with Databases and Transact-SQL in SQL Server 2008

Querying and Filtering Data

Grouping and Summarizing Data

Joining Data from Multiple Tables

Working with Subqueries

Modifying Data in Tables

Querying Metadata, XML, and Full-Text Indexes

Using Programming Objects for Data Retrieval

Using Advanced Querying Techniques