Easy to follow Microsoft SQL Server 2000 Programming Tutorials 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 400 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 Try for FREE

Discounted Training Courses

Members of the VTC Online University have unlimited access to this tutorial. At the moment, you are in demo mode and only the first 3 chapters will play. But members have access to EVERY SINGLE TITLE IN OUR RANGE, i.e., over 40,000 tutorials on 400+ titles all with expert tutors. Where else can you get high quality one to one training for just $30.00 per month!

Benefits

:
  1. 01. Unlimited viewing.
  2. 02. Downloadable working files.
  3. 03. Expert instructors.
  4. 04. Use at home / work or both.
  5. 05. Works on PC or Mac.
  6. 06. Telephone Tech support.
  7. 07. Cancel at any time.
  8. 08. 300+ courses for 1 low fee.
  9. 09. New titles added regularly.
  10. 10. 100% Guaranteed

Should you need any help, just call - contact details at the bottom of the page.

Click to Join Now
Click here to Join

Unlimited Professional Training on over 400+ 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 - just easy to follow training videos that play right from your own computer. Login from home or office - the choice is yours. All courses are taught by world leading experts, unlimited access, on over 400 different subjects.
Please Note:
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 400 professionally created video tutorials, you will be able to access the content from any location and no restrictions are placed on the amount of content you can watch, you can also cancel at any time you wish. Over 4000 hours of training for just $30.00.

Topics covered on this course include:
SQL Server Overview
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 Course Details

Microsoft SQL Server 2000 Programming Training Course
Author: Mark Long
Other Training by author
Duration: 8 Hours
No. of movies 102

Benefits:
Join the VTC Online University and you will have UNLIMITED access to this tutorial and all the others in the entire library for just US $30 a month. That's over 4000 hours worth of high quality training for one low price of less than $1 a day. Click here to Join

Click to Join Now

Own this Training Course on CD

cd If you would 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.

Free Certification - Prove your Skills

certificate 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.

Customers Comments

'One of the MOST EFFECTIVE training tools out on the market today, BAR NONE!!!!!!'
Robert McClain
Kansas City, KS ;

Easy to Use QuickTime Format

QuickTime 119 In order to view the training, you must have the latest version of QuickTime installed. Please note that the online movies have been compressed for quicker downloads, CDs and DVDs have far higher audio and video quality.