CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2071 - Querying MS SQL Server 2000/2005 with Transact-SQL

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

The goal of this course is to provide students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2000/2005.

Click here for a printer-friendly version of this page

Prerequisites

An understanding of basic relational database concepts including: Logical and physical database design; Data integrity concepts; Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many); How data is stored in tables (rows and columns).

Detailed Class Syllabus

Introduction to Transact-SQL

The Transact-SQL Programming Language

Types of 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

How Queries Are Processed

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

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

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

Introduction to Views

Advantages of Views

Creating Views

Introduction to Stored Procedures

Introduction to Triggers

Introduction to User-defined Functions

Working with Views