Easy to follow Microsoft Transact SQL Tutorials and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Microsoft Transact SQL tutorials we also list over 400 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Microsoft Transact SQL Tutorial Try for FREE

Select a tutorial category

Discounted Training Courses

Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!

Benefits

01. Unlimited viewing.
02. Downloadable working files.
03. Expert instructors.
04. Use at home / work or both.
05. Works on PC or Mac.
06. Telephone Tech support.
07. Cancel at any time.
08. 300+ courses for 1 low fee.
09. New titles added regularly.
10. 100% Guaranteed

Should you need any help, just call - contact details at the bottom of the page.

Click here to Join

Unlimited Professional Training on over 400+ applications and programming languages for only $30.

The fastest and most cost effective way to learn! Forget boring books! No need for expensive classroom training - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.

Please Note:
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft Transact SQL training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining. If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

Can also be Viewed using Flash

Topics covered on this course include:

Course Intro

Course Overview

Course Overview & Description

General Database Information

Language Basics

SQL Statement Types
Transact SQL Elements
Data Types Overview
SQL 2000 Data Types
Wildcards & Escape Characters
Logic Flow
Scripts
Batches
Transactions
Functions
Stored Procedures
Views
Triggers
Debugging

Transact SQL Tools

Query Analyzer
Enterprise Manager
QA vs. EM
ISQL / OSQL
ISQL / OSQL Examples
Notepad
Third Party Apps

More Than A Query Language

reating Databases
A Word About NULLS
Creating Tables
Creating Constraints
Creating Defaults
Creating Relationships

SELECT

Basic SELECT
Column Aliasing
SELECT INTO Clause
SELECT FROM Clause
Using JOINS
JOIN Examples
Table Aliasing
SELECT WHERE Clause
Looking For NULLS
SELECT GROUP BY Clause
SELECT HAVING Clause
SELECT ORDER BY Clause
SELECT COMPUTE Clause
UNION

INSERT

Basic INSERT Syntax
Using INSERT
Advanced INSERT

UPDATE

Basic UPDATE Syntax
Using UPDATE
Advanced UPDATE

DELETE

Basic DELETE Syntax
Using DELETE
DELETE or TRUNCATE TABLE?

Indexes

What Is An Index?
Types Of Indexes
Determining Indexes(Guidelines)
Creating Indexes

Views

What Is A View?
Creating Views
Advantages of Views

System Tables

Overview of System Tables
Querying System Tables

Variables

Overview Of Variables
Declaring Variables
Using Variables
Variables As Object Names
System Variables

Stored Procedures

What Is A Stored Procedure?
Creating A Stored Procedure
Using Input Variables
Using Output Variables
Extended Stored Procedures

Cursors

What Are Cursors?

Functions

What Are Functions?
Partial List Of Functions
User Defined Functions
Scalar UDF
Multi-Statement UDF
InLine UDF

Triggers

What Are Triggers?
Creating A Trigger
How Triggers Work
Nesting & Recursive Triggers

XML

What Is XML?
FOR XML
Misc XML Info

Optimizing Your TSQL

Limiting Results
Utilizing Indexes
Graphical Exec Plan/Profiler

Microsoft Transact SQL Course Details

Microsoft Transact SQL Training Course
Author:	Mark Long All Training Videos by author
Duration:	8 Hours
No. of movies	101

Benefits:
Join the VTC Online University and you will have UNLIMITED access to this tutorial and all the others in the entire library for just US $30 a month. That's over 4000 hours worth of high quality training for one low price of less than $1 a day. Click here to Join

Own this Training Course on CD

If you would like to own this Microsoft Transact SQL training title on CD, you may purchase it from our online store, because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Microsoft Transact SQL tutorial on CD.

Free Certification - Prove your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Customers Comments

I was directed to your site by a professor at my University. I have not only benefited by your excellent tutorials in learning more, but I have also saved a small fortune on textbooks and other reference material.
David Willams
Essex ( UK )

Easy to Use QuickTime Format

QuickTime 120 In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.