Microsoft Transact SQL Tutorial - Training Videos

Training CDs > Databases Tutorial Videos > MICROSOFT TRANSACT SQL

Affordable Training you can depend on
This Microsoft Transact SQL video tutorial utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that brings a high degree of visual clarity to even the most complex applications. Being over 7.5 hours long these Microsoft Transact SQL tutorials are extremely comprehensive and easy to follow. Video Training by Experts - Low Cost.

Not sure which Training CDs to buy?
The Online University allows unlimited access to the entire range of training titles for one low fee of only $30 per month. There is no fixed term, no limits, and you can cancel at any time. For corporate users and schools we also offer multi user accounts.
Find out more about the online video tutorials »

About the Free Video Online Training Course Demos
To allow you to evaluate the quality of the Microsoft Transact SQL training course we have made the first 3 chapters of this tutorial available for free viewing online, the purchased version of this training course contains all the topics listed below. The free demos below have been compressed for faster playback over the internet, the audio and video quality of the purchased CD / DVD is far greater. To play the free demo videos you will need QuickTime,

THIS TUTORIAL COVERS THE FOLLOWING SUBJECTS

Description

The visual nature of this Microsoft Transact SQL tutorial videos ensures that users of all levels can learn faster than with any other method of training, users will also benefit from a much higher retention rate then with conventional forms of training. All courses are created using expert authors and recorded with studio quality audio and video, users can expect to receive the same high standard of training that would be taught on a dedicated classroom based course, but for a fraction of the cost.

Users have total control over the speed at which they learn, lessons can be stopped, rewound or fast forwarded at any time, this video tutorial is structured to accommodate both beginner and intermediate users, ideal for people that need to fit comprehensive training into a busy schedule. To sample a free demo of this Microsoft Transact SQL training video click one of the links below.

Microsoft Transact SQL Related Groups

Hide Description

The Blue Links below are free demos, when you purchase the video training CD / DVD the enitre content listings below are included , not just the free demo videos.

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 Pt. 1
Query Analyzer Pt. 2
Enterprise Manager
QA vs. EM
ISQL / OSQL
ISQL / OSQL Examples
Notepad
Third Party Apps

More Than A Query Language

Creating 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 Tutorials - VIDEO INFO

» Studio quality audio and video
» Works on Pc or Mac
» Ideal for people that learn quicker by being shown
» Master complex application in days

Title	:	Microsoft Transact SQL
Instructor	:	Mark Long / Certified Instructor
Price	:	US$ 99.95
Duration	:	7.5 hours - 101 Movies
OS	:	Win Vista XP 98,2000,ME. Mac OS 9, OS X
Delivery Options	:	Ground / 2 day / Next Day
Product Code	:	33380

BENEFITS OF THIS TRAINING COURSE

Master Microsoft Transact SQL in the shortest time possible
Self paced tutorial, training on video, at your own pace
Just sit back and watch, no books to read, just easy to follow lessons
Training can be viewed from any location, on PC or Mac
All training is self-contained; you don’t even need the application you are learning loaded on your machine
The most affordable way to learn, benefit from a world-leading expert
High quality content for a fraction of the cost of a classroom training course
The Tutorials can be rewound, fast forwarded or stopped at any time
Learn from the comfort of your own desk.