Self Study, Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. It works on both PC and Mac.
These Microsoft Transact SQL tutorials are an ideal way for system and database administrators to gain a solid working knowledge of not only the data definition, manipulation, and the language syntax but you will also be better prepared for the MCDBA certification exam 70 – 229. By the conclusion of this training CD users will have a strong understanding of all the TSQL tools, the Query Analyzer and also the Enterprise Manager .
Microsoft Transact SQL Tutorial CD / DVD
Create the best self-paced learning environmentright on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.
Learn for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

- Professional Tuition from an Expert
- Free Certificate with Each Tutorial
- Works on PC or Mac

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
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 Pt. 1
- Query Analyzer Pt. 2
- Enterprise Manager
- QA vs. EM
- ISQL / OSQL
- ISQL / OSQL Examples
- Notepad
- Third Party Apps
More Than A Query Language
- Creating 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
About this Microsoft Transact SQL Training CD
| Title : | Microsoft Transact SQL |
|---|---|
| Tutor : | Mark Long
Other tutorials by Mark Long |
| Videos : | 101 Lessons- Video run time: 8 Hours |
| Availability : | Immediate Dispatch |
| Compatibility: | Vista, 2000, XP, Windows 7, Mac OS, OSX |
| Released | 2002 |
| Price US / Canadian Sales | $99.95 |
960 In Stock

- Learn Microsoft Transact SQL from an accredited expert in days.
- Ideal for beginners, these easy to follow videos offer visual clarity.
- Master a full application for a fraction of the cost of classroom based training, and faster than with a manual.
- Unique teaching method that offers accelerated learning and high retention.
- Used by many large companies, schools, universities,
click to see some of our customers. - Learn from your own desk at a speed that suits you.
- It's Cost effective tuition from leading expert tutors.
- Learn at your own pace; training can be stopped, rewound or fast forwarded as required.
- These High Quality Tutorial Videos are on CD / DVD or Online and PC / Mac Compatible. It's Simply the best tuition at an affordable price
Want to hear what our customers say about our products?
Microsoft SQL Server 2005 | MCDST Certification | Microsoft SQL Reporting Services | Crystal Reports | Linux Professional LPIC | Microsoft Excel 2007 Tutorial | Microsoft Visual Basic 2008
Not sure which training CD titles to purchase? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.
You can have access to every title we list on this site for just $30 per month. When you sign up, you get instant access with absolutely no restrictions or limits. Log on from any location and learn as much as you like.



