Virtual Training CompanyOtilde;s Transact SQL tutorial is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification, particularly Exam #70-229. It will also help you become a better Database Administrator. Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures. He even touches on XML. To get started, simply click on one of the movie links below.
Course IntroWelcome/IntroWhat Is Transact SQL?A Few Words About TSQLHistory of DatabasesHistory of SQLWhat Flavor Would You Like?SQL Terminology/AcronymsCourse OverviewCourse Overview && DescriptionGeneral Database InformationWhat Is A Database?Two Main Types of DatabasesNormalizationDenormalizationDatabase RelationshipsDatabase Design ConcernsLanguage BasicsSQL 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 ToolsQuery Analyzer Pt. 1
Query Analyzer Pt. 2
Enterprise Manager
QA vs. EM
ISQL / OSQL
ISQL / OSQL Examples
Notepad
Third Party Apps
More Than A Query LanguageCreating Databases
A Word About NULLS
Creating Tables
Creating Constraints
Creating Defaults
Creating Relationships
SELECTBasic 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
INSERTBasic INSERT Syntax
Using INSERT
Advanced INSERT
UPDATEBasic UPDATE Syntax
Using UPDATE
Advanced UPDATE
DELETEBasic DELETE Syntax
Using DELETE
DELETE or TRUNCATE TABLE?
IndexesWhat Is An Index?
Types Of Indexes
Determining Indexes(Guidelines)
Creating Indexes
ViewsWhat Is A View?
Creating Views
Advantages of Views
System TablesOverview of System Tables
Querying System Tables
VariablesOverview Of Variables
Declaring Variables
Using Variables
Variables As Object Names
System Variables
Stored ProceduresWhat Is A Stored Procedure?
Creating A Stored Procedure
Using Input Variables
Using Output Variables
Extended Stored Procedures
CursorsWhat Are Cursors?
FunctionsWhat Are Functions?
Partial List Of Functions
User Defined Functions
Scalar UDF
Multi-Statement UDF
InLine UDF
TriggersWhat Are Triggers?
Creating A Trigger
How Triggers Work
Nesting && Recursive Triggers
XMLWhat Is XML?
FOR XML
Misc XML Info
Optimizing Your TSQLLimiting Results
Utilizing Indexes
Graphical Exec Plan/Profiler
Click here to find out more about the Microsoft Transact SQL Training CD 
