|
Microsoft Transact SQL Tutorials Online |
![]() |
|
Description
Microsoft Transact SQL
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. |
01 Course Intro
0101 Welcome/Intro
0102 What Is Transact SQL?
0103 A Few Words About TSQL
0104 History of Databases
0105 History of SQL
0106 What Flavor Would You Like?
0107 SQL Terminology/Acronyms
02 Course Overview
0201 Course Overview & Description
03 General Database Information
0301 What Is A Database?
0302 Two Main Types of Databases
0303 Normalization
0304 Denormalization
0305 Database Relationships
0306 Database Design Concerns
04 Language Basics
0401 SQL Statement Types
0402 Transact SQL Elements
0403 Data Types Overview
0404 SQL 2000 Data Types
0405 Wildcards & Escape Characters
0406 Logic Flow
0407 Scripts
0408 Batches
0409 Transactions
0410 Functions
0411 Stored Procedures
0412 Views
0413 Triggers
0414 Debugging
05 Transact SQL Tools
0501 Query Analyzer Pt. 1
0502 Query Analyzer Pt. 2
0503 Enterprise Manager
0504 QA vs. EM
0505 ISQL / OSQL
0506 ISQL / OSQL Examples
0507 Notepad
0508 Third Party Apps
06 More Than A Query Language
0601 Creating Databases
0602 A Word About NULLS
0603 Creating Tables
0604 Creating Constraints
0605 Creating Defaults
0606 Creating Relationships
07 SELECT
0701 Basic SELECT
0702 Column Aliasing
0703 SELECT INTO Clause
0704 SELECT FROM Clause
0705 Using JOINS
0706 JOIN Examples
0707 Table Aliasing
0708 SELECT WHERE Clause
0709 Looking For NULLS
0710 SELECT GROUP BY Clause
0711 SELECT HAVING Clause
0712 SELECT ORDER BY Clause
0713 SELECT COMPUTE Clause
0714 UNION
08 INSERT
0801 Basic INSERT Syntax
0802 Using INSERT
0803 Advanced INSERT
09 UPDATE
0901 Basic UPDATE Syntax
0902 Using UPDATE
0903 Advanced UPDATE
10 DELETE
1001 Basic DELETE Syntax
1002 Using DELETE
1003 DELETE or TRUNCATE TABLE?
11 Indexes
1101 What Is An Index?
1102 Types Of Indexes
1103 Determining Indexes(Guidelines)
1104 Creating Indexes
12 Views
1201 What Is A View?
1202 Creating Views
1203 Advantages of Views
13 System Tables
1301 Overview of System Tables
1302 Querying System Tables
14 Variables
1401 Overview Of Variables
1402 Declaring Variables
1403 Using Variables
1404 Variables As Object Names
1405 System Variables
15 Stored Procedures
1501 What Is A Stored Procedure?
1502 Creating A Stored Procedure
1503 Using Input Variables
1504 Using Output Variables
1505 Extended Stored Procedures
16 Cursors
1601 What Are Cursors?
17 Functions
1701 What Are Functions?
1702 Partial List Of Functions
1703 User Defined Functions
1704 Scalar UDF
1705 Multi-Statement UDF
1706 InLine UDF
18 Triggers
1801 What Are Triggers?
1802 Creating A Trigger
1803 How Triggers Work
1804 Nesting & Recursive Triggers
19 XML
1901 What Is XML?
1902 FOR XML
1903 Misc XML Info
20 Optimizing Your TSQL
2001 Limiting Results
2002 Utilizing Indexes
2003 Graphical Exec Plan/Profiler
21 Credits
2101 About the Author
sku |
|
