Microsoft SQL Server 2008 Development Tutorial Video

(Tutor: Mark Long, Number of Videos : 69, Training Duration: 6 hours)
Level: Intermediate-Advanced
Version: MS SQL Server 2008

This Microsoft SQL Server 2008 Development Tutorial Video series will help users learn to work with this powerful database platform to create solutions that benefit the needs of IT infrastructure as well as the end user. This multi-part course begins with an overview of basic SQL setup tasks and principles to benefit those using the program for the first time, but then advances to more hands-on topics pertinent to good database design and development. Taught by Microsoft certified tutor Mark Long, the training course blends expert advice with practical examples that make learning complex concepts significantly easier. Topics addressed in the SQL Development tutorial video include SQL Server Components, Normalization, Systematic Database Design, Tables and Views, Joining Tables, Managing Transactions and more.

Microsoft SQL Server 2008 Administration Tutorial Video
(Tutor: Mark Long, Number of Videos : 70, Training Duration: 6 hours)
Level: Intermediate-Advanced
Version: MS SQL Server 2008

This Microsoft SQL Server 2008 tutorial video focuses on the concepts and skills necessary to build, maintain, and optimize data systems using the latest version of this robust and flexible software. Because unique database solutions are required for different purposes and demands, the course focuses on administrative tasks that users are likely to encounter in all standard scenarios. Guided by certified Microsoft trainer Mark Long, users receive hands-on guidance on installing, configuring and working with the administrative controls of Microsoft SQL Server 2008, specifically learning topics such as Changing Authentication Modes, Creating Service Accounts, Using the Activity Monitor, Moving Data Files, Creating a Schema, Using Backup Devices, Optimizing Performance and more. Thevideo tutorial is designed so that the lessons can be watched in order or used as a reference for specific user needs.

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.