SQL Server 2000 - Querying with Transact-SQL

Duration: 14 hours

Description: The topics covered in this course include: Using Transact-SQL Query Tools; retrieving data; grouping and summarizing data; joining multiple tables; working with subqueries; modifying data; querying full-text indexes. The class will also be introduced to programming objects.

Objective: Students learn to query using Transact-SQL.

Course Content:

Introduction to Transact-SQL

Using SQL Server Books Online

Using Transact-SQL Querying Tools

Creating and Executing Transact-SQL Scripts

Retrieving Data

Retrieving Data and Manipulating Results Sets

Grouping and Summarizing Data

Joining Multiple Tables

Querying Multiple Tables

Working with Subqueries

Modifying Data

Querying Full-Text Indexes

Introduction to Programming Objects

Working with Views