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

	Create join queries
	Use subqueries
	Insert data in databases
	Modify and delete data

Join Queries

	Inner joins
	Outer joins
	Self joins

Subqueries

	What are subqueries?
	Quantified predicate subqueries

Other Subquery Types

	Returning dependent values
	Testing for existence
	Subqueries vs. join queries

Inserting Data

	Inserting into specific columns
	Inserting rows from another table
	Inserting rows from the same table
	Inserting into an identity column
	Restricting data

Deleting and Modifying Data

	Deleting data
	Updating data
	Manipulating data through views

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