SQL Server 2000 Querying with Transact-SQL

2 days

Overview

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

Prerequisites

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

Systematix Training - tel: 0118 3243000 - www.systematix.co.uk
SQL Server 2000 Querying with Transact-SQL training courses