clear-dot.gif
Search for a Title:
AddThis Social Bookmark Button
clear-dot.gif
   Master Microsoft Transact SQL - Free Tutorials!
clear-dot.gif
clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif clear-dot.gif clear-dot.gif
clear-dot.gif
Virtual Training Company's Transact SQL tutorial is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification, particularly Exam #70-229. It will also help you become a better Database Administrator. Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures. He even touches on XML. To get started, simply click on one of the movie links below.
Microsoft Transact SQL Training
Access the complete Microsoft Transact SQL Training title online with just your Web browser. Join our Online University and have unlimited access to these tutorials for Microsoft Transact SQL plus all our 400+ other titles for one low price! LEARN MORE or SIGN UP NOW FOR INSTANT ACCESS
OR
Learn Microsoft Transact SQL from our PC and Mac compatible CDRom. The affordable price of $99.95 gives you high quality software training that is easy for anyone to understand and follow. Start training straight away with our Free lesson links on the right or BUY THIS CD NOW!

Are you ready to start your learning RIGHT NOW? You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!

The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.

-- More Info / Subscribe Now! --

FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!

-- More Info / Subscribe Now! --

No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.

-- More Info / Subscribe Now! --

Training a Group?
Our Multi-User Online Account makes training groups of people efficient and cost effective. Businesses, Schools (from Elementary through Post Secondary), and Government Departments alike all over the world enjoy the freedom and benefits of our online training and tutorials from office, school, home, and on the go.

-- Multi-User Licensing Info --

Microsoft Transact SQL
- Information About This Title -
Click Here To Purchase
Proper Title: Microsoft Transact SQL
Description: Click here to open / close full description
Virtual Training Company's Transact SQL tutorial is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification, particularly Exam #70-229. It will also help you become a better Database Administrator. Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures. He even touches on XML. To get started, simply click on one of the movie links below.

-Close-
Instructor: Mark Long/Certified Instructor (more by this author)
Instruction: 101 Tutorials - Duration: 7.5 hrs
First Release: 2002-10-15
Compatitibility: Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+
In Stock? Yes - 2-5 days shipping
Price: $99.95
Click Here To Purchase
Why Learn With VTC?!
  1. Let an expert teach you Microsoft Transact SQL
  2. No classrooms or schedules - you learn on YOUR terms
  3. No books to read - watch instructional video right on your computer
  4. VTC training methods ensure the highest possible retention and fastest learning
  5. Use VTC materials for future reference / refresher
  6. Share CDRom training with others, friends, colleagues
  7. Used by many schools, universities, and big business world wide
  8. The most cost effective training available for Microsoft Transact SQL
 
Below is content list for all of the lessons included with the Microsoft Transact SQL Training. Click on the linked lessons to watch Free. You must have Quicktime installed on your computer - if you are using a recent computer, then chances are you already do.
Free Demo Lessons

Course Intro
movie image Welcome/Intro
movie image What Is Transact SQL?
movie image A Few
movie image About TSQL
movie image History of Databases
movie image History of SQL
movie image What Flavor Would You Like?
movie image SQL

Course Overview
movie image Course Overview & Description

General Database
movie image What Is A Database?
movie image Two Main Types of Databases
movie image Normalization
movie image
movie image Database Relationships
movie image Database Design Concerns


... More lessons below ...

Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase the CDRom version!

. Subscribe Now!
. Online University Info
. Purchase CDRom Now

Language Basics
SQL
Types
Transact SQL Elements
Data Types Overview
SQL 2000 Data Types

& Escape Characters
Logic Flow
Scripts
Batches
Transactions

Stored Procedures
Views
Triggers
Debugging

Transact SQL Tools

Analyzer
Enterprise Manager
QA vs. EM
ISQL / OSQL
ISQL / OSQL Examples

Third Party Apps

More Than A Query Language
Creating Databases
A Word About
Creating Tables
Creating Constraints
Creating Defaults
Creating

SELECT
Basic SELECT
Column Aliasing
SELECT INTO Clause
SELECT
Clause
Using JOINS
JOIN Examples
Table Aliasing
SELECT WHERE Clause

For NULLS
SELECT GROUP BY Clause
SELECT HAVING Clause
SELECT ORDER BY Clause

COMPUTE Clause
UNION

INSERT
Basic INSERT Syntax
Using INSERT
Advanced

UPDATE
Basic UPDATE Syntax
Using UPDATE
Advanced UPDATE

DELETE

DELETE Syntax
Using DELETE
DELETE or TRUNCATE TABLE?

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

Views

Is A View?
Creating Views
Advantages of Views

System Tables
Overview of System
Querying System Tables

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

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

Cursors
What Are

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

Triggers
What Are
Creating A Trigger
How Triggers Work
Nesting & Recursive Triggers
What Is XML?
FOR XML
Misc XML Info

Optimizing Your TSQL
Limiting
Utilizing Indexes
Graphical Exec Plan/Profiler
clear-dot
blue dot
clear-dot

Want to be notified of new releases and other product information?
Enter your email address below to signup for our newsletter.

clear-dot
blue dot
clear-dot
Online Learning | Contact Us | Tech Support | XML RSS Feed
clear-dot
blue dot

Global Sales
1623 Military Road #703
Niagara Falls, NY, USA
14304-1745
1-877-882-2262 or sales@vtcGlobalSales.com
VTC Canada
200 N. Service Rd W., Suite 1-377
Oakville, ON, Canada
L6M 2Y1
905-465-1263 or sales@vtcCanada.com


©2008 VTC Global Sales / VTC Canada All Rights Reserved.