Identify the features of Transact-SQL and use the Transact-SQL utilities to query a SQL server

Retrieve data by using the SELECT statement

Modify data by using the INSERT, UPDATE, and DELETE statements

Summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses

Query multiple tables through the use of joins

Design subqueries

Work with full-text indexes.

Describe the types of programming objects in Transact-SQL

Topic 1A: An Overview of SQL Server and Transact-SQL

Task 1A-1: Defining the Role of SQL Server

Task 1A-2: Defining the Types of SQL Statements

Task 1A-3: Using SQL Server Books Online

Task 1A-4: Using SQL Query Analyzer

Task 1A-5: Observing and Executing a SQL Script File

Task 1A-6: Defining Data Types

Task 1A-7: Working with Object Names

Topic 1B: Programming in Transact-SQL

Task 1B-1: Using Variables

Task 1B-2: Using Operators in a Query

Task 1B-3: Creating a Table Using the Basic Table Template

Task 1B-4: Using Osql

Topic 2A: Using the SELECT Statement

Task 2A-1: Selecting Data

Task 2A-2: Using Comparison Operators in a WHERE Clause

Task 2A-3: Using Wildcards in Queries

Task 2A-4: Working with Logical Operators

Task 2A-5: Retrieving Data Based on a Range or List of Values

Topic 2B: Formatting the Results Set

Task 2B-1: Sorting Data

Task 2B-2: Using the DISTINCT Keyword

Topic 3A: Inserting Data

Task 3A-1: Inserting Data Into the Customer Table in the Movies Database

Task 3A-2: Using the INSERT...SELECT Statement

Task 3A-3: Using the SELECT...INTO Statement

Topic 3B: Deleting Data

Task 3B-1: Using the DELETE Statement

Task 3B-2: Deleting Rows Based on a Query

Task 3B-3: Using the TRUNCATE TABLE Statement

Topic 3C: Updating Data

Task 3C-1: Using the UPDATE Statement

Task 3C-2: Updating a Table Based on a Query

Task 3C-3: Working with Explicit Transactions

Topic 4A: Working with Aggregate Functions

Task 4A-1: Using Aggregate Functions to Summarize Data

Task 4A-2: Using TOP in a Query

Topic 4B: Grouping Data

Task 4B-1: Designing GROUP BY Queries

Task 4B-2: Using the WITH ROLLUP Operator

Task 4B-3: Using the WITH CUBE Operator

Task 4B-4: Using the GROUPING Function With the WITH CUBE Operator

Topic 5A: Querying Multiple Tables

Task 5A-1: Designing and Executing an Inner Join

Task 5A-2: Working with Cross Joins

Task 5A-3: Working with Self Joins

Topic 5B: Implementing Advanced Table Joins

Task 5B-1: Joining Multiple Tables

Task 5B-2: Combining SELECT Statements

Topic 6A: Designing Subqueries

Task 6A-1: Using a Subquery as a Table

Task 6A-2: Using Subqueries as an Expression

Topic 7A: Implementing the Microsoft Search Service

Task 7A-1: Enabling Full-text Indexing on the Movie Table

Task 7A-2: Populating a Full-text Index

Task 7A-3: Configuring SQL Server to Automatically Update Full-text Indexes

Topic 7B: Querying Full-text Indexes

Task 7B-1: Using the CONTAINS Search Condition in Queries

Task 7B-2: Using the CONTAINSTABLE Function in Queries

Task 7B-3: Using the FREETEXTTABLE Function in Queries

Topic 8A: Creating and Managing Views

Task 8A-1: Creating a View

Task 8A-2: Displaying View Information

Task 8A-3: Dropping a View

Topic 8B: Implementing Stored Procedures, Triggers, and User-defined Functions

Task 8B-1: Using Books Online to Research System Stored Procedures

Task 8B-2: Creating a Stored Procedure

Task 8B-3: Executing a Stored Procedure

Task 8B-4: Creating an INSERT Trigger

Task 8B-5: Designing and Creating a Scalar Function

Table Design