| Outline: |
|
| 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
|
Top |
| 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
|