Username: 
Password: 
Microsoft Transact SQL Tutorials

Online Contents For This Title

We have made some of the video tutorials for Microsoft Transact SQL freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
   Title 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.

Choose your media type:

Course Intro
  Welcome/Intro (03:05)
  What Is Transact SQL? (06:34)
  A Few Words About TSQL (05:27)
  History of Databases (05:39)
  History of SQL (05:06)
  What Flavor Would You Like? (02:57)
  SQL Terminology/Acronyms (04:54)
Course Overview
  Course Overview & Description (05:43)
General Database Information
  What Is A Database? (05:09)
  Two Main Types of Databases (05:01)
  Normalization (06:35)
  Denormalization (04:07)
  Database Relationships (04:45)
  Database Design Concerns (04:29)
Language Basics
  SQL Statement Types (03:18)
  Transact SQL Elements (05:09)
  Data Types Overview (04:11)
  SQL 2000 Data Types (07:17)
  Wildcards & Escape Characters (05:11)
  Logic Flow (05:43)
  Scripts (04:44)
  Batches (05:27)
  Transactions (05:07)
  Functions (04:28)
  Stored Procedures (04:52)
  Views (03:25)
  Triggers (03:57)
  Debugging (03:19)
Transact SQL Tools
  Query Analyzer Pt. 1 (05:16)
  Query Analyzer Pt. 2 (04:54)
  Enterprise Manager (05:21)
  QA vs. EM (05:46)
  ISQL / OSQL (03:19)
  ISQL / OSQL Examples (06:10)
  Notepad (02:41)
  Third Party Apps (02:21)
More Than A Query Language
  Creating Databases (06:15)
  A Word About NULLS (04:17)
  Creating Tables (04:01)
  Creating Constraints (05:40)
  Creating Defaults (04:25)
  Creating Relationships (04:12)
SELECT
  Basic SELECT (04:12)
  Column Aliasing (04:52)
  SELECT INTO Clause (04:12)
  SELECT FROM Clause (01:55)
  Using JOINS (05:46)
  JOIN Examples (06:33)
  Table Aliasing (03:46)
  SELECT WHERE Clause (04:11)
  Looking For NULLS (04:43)
  SELECT GROUP BY Clause (05:11)
  SELECT HAVING Clause (02:59)
  SELECT ORDER BY Clause (03:59)
  SELECT COMPUTE Clause (04:01)
  UNION (04:03)
INSERT
  Basic INSERT Syntax (05:24)
  Using INSERT (05:00)
  Advanced INSERT (03:26)
UPDATE
  Basic UPDATE Syntax (02:02)
  Using UPDATE (03:19)
  Advanced UPDATE (03:21)
DELETE
  Basic DELETE Syntax (01:51)
  Using DELETE (03:29)
  DELETE or TRUNCATE TABLE? (02:55)
Indexes
  What Is An Index? (05:57)
  Types Of Indexes (03:01)
  Determining Indexes(Guidelines) (03:20)
  Creating Indexes (05:37)
Views
  What Is A View? (02:32)
  Creating Views (04:54)
  Advantages of Views (02:31)
System Tables
  Overview of System Tables (04:22)
  Querying System Tables (05:28)
Variables
  Overview Of Variables (02:57)
  Declaring Variables (03:55)
  Using Variables (06:13)
  Variables As Object Names (04:05)
  System Variables (03:18)
Stored Procedures
  What Is A Stored Procedure? (04:03)
  Creating A Stored Procedure (05:09)
  Using Input Variables (04:56)
  Using Output Variables (04:22)
  Extended Stored Procedures (04:48)
Cursors
  What Are Cursors? (04:13)
Functions
  What Are Functions? (02:32)
  Partial List Of Functions (02:29)
  User Defined Functions (01:24)
  Scalar UDF (04:09)
  Multi-Statement UDF (04:12)
  InLine UDF (02:32)
Triggers
  What Are Triggers? (03:46)
  Creating A Trigger (03:11)
  How Triggers Work (03:44)
  Nesting & Recursive Triggers (03:04)
XML
  What Is XML? (03:01)
  FOR XML (05:31)
  Misc XML Info (02:23)
Optimizing Your TSQL
  Limiting Results (02:31)
  Utilizing Indexes (02:28)
  Graphical Exec Plan/Profiler (05:06)
Credits
  About the Author (02:09)

This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.


Tutorial Information

Title: Microsoft Transact SQL
Author: Mark Long
SKU: 33380
ISBN: 193207208x
Release Date: 2002-10-15
Duration: 7.5 hrs / 102 lessons
Captions: No
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7, Flash 8

Subscription / Purchase Information

This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.


Also Available in CD format

Single User: US$ 99.95      Purchase/Add to Cart

Select Bandwidth