Course Information

Course CodeMS2071 (MOC2071) (M2071)
Fee£635 (Exclusive of VAT)
DurationTwo Days
Delivery FormatInstructor-led
Scheduled Dates:Please Contact Us for Information

Introduction

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

Audience

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

Completion

Prerequisites

Examinations

Materials

The student kit includes a comprehensive workbook and other necessary materials for this class. The following software is provided in the student kit:

Course Outline

Module 1: Introduction to Transact-SQL

The following topics are covered in this module:

After completing this module, you will be able to:

Module 2: Using Transact-SQL Querying Tools

The following topics are covered in this module:

After completing this module, you will be able to:

Module 3: Retrieving Data

The following topics are covered in this module:

After completing this module, you will be able to:

Module 4: Grouping and Summarizing Data

The following topics are covered in this module:

After completing this module, you will be able to:

Module 5: Joining Multiple Tables

The following topics are covered in this module:

After completing this module, you will be able to:

Module 6: Working with Subqueries

The following topics are covered in this module:

After completing this module, you will be able to:

Module 7: Modifying Data

The following topics are covered in this module:

After completing this module, you will be able to:

Module 8: Querying Full-Text Indexes

The following topics are covered in this module:

After completing this module, you will be able to:

Module 9: Introduction to Programming Objects

The following topics are covered in this module:

After completing this module, you will be able to: