Improve job skills - Become more efficient - Produce better results !

Learn Microsoft SQL Server 2000 Database Programming (in only 8 hours)

Watch these professional training videos at your convenience. All you need is a computer or mobile device with an Internet connection. Login to learn anytime and view the videos as many times as you want.

Course Description: Virtual Training Company’s Microsoft SQL Server 2000 Database Programming tutorial is the perfect tool for learning how to use SQL Server 2000 in the real world. Mark Long, a Microsoft certified instructor, begins the course be introducing you to SQL Server 2000 and some of the new features, including data transformation service enhancements, failover clustering improvements, and XML support. The course is based on the criteria needed for the Microsoft Certification Exam 70-229, a necessary exam to achieve MCDBA certification. You will learn about data integrity, including primary and foreign keys and constraints, using Transact SQL to retrieve and modify data, how to import and export data, and how to link servers together. Then move on to programming business logic and topics such as creating, executing and altering stored procedures. Mark Long finishes the course by teaching you how to optimize access to your data with indexes, query optimizer, and SQL profiler. To start learning right away, click on one of the video tutorials below.


Click a play button below to view a free training video. Place your order online for full access.

 

Video Tutorials Included: 100 Free Video Video Time
(minutes)

SQL Server Overview

Course Description

Logical Data Modeling

Creating a Database

Data Integrity

Using Transact SQL

Transact SQL Specifics

Data Import/Export

Heterogenous Data

Stored Procedures

User Defined Functions

Triggers

Views

Indexes

Query Optimizer

SQL Profiler

Locking