Microsoft Transact SQL Video Tutorial - Training CD

The visual nature of this Microsoft Transact SQL training DVD / CD video tutorial ensures that users of all levels can learn faster than with any other method of training, users will also benefit from a much higher retention rate then with conventional forms of training. All tutorials are created using expert authors and recorded with studio quality audio and video, users can expect to receive the same high standard of training that would be taught on a dedicated classroom based course, but for a fraction of the cost.

Users have total control over the speed at which they learn, lessons can be stopped, rewound or fast forwarded at any time, this video tutorial is structured to accommodate both beginner and intermediate users, ideal for people that need to fit comprehensive training into a busy schedule. To sample a free demo of this Microsoft Transact SQL training video click one of the links below.

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

This Microsoft Transact SQL tutorial video utilizes an easy to follow training format that is both engaging and informative. Created to assist the beginners to intermediate users, the author uses a unique training method that bring a high degree of visual clarity to even the most complex applications. Being over 7.5 hours long this Microsoft Transact SQL tutorial on CD / DVD is extremely comprehensive and easy to follow. Video Training by Experts - Low Cost

- Easy to Learn
Evaluate the high quality of this training
try a free demo Below.

Benefits

  • Works on PC or Mac
  • Professional Tutition by Experts
  • Self-Paced Learning Interface
  • Builds Practical Skills Quickly
  • Rapid Learning - High Retention
  • Free Certificate with each Tutorial

Client Testimonials

  • I am not renowned for splashing compliments about, but you have set such an incredibly high standard, that other companies offering computer training fade into insignificance. You have somehow managed to harness a unique team with an fantastic product ... AND I MEAN EVERY WORD - IF ANYONE READS THIS, BELIEVE ME ... THIS IS A TOTALLY UNSOLICITED OPINION WITH A DEEP CONVICTION - CREDIT WHERE CREDIT IS DUE. CONGRATULATIONS & PLEASE, PLEASE ... KEEP IT UP!
    John Cowburn
    Dublin Ireland

Just Released Training

Select your PlayBack Preference
Quick Time Flash

Topics covered on this Tutorial Video
are Listed Below:-

Course Intro

Course Overview

General Database Information

The purchased version of this product contains all the movies listed below as well as all the featured samples above. add to cart US$ 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 Pt. 1
  • Query Analyzer Pt. 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

When you order this Microsoft Transact SQL Training CD you'll receive:-

An effective training video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Microsoft Transact SQL Training - VIDEO INFO

Microsoft Transact SQL

Mark Long / Certified Instructor

7.5 hours - 101 Movies

US$ 99.95

Win Vista XP, 2000, 98. Mac OS X

Ground / 2 day / Next Day

33380
144 In Stock
Purchase Orders from Schools, Colleges and Government accepted

Multi User Version Available

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.
$500

Benefits of this Tutorial Training Video

  • Learn Microsoft Transact SQL in the shortest time possible
  • Self paced tutorial, training on video, learn at your own pace
  • Just sit back and watch, no books to read, just easy to follow lessons
  • Training can be viewed from any location, on PC or Mac
  • All training is self-contained; you dont even need the application you are learning loaded on your machine
  • The most affordable way to learn, benefit from a world-leading expert
  • High quality content for a fraction of the cost of a classroom training course
  • The tutorials can be rewound, fast forwarded or stopped at any time
  • Learn from the comfort of your own desk.

Prove your Skills. Free Certification

  • With every tutorial purchased a certificate is provided to prove you have embarked upon a course to improve your skills and expand your working knowledge. Each certificate has a unique verification number which enables third parties to check the authenticity of the certification using a special login verification process.

Related Tutorial Videos

Microsoft Transact SQL Related Groups


Apex Web Media ( Hyperteach )
P.O Box 398 Bolton BL7 9YS, United Kingdom.
Tel: +44 (0) 1204 592071
Fax: +44 (0) 1204 592092
Email:


Apex Web Media ( Hyperteach )
600 17th Street, Suite 2800, Denver CO 80202
Tel: Toll free 1866 402 1903 (USA) / 434 878 4158
Fax: 1 207 433 4356
Email: