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 Admin Tutorial Video

(Tutor: Mark Long, Number of Videos : 70, Training Duration: 6 hours)
Level: Beginner - Advanced
Version: Microsoft SQL Server 2008

This Microsoft SQL Server Tutorial Video will show you how to install, manage, and monitor a database system based on this impressive platform. As one of the top three database products on the market, SQL Server is an important part of current standards in I.T. and is practically required learning for any serious database administrator. The benefit of the training is that it helps you learn how SQL operates on a fundamental level, how it thinks. This allows you to be more confident and effective with more advanced tasks later on. At the same time, the tutorial emphasizes best practices and also touches on many common mistakes less experienced users tend to make. Some of the subjects addressed in this course include SQL Server Authentication Modes, Maintaining SQL Server, Optimizing Performance Using Filegroups, Utilizing Tools, Database Mirroring and more.

Microsoft ASP.NET 3.5 Tutorial Video

(Tutor: Mark Long, Number of Videos : 69, Training Duration: 6 hours)
Level: Beginner - Intermediate
Version: MS ASP.NET 3.5

This Microsoft ASP.NET 3.5 Tutorial Video brings programmers and designers into the almost limitless world of internet-based application development. While the course does not focus solely on database development, it includes extensive discussion of incorporating SQL Server into application solutions. The course is taught by Microsoft certified trainer Mark Long, and he discusses ASP.NET Controls, Validation, State Management, Using a SQL State Server, Using a SQL Server Session State Store, Using GridView and more. See the product page for a complete list of included lessons included on this APS.NET training video.

Microsoft SQL Reporting Services Tutorial Video

(Tutor: Mark Long, Number of Videos : 72, Training Duration: 7 hours)
Level: Intermediate - Advanced
Version: Microsoft SQL Server 2008

Because MS SQL Server is such a complex platform, different aspects of the system are best handled one by one. This entire Microsoft SQL tutorial video is dedicated to Database Reporting Services, one of the most useful aspects of this server-side database platform. By providing administrators with a built-in way to create extensive real-time reports on database information, Reporting Services gives almost instant access to gigabytes or even terabytes of data. Whether the reports are being delivered to manage inventory, inform clients and colleagues, or produce relevant sales information this training course can help you utilize this platform to its fullest potential. Topics covered on this training video include Reporting Services 2008 versions, Installation, Producing Basic Reports, Developing Enhanced Reports, Parameters, Deployment, Security and more.

Microsoft SQL Server 2005 Admin Tutorial Video

(Tutor: Mark Long, Number of Videos : 92, Training Duration: 7 hours)
Level: Beginner - Advanced
Version: Microsoft SQL Server 2005

In this MS SQL Server 2005 tutorial video, certified trainer Mark Long explores the possibilities of this edition of the enterprise database solution. While SQL Server 2005 is not the latest release, it is still in wide usage by a number of small and large companies, so this video series is still widely relevant. This SQL Training Video is designed specifically to offer an overview of SQL 2005, introduce basic features and functionalities, and then take users through more advanced concepts and techniques that can really make a difference in day to day operations. Topics covered include SQL Server Installation and Configuration, Object Explorer and Administrative Tools, SQL Server Security, Creating and Modifying Databases, Transaction Logs, Backups, Maintenance Concepts and more.

Microsoft Transact SQL Tutorial Video

(Tutor: Mark Long, Number of Videos : 101, Training Duration: 8 hours)
Level: Intermediate - Advanced
Version: MS Transact SQL

This Microsoft Transact SQL tutorial video introduces programmers and power users to this effective programming and query language used to access data, update data and manage databases. Intended for database administrators seeking their MCDBA credential as well as those wanting to sharpen their skill set, these lessons will first provide an introduction to TSQL, including history, language basics and functional capabilities. Once the fundamentals are covered, trainer Mark Long helps you put your conceptual understanding into action, walking you through real examples with practical application in the workplace. Topics addressed in the instructional series include SQL Terminology, General Database Information, Relevant Software Tools, Creating Tables and Constraints, Stored Procedures, Variables, Functions, XML and more.

Microsoft SQL Server 2000 Programming Tutorial Video

(Tutor: Mark Long, Number of Videos : 102, Training Duration: 8 hours)
Level: Intermediate - Advanced
Version: Microsoft SQL Server 2000

This unique SQL Server 2000 programming tutorial video emphasizes both exam preparation for Microsoft database certification and real world skills for those wanting to become more familiar with programming MS SQL Server 2000. Because these lessons deal with an older version of SQL, it is recommended primarily for users of older systems, although in many cases the principles remain the same for newer editions. By giving you a solid understanding of how SQL can be best utilized, this tutorial encourages you to improve you skills and design more effective databases for a variety of environments.

Microsoft SQL Server 2000 Admin Tutorial Video
(Tutor: Mark Long, Number of Videos : 154, Training Duration: 10 hours)
Level: Intermediate - Advanced
Version: Microsoft SQL Server 2000

This SQL Server 2000 Administration tutorial video offers essential tips and techniques that every administrator should know for maintaining systems based on Microsoft's robust database standard. While this training video covers an older edition of the software, it is still useful for those running legacy systems. Microsoft certified trainer Mark Long covers an extensive number of topics, from basic terminology and principles to security tips, data storage information, performing backup and restoration functions, monitoring SQL Server, and more. Free demo videos and a full list of contents can be found at the product page.