Querying Microsoft SQL Server 2000 with Transact-SQL Training Class

Lesson 1: Introduction to Transact-SQL

The Transact-SQL Programming Language
Types of Transact-SQL Statements
Transact-SQL Syntax Elements
Using SQL Server Books Online

Lesson 2: Using Transact-SQL Querying Tools

SQL Query Analyzer
Using the Object Browser Tool in SQL Query Analyzer
Using the osql Utility
Executing Transact-SQL Statements
Creating and Executing Transact-SQL Scripts

Lesson 3: Retrieving Data

Retrieving Data by Using the SELECT Statement
Filtering Data
Formatting Result Sets
How Queries Are Processed
Performance Considerations
Retrieving Data and Manipulating Result Sets

Lesson 4: Grouping and Summarizing Data

Listing the TOP n Values
Using Aggregate Functions
GROUP BY Fundamentals
Generating Aggregate Values Within Result Sets
Using the COMPUTE and COMPUTE BY Clauses
Grouping and Summarizing Data

Lesson 5: Joining Multiple Tables

Using Aliases for Table Names
Combining Data from Multiple Tables
Combining Multiple Result Sets
Querying Multiple Tables

Lesson 6: Working with Subqueries

Introduction to Subqueries
Using a Subquery as a Derived Table
Using a Subquery as an Expression
Using a Subquery to Correlate Data
Using the EXISTS and NOT EXISTS Clauses
Working with Subqueries

Lesson 7: Modifying Data

Using Transactions
Inserting Data
Deleting Data
Updating Data
Performance Considerations
Modifying Data

Lesson 8: Querying Full-Text Indexes

Introduction to Microsoft Search Service
Microsoft Search Service Components
Getting Information About Full-Text Indexes
Writing Full-Text Queries
Querying Full-Text Indexes

Lesson 9: Introduction to Programming Objects

Displaying the text of a programming object
Introduction to Views
Advantages of Views
Creating Views
Introduction to Stored Procedures
Introduction to Triggers
Introduction to User-defined Functions
Working with Views