|
This Transact SQL tutorial is instructed by a Microsoft certified Systems
Engineer and Database administrator . 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 core Exam 70-229. It will also help you become a better Database
Administrator and designer. It 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 Microsoft Enterprise
Manager. He then goes into great depth explaining the four main commands:
SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes,
variables, and stored procedures. He even touches on XML. To find out
more on this complex program view the free movies below, all out online
training courses and this Transact SQL tutorial are sold to some of the
worlds leading companies, try for free below you buy. Microsoft added
a host of new features to its SQL Server 2000 product, and one of the
most interesting is the user-defined function. Adding functions to the
language has solved many code reuse issues and provided greater flexibility
when programming queries.
The links below are free
Microsoft Transact SQL tutorials. The entire contents may be purchased
either on CD or watched via the Online University
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
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
|
