Using the Query Analyzer

·  Query Analyzer Features

·  The File Menu Items

·  The Edit Menu

·  Query Menu Items

·  Tools Menu Items

·  Window Menu Items

·  Help Menu Items

Programming with Transact-SQL

·  Overview of Transact-SQL

·  Using Built-In Functions

·  Control of Flow

·  Error Handling

Transaction Processing

·  Transactions

·  Working with Locks

·  Monitoring Processes and Locks

·  Transaction Isolation

·  Blocking and Deadlocks

Creating Views

·  What is a View?

·  Creating Views

·  Updating Views

Backups and Maintenance

·  Creating a Backup Strategy

·  Implementing Backups

·  Restoring from a Backup

·  The Database Maintenance Plan Wizard

Stored Procedures and Triggers

·  Building Stored Procedures

·  Building Triggers

·  Using INSTEAD OF Triggers

User-Defined Functions

·  User-Defined Functions in SQL Server 2000

·  Scalar Functions

·  Inline Table-Valued Functions

·  Multi-Statement Table-Valued Functions

·  Functions, Views, and Stored Procedures

Advanced Queries and Linked Servers

·  Dynamic SQL

·  Transact-SQL Cursors

·  Handling Large Data Sets

·  Distributed Queries

Security

·  Security Overview

·  Authentication

·  Understanding Roles

·  Assigning Permissions

·  Application Roles

Monitoring, Tuning and Configuration

·  Evaluating Performance

·  Monitoring with SQL Server Profiler

·  Tuning Queries

·  Working with Indexes

·  Indexed Views

·  Using the Index Tuning Wizard

·  Data Caching

·  The System Monitor