After completing Sybase: Programming with T-SQL the user should be able to:

	Identify the basic features of T-SQL and isql
	Create alter and drop tables
	Specify integrity constraints to protect databases
	Create integrity rules and defaults
	Create and manage views
	Create and manage indexes

Using T-SQL and isql

	The T-SQL language
	Datatypes
	Operators
	Interacting using isql

Managing Tables

	Creating tables
	Customizing datatypes
	Column properties
	Altering tables
	Dropping tables

Defining Integrity Constraints

	Specifying integrity constraints
	Defining constraints with create table
	Check constraints
	Referential integrity constraints
	Managing constraints and defaults

Creating Integrity Defaults and Rules

	Creating and binding defaults
	Unbinding and dropping defaults
	Creating and binding rules
	Unbinding and dropping rules

Using Views

	Using views
	Creating views
	Renaming views
	Dropping and altering views

Managing Indexes

	Creating indexes
	Single-column and composite indexes
	Unique clustered and nonclustered indexes
	Sorting data and controlling insertions
	Dropping indexes

This course has the following features:

	Simulations that allow users to practice course skills even if they don't have access to the real application
	A glossary
	A Skill Assessment