SQL Server 2000 Querying with Transact-SQL

Course Overview

This course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server 2000 database.

Basic Windows skills are assumed.

Exploring Transact-SQL
An Overview of SQL Server and Transact-SQL Programming in Transact-SQL
Querying Data
Using the SELECT Statement Formatting the Results Set
Changing Data Through Queries
Inserting Data Deleting Data Updating Data
Summarizing Data
Working with Aggregate Functions Grouping Data
Joining Tables
Querying Multiple Tables Implementing Advanced Table Joins
Implementing Subqueries
Designing Subqueries
Working with Full-text Indexes
Implementing the Microsoft Search Service Querying Full-text Indexes
Programming Transact-SQL
Creating and Managing Views Implementing Stored Procedures, Triggers, and User-defined Functions

	Printer Friendly Version
	Download Outline As PDF

The trainer took the trouble to find out what we required before the course and adapted the material to our needs very well

- Gillette