SQL Server 2000 Querying with Transact-SQL training course - learn SQL Server

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

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.

Private Training Courses

We offer private training courses which may be delivered at our training centre or at your premises on dates to suit you and your delegates. Course content can follow the standard course material as listed in the course outline, or can be tailored to your specific requirements at no extra cost.

For a single company private course we normally recommend that any class does not exceed 8 delegates in order to ensure that the learning objectives are met.

Total price per day (ex-Vat)
Number of delegates	1	2	3	4	5	6	Extra Person
At our Reading Training Centre	£895	£995	£1095	£1195	£1295	£1395	£100
On your premises	£795	£875	£955	£1035	£1115	£1195	£80

For on-site courses only:

Notebook computer hire is £40 per computer per day. Savings can be made for block bookings of 2 or more days, please ask for details.
Trainer travel and accomodation is charged at cost and we can give you a fixed price quote for this prior to booking.

Course fees are payable in advance and are listed exclusive of VAT.