Who Should Attend:

Web designers and programmers, software engineers, systems analysts, applications programmers, computer science students, and anyone who is interested in acquiring the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server™ 2000.

Prerequisites:

None.

Objectives:

All database servers allow system administrators and users to issue commands with standard SQL. Most Relational Database Management Systems function with their own internal language. Microsoft SQL Server 2000 uses Transact-SQL. As such, this module teaches the technical skills for writing basic Transact-SQL queries for Microsoft SQL Server™ 2000.
After completing the module, students will be sufficiently adept at using Transact-SQL language and its querying tools, and at grouping and summarizing data with Transact-SQL. They should be able to modify data in tables, and query text fields with full-text search.

Contents:

Introduction to Transact-SQL: Transact-SQL Statements. Transact-SQL Syntax Elements. Using SQL Server Books Online.

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.

Retrieving Data: Retrieving Data by Using the SELECT Statement. Filtering Data. Formatting Result Sets. Performance Considerations. Retrieving Data and Manipulating Result Sets.

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.

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

Working with 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.

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

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.

Introduction to Programming Objects: Displaying the Text of a Programming Object. Creating Views. Introduction to Stored Procedures. Introduction to Triggers. Introduction to User-defined Functions. Working with Views.