Microsoft Transact SQL Tutorials

Details

Highly Effective Microsoft Transact SQL tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on 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
Close
Microsoft Transact SQL Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free Microsoft Transact SQL Tutorial Videos.

Try for FREE - NOW
To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
This tutorial can also be viewed using Flash:
Click To View in Flash
Course Intro Welcome/Intro Demo
What Is Transact SQL? Demo
A Few Words About TSQL Demo
History of Databases Demo
History of SQL Demo
What Flavor Would You Like? Demo
SQL Terminology/Acronyms Demo Course Overview Course Overview & Description Demo General Database Information What Is A Database? Demo
Two Main Types of Databases Demo
Normalization Demo
Denormalization Demo
Database Relationships Demo
Database Design Concerns Demo
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
Enterprise Manager
QA vs. EM
ISQL / OSQL
ISQL / OSQL Examples
Notepad
Third Party Apps More Than A Query Language reating 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

Microsoft Transact SQL Training CD Information

Title : Microsoft Transact SQL
Tutor : Mark Long
Other tutorials and training by this author
Movies : 101 Lessons- Video run time: 8 Hours
Availability : Immediate Dispatch
Compatibility: Vista, 98, 2000, NT, XP, Mac OS, OSX
Released 2002-10-15
Price US / Canadian Sales $99.95

136 In Stock

Add to Cart

Why use this method of video training ?
  • Learn Microsoft Transact SQL from an accredited expert in days.
  • Ideal for beginners, easy to follow videos that offer visual clarity.
  • Master a full application for a fraction of the cost of classroom based training.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a Microsoft Transact SQL course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Microsoft Transact SQL certificate without delay.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.

Microsoft Transact SQL Related Product Groups:

FileMaker Pro | Excel Tutorials | MySQL Access Tutorials | Oracle PL/SQL | Microsoft SQL Server 2000 Admin Microsoft SQL Server 2000 Programming | Online Microsoft Transact SQL Training Courses