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 movie topics below.
Creating and Executing Stored Procedures
Altering and Dropping Stored Procedures
Returning Values with Output Parameters
Guidelines for Stored Procedures
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.