Selecting Data

Filtering and Ordering Data

Adding, Changing and Deleting Data

Aggregating and Grouping Data

Working with Multiple Tables

Indexes and Performance

Using Temporary Tables

Using Variables with Transact-SQL

Conditional Logic with Transact-SQL

Using Cursors with Transact-SQL

Creating Stored Procedures with Transact-SQL