Querying Microsoft SQL Server 2000 with Transact-SQL

Aims and Objectives
Use querying tools.
Write SELECT queries to retrieve data.
Write queries that retrieve and modify data by using subqueries.
Describe the uses of and ways to execute the Transact-SQL language.
Query text fields with full-text search.
Modify data in tables.
Group and summarise data by using Transact-SQL.
Join data from multiple tables.
Describe how to create programming objects.

Target Audiences
It is intended for Microsoft SQL Server database administrators, implementers, system engineers and developers.

Prerequisites
Delegates should have experience of using a Microsoft Windows operating system and have an understanding of relational database concepts.

Course Content
Module 1: INTRODUCTION TO TRANSACT-SQL
Module 2: USING TRANSACT-SQL QUERYING TOOLS
Module 3: RETRIEVING DATA
Module 4: GROUPING AND SUMMERISING DATA
Module 5: JOINING MULTIPLE TABLES
Module 6: WORKING WITH SUBQUERIES
Module 7: MODIFYING DATA
Module 8: QUERYING FULL-TEXT INDEXES
Module 9: INTRODUCTION TO PROGRAMMING OBJECTS