Prerequisites: 

To ensure your success, we recommend you first take any of the following Element K courses or have equivalent knowledge:

Windows 2000: Introduction  
Windows 98: Introduction 

Delivery Method:  

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities. 

Performance-Based Objectives

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

Course Content

Lesson 1: Exploring Transact-SQL 

An Overview of SQL Server and Transact-SQL 
Programming in Transact-SQL

Lesson 2: Querying Data 

Results Using the SELECT Statement 
Formatting the Set

Lesson 3: Changing Data Through Queries 

Inserting Data 
Deleting Data 
Updating Data 

Lesson 4: Summarizing Data 

Working with Aggregate Functions
Grouping Data

Lesson 5: Joining Tables 

Querying Multiple Tables
Implementing Advanced Table Joins

Lesson 6: Implementing Subqueries 

Subqueries

Lesson 7: Working with Full-text Indexes 

Implementing the Microsoft Search Service
Querying Full-text Indexes

Lesson 8: Programming Transact-SQL 

Creating and Managing Views
Implementing Stored Procedures, Triggers, and User-defined Functions