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

Excellent atmosphere, good environment. Trainer works closely with Dell to make software on Systematix systems more like systems used at Dell

- Dell