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.
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
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
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
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841
US & Canada
Marrutt Software Training
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649
UK & Europe
US & Canada