PRODUCT INFO
 
Shipping Information
Product Guarantee
Testimonials
 
MAIN LINKS
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 


This Week's Special Offer

NEW TITLE DISCOUNT!
Final Cut Pro 7 Tutorial


Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.

Microsoft Transact SQL Tutorial
 Professionally created, self-study video training.

About this Tutorialshow details
Using step by step training movies, Microsoft certified Systems Engineer Mark Long presents this beginners Microsoft Transact SQL tutorial that demonstrates the important concepts and techniques in an easy to follow manner. If you want to master this language in the shortest time possible and become better prepared for the MCDBA certification, particularly Exam #70-229, then you must take a look at this comprehensive MS Transact tutorial! You can start learning right away,click any of the blue linked lessons below for FREE Transact tutorials...
Learn this Software - See below for FREE TUTORIALS

Each Course on 1 or 2 CDs
For Mac and PC

FREE Shipping on all Orders


Microsoft Transact SQL Tutorial Info

CLICK HERE TO BUY THIS CD
Tutor: Mark Long
Duration: 8 hrs / 101 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33380
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers use simplistic terms and minimal jargon.
  Step-by-step video training from your own desktop. Delivered via CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses & classes.
  Jump to and from lessons - learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials
Associated Training CDs:
Database Optimisation | MCTS Certification Exam 70-642 | Fedora 11 | WordPress 2.8 | Microsoft Windows 7 | Microsoft Exchange 2007 | TCP/IP for Windows | Complete Range of Microsoft SQL Server Tutorials | Complete Range of Oracle tutorials | Crystal Reports XI
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

Microsoft Transact SQL Tutorial Intro
Introduction
Transact SQL Explained
TSQL - A Brief Description
Databases - A Brief History
SQL - A Brief History
What Flavour Would You Like?
SQL Terminology or Acronyms

Course Overview
Description of Course

General Database Information
A Database Explained
The Two Main Types of Databases
Normalization Overview
Denormalization Overview
Database Relationships
Some Course Notes

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the CD.
CLICK HERE TO BUY THIS CD

Language Basics
Chapter Overview
SQL Statement Types
Transact SQL Elements Overview
Data Types Fundamentals
SQL 2000 Data Types
Wildcards & Escape Characters
Logic Flow
Scripts
Batches
Transactions
Functions in SQL
Stored Procedures
Views and Triggers
Debugging

Transact SQL Tools
Query Analyzer - Lesson 1
Query Analyzer - Lesson 2
Enterprise Manager
QA Versus EM
ISQL / OSQL (including examples)
Notepad
Third Party Apps

More Than A Query Language
The Creation of Databases in TSQL
A Word About NULLS
The Creation of:
• Tables
• Constraints in MS TSQL
• Defaults
• Relationships

SELECT
Chapter Overview
Column Aliasing Explained
SELECT INTO & FROM Clause
Working with JOINS
JOIN Examples
Table Aliasing Explained
SELECT WHERE Clause
Searching For NULLS
SELECT GROUP BY Clause
SELECT HAVING Clause
SELECT ORDER BY Clause
SELECT COMPUTE Clause
UNION

INSERT
Basic INSERT Syntax
Working With INSERT
INSERT - Advanced

UPDATE
Basic UPDATE Syntax
Working With UPDATE
UPDATE - Advanced

DELETE
Basic DELETE Syntax
Working With DELETE
DELETE or TRUNCATE TABLE?

Indexes
Chapter Overview and Definition
Types Of Indexes
Determining Indexes(Guidelines)
The Creation of Indexes

Views in MS Transact-SQL
A View Explained
How to Create a View
View - Plus points

System Tables
Chapter Overview
How to Query System Tables

Variables in Transact-SQL
Tutorial Overview
How to Declare Variables
Working with Variables
Variables As Object Names
System Variables

Stored Procedures
A Stored Procedure Explained
Creating A Stored Procedure
Using Input and Output Variables
Extended Stored Procedures

Cursors
Cursors Explained

Functions
Functions - A Description
Partial List Of Functions
User Defined Functions
Scalar UDF Explained
Multi-Statement UDF
InLine UDF

Triggers
Triggers Explained
The Creation of A Trigger
The Mechanics of Triggers
Nesting and Recursive Triggers

XML
XML Explained
FOR XML
Misc XML Info

Optimising Your TSQL
How to Limit your Results
Utilising Indexes
Graphical Exec Plan / Profiler
MS TSQL Tutorial Wrap Up

CLICK HERE TO BUY THIS CD


  UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841

  US & Canada
Marrutt Software Training
244 5th Ave # 1877
New York, NY 10001
United States
US Tel: 646-736-7932
US Fax: 646-895-7649