Easy to follow Microsoft SQL Server 2000 Programming Tutorial Videos and online training courses. These professionally created videos offer the user an accelerated way to master this application from the comfort of their own desktop. In addition to the Microsoft SQL Server 2000 Programming tutorials we also list over 600 additional titles amounting to over 4000 hours, get unlimited access to all these courses for just $30 per month.

Microsoft SQL Server 2000 Programming Tutorial Video - Try for FREE

We Have A Later Version Available
Microsoft SQL Server 2008 Tutorial Videos

Unlimited Professional Video Training on over 600+ applications and programming languages for only $30.

The fastest and most cost effective way to learn!
Forget boring books! No need for expensive classroom training.

Easy to follow tutorial videos that play right from your own computer. Login from home or office -- the choice is yours. All tutorials are taught by world-leading experts, giving you unlimited access to over 600 different subjects for an amazing low price!

Benefits of Online Learning

Unlimited viewing. No Hidden Costs
Downloadable working files.
Instant Access
Expert instructors.
Use at home / work or both.
Works on PC or Mac.
Telephone Tech support.
Cancel at any time.
600+ courses for 1 low fee.
New titles added monthly.
100% Guaranteed

Your are currently in Demo Mode
You are in Demo mode which only allows access to the first 3 chapters of this Microsoft SQL Server 2000 Programming training course and all the other titles listed on this site, this is to help you evaluate the quality of the training before joining.

If you decide to join, you will instantly have totally UNLIMITED ACCESS to over 600 professionally created video tutorials, you will be able to access the content from any location, no restrictions are placed on the amount of content you can watch, and you can also cancel at any time you wish.
Over 4000 hours of training for just $30.00.

Get Instant Access to this Training Title and over 600 other video tutorials for just $30
Once a member you will have instant unrestricted access to this and every other title listed on this site. That’s an Amazing 6000+ hours worth of high quality video training for just $30.00 a month.

Try a Free demo, Click on any of the links below

Topics covered on this tutorial video include:

SQL Server Overview

Course Description

Course Description

Logical Data Modeling

Creating a Database

Creating a Database
Database Parameters
Data File Placement
Creating Tables
Data Types Explained
Data Types Used
NULLS
Altering Tables
Generating Values
Generating Scripts

Data Integrity

Types of Data Integrity
Enforcing Data Integrity
Primary Key
Foreign Key
Unique Constraints
Check Constraints
Default Constraints
Disabling Constraints
Cascading Referential Integrity

Using Transact SQL

Query Analyzer
Transact SQL Elements
Language Elements
Functions
Controlling Logic Flow
Commenting TSQL
Batches
Transactions
Scripts
XML (Brief XML tutorial)

Transact SQL Specifics

SELECT
Grouping Data with SELECT
Summarizing Data with SELECT
INSERT
UPDATE
DELETE
XML (XML in query)

Data Import/Export

Importing and Exporting Data
Data Import/Export Methods
Using DTS

Heterogenous Data

Distributed Queries
Linked Servers
OPENQUERY
OPENROWSET/OPENXML

Stored Procedures

What Is a Stored Procedure?
Creating and Executing Stored Procedures
Altering and Dropping Stored Procedures
Input Parameters
Returning Values with Output Parameters
Recompiling Stored Procedures
Error Handling
Permissions Required
Guidelines for Stored Procedures

User Defined Functions

What is a UDF?
Creating a UDF
UDF Guidelines
Scalar UDF
Multi-Statement UDF
InLine UDF

Triggers

What is a Trigger?
When to Use Triggers/Considerations
Creating a Trigger
Under the Hood
Nesting Triggers

Views

What is a View?
Creating and Using a View
Advantages of Views

Indexes

Index Basics
Indexes in SQL Server 2000
Guidelines for Indexing
Selectivity
Creating an Index
Index Options
Maintaining Indexes
Rebuilding Indexes
Statistics
Index Tuning Wizard
Graphical Query Plan

Query Optimizer

Query Optimizer
Cost Limit
Viewing STATISTICS
Graphical Execution
General Query Guidelines

SQL Profiler

SQL Profiler
Using the SQL Profiler

Locking

Database Locking
Locking Levels
Lock Types
Session Locking Options
Deadlocks
Displaying Locking Info

Microsoft SQL Server 2000 Programming Video Tutorial

Title Microsoft SQL Server 2000 Programming Training Tutorial

Author Mark Long
Other Training Videos by this author

Duration 8 hours

Number of Videos 102

Only $30 a month
Unlimited Access to over 600 Titles (6000+ hours )
No Minimum Term - No Contract
Instant Access - No Restrictions

Own this Training Course on CD

Microsoft SQL Server 2000 Programming Training CD

Would you like to own this Microsoft SQL Server Training title on CD?

You may purchase it from our online store. Because we don't have to use the same level of compression on the CDs as we do with the online, the audio and video playback is of a higher quality. For a single low payment you can buy this
Microsoft SQL Server tutorial on CD.

Multi User Accounts - Cost Effective Training

For Educational Establishments and Corporate Customers we have the idea way to train multi users simultaneously. Just like the single user account the Multi User option gives unlimited access to all listed courses. The cost of training multiple users is significantly reduced.

Free Certification - Prove Your Skills

After you have completed a tutorial, a Certificate of Completion can be obtained to verify that you have taken a particular course. All certificates are FREE, but the training course must be completed before a certificate can be issued.

Customer Comments

I like the idea that you put out the first few chapters for free. I've almost went through all the free ones for Photoshop, I was that impressed I purchased 4 of your titles straight off, when they arrived I was even more impressed with the quality. You guys take the uncertainty out of buying software training.
William Beale
Leicestershire ? UK