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.
Target Audience
This course is intended for SQL Server database
administrators, implementers, system engineers, and
developers who are responsible for writing queries.
Topics
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.
Prerequisites
Experience using a Microsoft Windows operating
system, understanding of basic relational database
concepts.
