Microsoft SQL Server 2000 Admin VTC Training CD

by Mark Long

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 and to help you prepare for the Microsoft Certification Exam 70-229, a necessary exam to achieve MCDBA certification. Mark Long, a Microsoft certified instructor, begins the course be introducing you to SQL Server 2000 and some of the new features you will find, including data transformation service enhancements, failover clustering improvements, and XML support. The course is based on the criteria needed for the Microsoft exam, and he takes you step by step over the material you must know, including creating a database and tables. 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. Once you have that down, move onto 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. Virtual Training Company makes learning the most challenging software easier. Open the program you want to learn. Open your VTC training CD. A friendly expert takes you smoothly from the basics of the program through every single feature. It's simple to apply what your learning as you go. Need help in the middle of a project? You can quickly search the subject, and within seconds an expert is showing exactly what you need to know. VTC makes it possible for you to become an expert in far less time, at a much lower cost, than any other form of training. VTC...The Tutor in Your Computer!

Audio CD