Improve job skills - Become more efficient - Produce better results !

Learn Microsoft Transact SQL (in only 7 hours)

Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.

Course 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.


Click a play button below to view a free training video. Place your order online for full access.

 

Video Tutorials Included: 99 Free Video Video Time
(minutes)

Course Overview

General Database Information

Language Basics

Transact SQL Tools

More Than A Query Language

SELECT

INSERT

UPDATE

DELETE

Indexes

Views

System Tables

Variables

Stored Procedures

Cursors

Functions

Triggers

XML

Optimizing Your TSQL