Microsoft Transact SQL Tutorials
Online Contents For This Title
We have made some of the video tutorials for Microsoft Transact SQL freely available to help you evaluate our training.
Click on any of the linked lesson listings below to preview FREE!
Title Description
Virtual Training CompanyŐ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.
Choose your media type:
|
Course Intro
|
||
| Welcome/Intro | (03:05) | |
| What Is Transact SQL? | (06:34) | |
| A Few Words About TSQL | (05:27) | |
| History of Databases | (05:39) | |
| History of SQL | (05:06) | |
| What Flavor Would You Like? | (02:57) | |
| SQL Terminology/Acronyms | (04:54) | |
|
Course Overview
|
||
| Course Overview & Description | (05:43) | |
|
General Database Information
|
||
| What Is A Database? | (05:09) | |
| Two Main Types of Databases | (05:01) | |
| Normalization | (06:35) | |
| Denormalization | (04:07) | |
| Database Relationships | (04:45) | |
| Database Design Concerns | (04:29) | |
|
Language Basics
|
||
| SQL Statement Types | (03:18) | |
| Transact SQL Elements | (05:09) | |
| Data Types Overview | (04:11) | |
| SQL 2000 Data Types | (07:17) | |
| Wildcards & Escape Characters | (05:11) | |
| Logic Flow | (05:43) | |
| Scripts | (04:44) | |
| Batches | (05:27) | |
| Transactions | (05:07) | |
| Functions | (04:28) | |
| Stored Procedures | (04:52) | |
| Views | (03:25) | |
| Triggers | (03:57) | |
| Debugging | (03:19) | |
|
Transact SQL Tools
|
||
| Query Analyzer Pt. 1 | (05:16) | |
| Query Analyzer Pt. 2 | (04:54) | |
| Enterprise Manager | (05:21) | |
| QA vs. EM | (05:46) | |
| ISQL / OSQL | (03:19) | |
| ISQL / OSQL Examples | (06:10) | |
| Notepad | (02:41) | |
| Third Party Apps | (02:21) | |
|
More Than A Query Language
|
||
| Creating Databases | (06:15) | |
| A Word About NULLS | (04:17) | |
| Creating Tables | (04:01) | |
| Creating Constraints | (05:40) | |
| Creating Defaults | (04:25) | |
| Creating Relationships | (04:12) | |
|
SELECT
|
||
| Basic SELECT | (04:12) | |
| Column Aliasing | (04:52) | |
| SELECT INTO Clause | (04:12) | |
| SELECT FROM Clause | (01:55) | |
| Using JOINS | (05:46) | |
| JOIN Examples | (06:33) | |
| Table Aliasing | (03:46) | |
| SELECT WHERE Clause | (04:11) | |
| Looking For NULLS | (04:43) | |
| SELECT GROUP BY Clause | (05:11) | |
| SELECT HAVING Clause | (02:59) | |
| SELECT ORDER BY Clause | (03:59) | |
| SELECT COMPUTE Clause | (04:01) | |
| UNION | (04:03) | |
|
INSERT
|
||
| Basic INSERT Syntax | (05:24) | |
| Using INSERT | (05:00) | |
| Advanced INSERT | (03:26) | |
|
UPDATE
|
||
| Basic UPDATE Syntax | (02:02) | |
| Using UPDATE | (03:19) | |
| Advanced UPDATE | (03:21) | |
|
DELETE
|
||
| Basic DELETE Syntax | (01:51) | |
| Using DELETE | (03:29) | |
| DELETE or TRUNCATE TABLE? | (02:55) | |
|
Indexes
|
||
| What Is An Index? | (05:57) | |
| Types Of Indexes | (03:01) | |
| Determining Indexes(Guidelines) | (03:20) | |
| Creating Indexes | (05:37) | |
|
Views
|
||
| What Is A View? | (02:32) | |
| Creating Views | (04:54) | |
| Advantages of Views | (02:31) | |
|
System Tables
|
||
| Overview of System Tables | (04:22) | |
| Querying System Tables | (05:28) | |
|
Variables
|
||
| Overview Of Variables | (02:57) | |
| Declaring Variables | (03:55) | |
| Using Variables | (06:13) | |
| Variables As Object Names | (04:05) | |
| System Variables | (03:18) | |
|
Stored Procedures
|
||
| What Is A Stored Procedure? | (04:03) | |
| Creating A Stored Procedure | (05:09) | |
| Using Input Variables | (04:56) | |
| Using Output Variables | (04:22) | |
| Extended Stored Procedures | (04:48) | |
|
Cursors
|
||
| What Are Cursors? | (04:13) | |
|
Functions
|
||
| What Are Functions? | (02:32) | |
| Partial List Of Functions | (02:29) | |
| User Defined Functions | (01:24) | |
| Scalar UDF | (04:09) | |
| Multi-Statement UDF | (04:12) | |
| InLine UDF | (02:32) | |
|
Triggers
|
||
| What Are Triggers? | (03:46) | |
| Creating A Trigger | (03:11) | |
| How Triggers Work | (03:44) | |
| Nesting & Recursive Triggers | (03:04) | |
|
XML
|
||
| What Is XML? | (03:01) | |
| FOR XML | (05:31) | |
| Misc XML Info | (02:23) | |
|
Optimizing Your TSQL
|
||
| Limiting Results | (02:31) | |
| Utilizing Indexes | (02:28) | |
| Graphical Exec Plan/Profiler | (05:06) | |
|
Credits
|
||
| About the Author | (02:09) | |
This title is just part of the entire VTC collection of over 625 courses, 66,000 video tutorials (12,500+ free), available to you for just $30 a month.
Tutorial Information
| Title: | Microsoft Transact SQL |
| Author: | Mark Long |
| SKU: | 33380 |
| ISBN: | 193207208x |
| Release Date: | 2002-10-15 |
| Duration: | 7.5 hrs / 102 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
Subscription / Purchase Information
This title is just part of the entire VTC collection of over 625 courses, 65,000 video tutorials (12,500+ free), available to you for just $30 a month.
Select Bandwidth
Now Shipping
Client Testimonials
Hi there! Now completed the MySQL course. Congratulations to Joshua Mustafa for a job well done. Many thanks to you too.
Martin C McDermott
United States
View All Titles 
Email this Page
Send us Feedback
Purchase/Add to Cart