Compatibility: Win Vista, XP, 2000, 98, NT, Mac OS X, OS 9
Microsoft Transact SQL Training Description
• Become better prepared for the MCDBA certification and exam#70-229 with the help of these easy to follow, online Microsoft Transact SQL training tutorials.
• With the aid of highly effective video training movies, expert trainer and Database administrator, Mark Long, demonstrates all of the important tools, concepts and principles including data manipulation, definition and control language.
• This Microsoft Transact SQL tuition, has a learning retention unmatched by most other training methods as each tutorial builds upon the last, reinforcing the points made.
• Start learning right away by viewing the FREE Microsoft Transact SQL training tutorials by clicking any blue linked lesson above.
These best selling online Microsoft Transact SQL training videos are the fastest and most cost effective way to learn. Using narrated video tutorials to demonstrate key techniques and features, this easy-to-follow instruction will help you to learn rapidly and retain essential knowledge and skills. Commencing from the basics, this "for dummies" training method will help users feel at ease from the outset.
This tutoring method allows users to learn either at home or the office and on any Mac or PC with an internet connection, for as less than $1 a day!
So why not start learning now and see how millions have used this training method as an effective substitute for expensive Microsoft Transact SQL training courses or workshops, boring books and tedious PDF training manuals.
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
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.
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
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 Instruction Files/PDFs 4 Learn Microsoft Transact SQL from Expert Tutors 5 View on any Computer in the World 6 Works on PC and Mac 7 Full Support Offered 8 Easy to Follow Video Instructions - Visual Advantage Over Bulky
Microsoft Transact SQL User Guides / Help Manuals 9 550+ Online Classes- New Titles Added Weekly 10 A Truely Professional Study Guide
Learn how to work faster and smarter right now, CLICK HERE to sign up to the Online University
After a course is completed you are able to download a FREE certificate. This certifies that you have completed the training and that you now possess essential
skills and detailed knowledge of Microsoft Transact SQL
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