After completing Sybase: Using SQL Server the user should be able to:

	Explain the basic features of SQL Server
	Describe the major functions of SQL and T-SQL
	Describe the security features and roles of SQL Server
	Perform database queries with isql
	Manage database tables
	Update and maintain databases

SQL Server Overview

	Introduction to the SQL Server
	SQL Server architecture
	Task management

SQL Server Functions

	Multiple-user connections
	Housekeeping
	Query optimizer
	Recovery services

SQL Server Features

	Database components
	Database and table types
	Logging and caching

T-SQL and Database Integrity

	T-SQL features
	Enforcing data integrity
	Maintaining referential integrity

Triggers Partitions and Security

	Triggers
	Locking
	Partitions
	Security

Using isql and Performing Queries

	Getting started
	Database querying

Viewing Managing and Creating Tables

	Using views
	Creating and maintaining tables

Maintaining Databases

	Updating database tables
	Ensuring data integrity
	Referential integrity

This course has the following features:

	Exercises that allow users to practice in SQL Server
	A file containing the text of the exercises
	Simulations that allow users to practice course skills even if they don't have access to Sybase SQL Server
	A glossary
	A Skill Assessment