Microsoft SQL Server Tutorial Video - Training CD

SQL Server 2005 Tutorial Video - Admin
(Tutor: Mark Long/Certfied Microsoft Instructor ,
Number of videos :92, Training Duration: 7 hours)

These Microsoft SQL Server tutorials are related to version 2005 and cover in great depth this application from the point of the database administrator. Aimed towards the beginner author Mark Long starts off by covering the fundamentals of the SQL Server before moving on to cover more advanced aspects of the Microsoft 2005 SQL Server. Topics covered include : Installing SQL Server, Administrative Tools, SQL Sever Security, Creating Databases, Transaction Logs, Data Storage, Database Backup, Restoring Data plus a lot more, for more information and a free demo follow the link above.

SQL Server 2000 Admin Tutorial Video
(Tutor: Mark Long/Certfied Instructor , Number of videos : 154, Training Duration: 10 hours)
This Microsoft SQL Server 2000 Admin tutorial is just what you need to learn how to administer SQL Server in a real environment,  and will also  help you prepare for the Microsoft Certification Exam 70-228. Author Mark Long, is  a Microsoft certified instructor, he starts this training course off with the fundamental aspects such as: installation and building and backing up databases and offers valuable information about databases and administrative responsibilities, he then moves onto the specifics of the administration of the SQL Server 2000, such as: installation, data storage, and file groups. This SQL tutorial videos also cover  the two main administrative tools, enterprise manager and query analyzer using real-life examples.

SQL Server 2000 Programming Tutorial
(Tutor: Mark Long/Certfied Instructor , Number of Videos : 102, Training Duration: 8 hours)

This Microsoft SQL Server 2000 Database Programming video 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 which  is necessary to achieve MCDBA certification. Authored by Mark Long a Microsoft certified instructor, these video tutorials begin by introducing you to the fundamentals of SQL Server 2000 including data transformation service enhancements, failover clustering improvements, and XML support. The training course also covers : data integrity, ‘ primary and foreign keys, constraints, using Transact SQL to retrieve and modify data, importing and exporting data, and server linking. This tutorial then concludes with lessons on the optimization of your data using indexes, query optimizer and the SQL Profiler

Microsoft Transact SQL Tutorial
(Tutor: Mark Long/Certfied Microsoft Instructor , Number of Videos : 101, Training Duration: 7.5 hours)

This Transact SQL tutorial video is instructed by Microsoft certified Systems Engineer and Database administrator Mark Long. In this tutorial, you will not only learn about this data definition, manipulation, and control language, but you will also become better prepared for the MCDBA certification, particularly Exam #70-229. It will also help you become a better Database Administrator. Mark Long begins by introducing you to the origins and capabilities of Transact SQL. He will give a brief history of databases and will cover some language basics, including scripts, batches, functions, and views. From there, he moves onto more advanced ideas by teaching you about TSQL tools, such as the Query Analyzer and the Enterprise Manager. He then goes into great depth explaining the 4 main commands: SELECT, INSERT, UPDATE, and DELETE. You will also learn about indexes, variables, and stored procedures. This training CD even touches on XML.