Microsoft Course 2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL — A 4 day course

contact usEnquire about this course
Retired Course; no longer available

Synopsis

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

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

Objectives

On completion of the Microsoft M2778 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.

Prerequisites

Before attending the Microsoft 2778 course, students must have:

Knowledge of data integrity concepts.

An understanding of how Relational Databases work.

Experience with another programming language or scripting language would be beneficial.

Schedule

This course has been retired and is no longer available.


Contents

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