Microsoft Transact SQL Tutorial |2.3GB
anguage Basics
Chapter Overview
SQL Statement Types
Transact SQL Elements Overview
Data Types Fundamentals
SQL 2000 Data Types
Wildcards & Escape Characters
Logic Flow
Scripts
Batches
Transactions
Functions in SQL
Stored Procedures
Views and Triggers
Debugging

Transact SQL Tools
Query Analyzer - Lesson 1
Query Analyzer - Lesson 2
Enterprise Manager
QA Versus EM
ISQL / OSQL (including examples)
Notepad
Third Party Apps

More Than A Query Language
The Creation of Databases in TSQL
A Word About NULLS
The Creation of:
• Tables
• Constraints in MS TSQL
• Defaults
• Relationships

SELECT
Chapter Overview
Column Aliasing Explained
SELECT INTO & FROM Clause
Working with JOINS
JOIN Examples
Table Aliasing Explained
SELECT WHERE Clause
Searching For NULLS
SELECT GROUP BY Clause
SELECT HAVING Clause
SELECT ORDER BY Clause
SELECT COMPUTE Clause
UNION

INSERT
Basic INSERT Syntax
Working With INSERT
INSERT - Advanced

UPDATE
Basic UPDATE Syntax
Working With UPDATE
UPDATE - Advanced

DELETE
Basic DELETE Syntax
Working With DELETE
DELETE or TRUNCATE TABLE?

Indexes
Chapter Overview and Definition
Types Of Indexes
Determining Indexes(Guidelines)
The Creation of Indexes

Views in MS Transact-SQL
A View Explained
How to Create a View
View - Plus points

System Tables
Chapter Overview
How to Query System Tables

Variables in Transact-SQL
Tutorial Overview
How to Declare Variables
Working with Variables
Variables As Object Names
System Variables

Stored Procedures
A Stored Procedure Explained
Creating A Stored Procedure
Using Input and Output Variables
Extended Stored Procedures

Cursors
Cursors Explained

Functions
Functions - A Description
Partial List Of Functions
User Defined Functions
Scalar UDF Explained
Multi-Statement UDF
InLine UDF

Triggers
Triggers Explained
The Creation of A Trigger
The Mechanics of Triggers
Nesting and Recursive Triggers

XML
XML Explained
FOR XML
Misc XML Info

Optimising Your TSQL
How to Limit your Results
Utilising Indexes
Graphical Exec Plan / Profiler
MS TSQL Tutorial Wrap Up

Download Links