Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

These Microsoft Transact SQL tutorials are an ideal way for system and database administrators to gain a solid working knowledge of not only the data definition, manipulation, and the language syntax but you will also be better prepared for the MCDBA certification exam 70 – 229. By the conclusion of this training CD users will have a strong understanding of all the TSQL tools, the Query Analyzer and also the Enterprise Manager

Associated Tutorials: MCDST Certification Training Video | Microsoft SQL Reporting Services | Crystal Reports Tutorial | Microsoft Visual Basic 2008 | Microsoft SQL Server 2008 Admin | Microsoft SQL Server 2008 Development | Microsoft LINQ Tutorial

Microsoft Transact SQL Tutorial CD / DVD

When you order this Microsoft Transact SQL Video Tutorial CD You'll Receive...
Over 8 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Microsoft Transact SQL from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" The network and database in our small marketing firm was a mess! After getting it under control with some of your tutorials, we're looking at getting some of the Adobe training titles next. "Amanda Larson, West Virginia

Microsoft Transact SQL Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 8 Hours in Duration and Covers 101 Lessons.
Course Intro Course Overview General Database Information
We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.
$99.95
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 Lesson 1
  • Query Analyzer Lesson 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

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

About this Microsoft Transact SQL Training CD

Title Microsoft Transact SQL
Tutor Mark Long
Other tutorials by Mark Long
Videos 101 Lessons- Video run time: 8 hours
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2002
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are not Enabled on this title
400 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
No contract .
No minimum period.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Microsoft Transact SQL from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

Oracle PL/SQL | Microsoft SQL Server Admin Tutorials | Microsoft SQL Server Programming| Online Microsoft Transact SQL Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.