Microsoft Transact SQL Tutorial Video

Details

This Microsoft Transact SQL tutorial offers users an cost effective way to master this application it days. Presented using narrated QuickTime videos that work on both PC and Mac platforms. This training CD uses practical examples and easy to follow step by step instructions to convey knowledge and accelerate the learning process, users of this training product will benefit from a degree of clarity and retention that other forms of training fail to match. Most of the tutorials are suitable for beginner to intermediate users.
Close

Microsoft Transact SQL Video Training

Contents

All the topics covered by this Microsoft Transact SQL Training CD are listed below. The blue links are FREE Demos. Suitable for use on PC or MAC.

Try for FREE - NOW

QuicktimeInformation on the free demos.
So you can sample the high quality of this training product we have made available the first free chapters for free. On the purchased product the entire listing below is included. Please note the sound and video quality of the free demos has been compressed for faster internet delivery, the audio and video on the purchased CDs is much higher. In order to play the free demos Apple QuickTime 7 or above is needed if required

Click here to Buy This Video DVD

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


If you purchase the CD all the contents listed below are also included.

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 Tutorial Video Information

Product Title: Microsoft Transact SQL
Trainer: Mark Long
Other Training courses by this author
Movie Details: 101 Lessons- Video run time: 8 Hours
Price North America $99.95
Price for Europen Sales £79.95 ( + Vat )
Delivery: 3 working days ( UK / USA and Canada )
Suitable for: Win 95, 98, 2000, NT, XP, Mac OS, OSX

136 In Stock

BUY THIS VIDEO

Benefits of this training method
  • Unique accelerated learning, master Microsoft Transact SQL in days.
  • All training courses are taught by leading experts
  • Highly informative with an unmatched level of retention
  • Easy to follow step-by-step instructions
  • Ideal for single of multi users,
  • Users control the pace of the training, lessons can be stopped, rewound or fast-forwarded at any time.
  • More cost effective than a classroom training course, learn when it suits you.

Associated Titles:

Microsoft SQL Server 2005 Tutorials | MCDST Training Video | Windows Small Business Server Tutorials | PMBOK Training Video| Linux Professional LPIC Tutorials

Unrestricted Access to every training video - $30.00

Not sure which training CD to purchase? Why not have unlimited access to the entire range of training videos featured on this site for an unbelievable price of just $30 per month, that’s a massive 4,500 hours worth.

online people

Over 4000 hours of high quality training videos covering more than 350 of the most sort after software experts, accessible right from your own desk top, and all for just $30 per month.
No minimum sign up period
For Companies and Schools we offer a Multi User version complete with control panel, monitor usage, download reports, grant access and more.

Once signed up access is granted instantly to over 350 different titles with totally no restrictions, you can view as many different titles as you wish, there are no limits on how long you can log in for, you can even access from any computer.

This is without a doubt the most comprehensive source of high quality training on the web, and all at an unbelievable low price.

Learn even the most complex applications without having to read a manual or attend expensive classroom type training, learn when it’s convenient to you.

New titles are added each month, and as a member you will also have unlimited access to these as well.l.

Most of the training titles also have exercise files, these are included at no extra charge.

On completion of each course users can obtain a certification to verify the training.

Free Training Newsletter

Sign up for our free newsletter and get updated on when new titles are realised, and or when special offers are available
Your details are secure we never traded, sell or otherwise exchange your data with any third parties.

Best Selling Titles - Groups:

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