Find a Course...Try for FREE

Microsoft Transact SQL Training Information
Author: Mark Long
Duration: 8 hrs
Video Lessons: 110
Click here to sign up to the Online University
Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9


Training Categories
    Graphics & Page Layout
    Internet & Web Design
    Animation & 3D
    Multi Media & Video
    Business
    Certification
    Operating Systems
    Databases
    Programming
    Music & Audio
    Tutorials Coming Soon

Microsoft Transact SQL Training - FREE Tutorials

FREE Microsoft Transact SQL Training
Learn Microsoft Transact SQL in the shortest time possible, start now with the linked tutorials below:   (Please allow a few seconds to load)
To ensure the FREE tutorials below run smoothly, please view our short checklist - CLICK HERE

Course Intro
 Welcome/Intro
 What Is Transact SQL?
 A Few Words About TSQL
 History of Databases
 History of SQL
 What Flavor Would You Like?
 SQL Terminology/Acronyms

Course Overview
 Course Overview & Description

General Database Information
 What Is A Database?
 Two Main Types of Databases
 Normalization
 Denormalization
 Database Relationships
 Database Design Concerns

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON CD


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

CLICK HERE TO BUY THIS TUTORIAL ON CD




Sign up to the Online University and view over 400 titles for only $30/£15 per month
BENEFITS:
  1 Minimum Sign Up: ONLY ONE MONTH! - Cancel at any Time
  2 Unlimited Viewing
  3 Downloadable Working Files
  4 Learn from Expert Authors
  5 View on any Computer in the World
  6 Works on PC and Mac
  7 Full Support Offered
  8 450+ Courses for a Low Monthly Fee
  9 New Titles Added Weekly
  10 A Truely Professional Study Guide

Click here to sign up to the Online University

CLICK HERE TO BUY THIS TUTORIAL ON CD

Multi user options available for large organistions and education
CLICK Here for further info

Free Certificates available when each course has been completed


RECENTLY ADDED TUTORIALS
  ADOBE INDESIGN CS3
  ADOBE PHOTOSHOP CS3
  ADREAMWEAVER CS3
  APPLE FINAL CUT PRO 6
  MAYA 8.5 FOR BEGINNERS
  POSER 7
  AUTOCAD 2007
  MS PROJECT 2007
  ADOBE ILLUSTRATOR CS3
  MICROSOFT ACCESS 2007
  MICROSOFT VISTA
  ADOBE FLASH CS3
  AUTOCAD 2009