Find a Course...Try for FREE
   
Product Information
 
Shipping Information
Product Guarantee
Testimonials
 
Main Links
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 

Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials please do not hesitate to contact us for help.

Microsoft Transact SQL Tutorial

About this Tutorial show details
This beginners Microsoft Transact SQL tutorial is authored by Microsoft certified Systems Engineer Mark Long. If you want to master this language in the shortest time possible and become better prepared for the MCDBA certification, particularly Exam #70-229, then you must take a look at this comprehensive Transact tutorial!
Try this training now - See below for FREE tutorials

All Courses on 1 or 2 CDs
For Mac and PC

Microsoft Transact SQL Tutorial Information
CLICK HERE TO BUY THIS CD
Author: Mark Long
Duration: 8 hrs / 101 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €107.95 + VAT
Cost for US & Canada: $125.00
Product Code: 33380
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world
IN STOCK
- All CDs Shipped Carriage FREE -
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 
Benefits of this Software Training
 
• Transfers knowledge to you quickly and effectively.
• Step by step video training from your own desktop via CD ROM or online tuition.
• All the concepts of each application are explained clearly and precisely.
• Every course works on PC and Mac.
• Alternative to a boring book or manual and expensive training courses & classes.
• Jump to and from lessons - learn at your own pace.
• Tuition by expert authors.
Customer Testimonials
 
Associated Training CDs:
Microsoft Access 2003 | Microsoft Excel 2000 | Microsoft Excel 2003 | Microsoft Word 2003 | Microsoft PowerPoint 2003 | Microsoft Publisher 2003 | TCP/IP for Windows | Complete Range of Microsoft SQL Server 2008 Tutorials
 
Complete CD Contents and FREE Video Tutorials
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Microsoft Transact SQL Tutorial Intro
Introduction
Transact SQL Explained
TSQL - A Brief Description
Databases - A Brief History
SQL - A Brief History
What Flavour Would You Like?
SQL Terminology or Acronyms

Course Overview
Description of Course

General Database Information
A Database Explained
The Two Main Types of Databases
Normalization Overview
Denormalization Overview
Database Relationships
Some Course Notes

We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD.
CLICK HERE TO BUY THIS CD


Language 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 Transact SQL
A Word About NULLS
The Creation of:
• Tables
• Constraints in Transact SQL
• 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

CLICK HERE TO BUY THIS CD