2071 QUERYING MICROSOFT SQL SERVER 2000 WITH TRANSACT-SQL

Module 1: Introduction to Transact-SQL
The following topics are covered in this module:
· The Transact-SQL Programming Language
· Types of Transact-SQL Statements
· Transact-SQL Syntax Elements
·Using SQL Server Books Online

Module 2: Using Transact-SQL Querying Tools
The following topics are covered in this module:
· 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

Module 3: Retrieving Data
The following topics are covered in this module:
· Retrieving Data by Using the SELECT Statement
· Filtering Data
· Formatting Result Sets
· How Queries Are Processed
· Performance Considerations
· Retrieving Data and Manipulating Result Sets

Module 4: Grouping and Summarizing Data
The following topics are covered in this module:
· 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

Module 5: Joining Multiple Tables
The following topics are covered in this module:
· Using Aliases for Table Names
· Combining Data from Multiple Tables
· Combining Multiple Result Sets
· Querying Multiple Tables

Module 6: Working with Subqueries
The following topics are covered in this module:
· 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

Module 7: Modifying Data
The following topics are covered in this module:
· Using Transactions
· Inserting Data
· Deleting Data
· Updating Data
· Performance Considerations
· Modifying Data

Module 8: Querying Full-Text Indexes
The following topics are covered in this module:
· Introduction to Microsoft Search Service
· Microsoft Search Service Components
· Getting Information About Full-Text Indexes
· Writing Full-Text Queries
· Querying Full-Text Indexes

Module 9: Introduction to Programming Objects
The following topics are covered in this module:
· 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