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. 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
Associated Tutorials: MCDST Certification Training Video | Microsoft SQL Reporting Services | Crystal Reports Tutorial | Microsoft Visual Basic 2008 | Microsoft SQL Server 2008 Admin | Microsoft SQL Server 2008 Development | Microsoft LINQ Tutorial
Microsoft Transact SQL Tutorial CD / DVD
When you order this Microsoft Transact SQL Video Tutorial CD You'll Receive...
Over 8 hours of high quality video-based training that walks you through
the program in easy to follow stages.
A training video that focuses on real life examples and teaches you
real life skills. These tutorials are
structured to increase not only your skills but also your earning potential.
With this Training Video you will...
Learn Microsoft Transact SQL from a leading expert and quickly master
the skills required to work in a commercial environment.
Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike
Customer Comments
" The network and database in our small marketing firm was a mess! After getting it under control with some of your tutorials, we're looking at getting some of the Adobe training titles next. "Amanda Larson, West Virginia
Microsoft Transact SQL Tutorial CD / DVD
Create the best self-paced learning environment right on your own desktop.Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course
- 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

- What Is A Database?

- Two Main Types of Databases

- Normalization

- Denormalization

- Database Relationships

- Database Design Concerns

- 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
- Query Analyzer Lesson 1
- Query Analyzer Lesson 2
- Enterprise Manager
- QA vs. EM
- ISQL / OSQL
- ISQL / OSQL Examples
- Notepad
- Third Party Apps
- Creating Databases
- A Word About NULLS
- Creating Tables
- Creating Constraints
- Creating Defaults
- Creating Relationships
- 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
- Basic INSERT Syntax
- Using INSERT
- Advanced INSERT
- Basic UPDATE Syntax
- Using UPDATE
- Advanced UPDATE
- Basic DELETE Syntax
- Using DELETE
- DELETE or TRUNCATE TABLE?
- What Is An Index?
- Types Of Indexes
- Determining Indexes(Guidelines)
- Creating Indexes
- What Is A View?
- Creating Views
- Advantages of Views
- Overview of System Tables
- Querying System Tables
- Overview Of Variables
- Declaring Variables
- Using Variables
- Variables As Object Names
- System Variables
- What Is A Stored Procedure?
- Creating A Stored Procedure
- Using Input Variables
- Using Output Variables
- Extended Stored Procedures
- What Are Cursors?
- What Are Functions?
- Partial List Of Functions
- User Defined Functions
- Scalar UDF
- Multi-Statement UDF
- InLine UDF
- What Are Triggers?
- Creating A Trigger
- How Triggers Work
- Nesting & Recursive Triggers
- What Is XML?
- FOR XML
- Misc XML Info
- 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 |
| Compatibility | Vista, XP, Windows 7, Mac OSX |
| Released | 2002 |
| Availability | Immediate Dispatch |
| Price US / Canadian Sales | Only $99.95
|
| Closed Captions | Closed Captions are not Enabled on this title |
Mutli User Training Options
This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.
Not Sure Which Titles to Buy? Unlimited Access to all -$30
Unlimited Access to over 70,000+ Training Videos
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.
No contract .
No minimum
period.
No commitment on your part.
Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.
Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits
Why Is This Training Format So Effective?
- Learn Microsoft Transact SQL from an accredited expert in days.
Related Training Videos
Oracle PL/SQL | Microsoft SQL Server Admin Tutorials | Microsoft SQL Server Programming| Online Microsoft Transact SQL Training Courses
Prove your Knowledge - Free Certificate
Prove Your Credentials!
Free Certificate.



