Microsoft Courses 2071 Querying MS SQL 2000 with Transact SQL — A 2-Day

contact usEnquire about this course

Course Synopsis

Please note that this course is no longer available. Please see our Training Homepage for currently available courses.

The goal of this M2071 SQL training course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.

Course Objectives

On completion of this M2071 training course, delegates should be able to:

Intended Audience

This SQL training course is intended for:

Course Prerequisites

Before attending this course, delegates are expected to have:


This course will help the student prepare for the following Microsoft Certified Professional exam:

Course Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

The following software is provided in the student kit:


This course has been retired and is no longer available.

Outline Course Contents

Introduction to Transact-SQL

Using Transact-SQL Querying Tools

Retrieving Data

Grouping and Summarizing Data

Joining Multiple Tables

Working with Subqueries

Modifying Data

Querying Full-Text Indexes

Introduction to Programming Objects