September 01, 2009

Course PDFs Available for SQL 2005 Video Training Courses

Over at LearnItFirst.com, the web's best training video site (in our opinion), we've just released a whole slew of companion PDFs for our SQL Server 2005 training courses:

These new SQL Server training PDFs feature a listing of every SQL Server 2005 video tutorial in each course along with a checkbox that helps you track which videos you have watched.

Posted at 04:56 PM in SQL Server, Training, Training Videos, Tutorials, Video | | TrackBack (0)

Technorati Tags: , ,

November 22, 2006

Microsoft SQL Server Video Tutorial: Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs

Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs - view details

This video, the second in our series on using Common Table Expressions (CTEs), walks you through recursion and working with hierarchies with CTEs. This video uses the Northwind database to simplify the learning process and uses some common recursive queries used in Northwind examples to highlight the basic use of the CTE.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql recursion, sql hierarchy, hierarchical query

Posted at 05:15 AM in Video | | TrackBack (0)

Exchange 2003 Video Tutorial: Phase 3, Pt. 2 - Install Service Pack and Rehome Site Replication Service

Phase 3, Pt. 2 - Install Service Pack and Rehome Site Replication Service - view details

With Exchange 2003 successfully installed, you'll want to apply to latest Service Pack and then rehome Site Replication Service. This video, part two of Phase 3, walks you through installing SP1 and the complicated task of rehoming the Site Replication Service.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: rehome, srs

Posted at 04:53 AM in Video | | TrackBack (0)

Windows 2003 Video Tutorial: Time Synchronization Using Active Directory

Time Synchronization Using Active Directory - view details

Do you want all of your Active Directory objects to use the same time? What about the same time zone? How can you synchronize the time across the domain? This video helps you understand AD Time Sync and shows you how to set it up for your networks.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: ad time sync, net time

Posted at 04:52 AM in Video | | TrackBack (0)

Microsoft SQL Server Video Tutorial: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys - view details

This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: alternate key, associative key, pk, fk, check constraint, unique constraint

Posted at 04:52 AM in Video | | TrackBack (0)

Transact SQL Video Tutorial: Part 3 - Using EXISTS to Control Execution In an IF Statement

Part 3 - Using EXISTS to Control Execution In an IF Statement - view details

EXISTS is a fundamental part of a SQL programmer's arsenal. This video, part three in our series on using control-of-execution statements, explores using IF EXISTS to drop/create objects and detect data.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: if exists

Posted at 04:52 AM in Video | | TrackBack (0)

Windows 2003 Video Tutorial: Password Management

Password Management - view details

Password policy Best Practices, account locking policies and many other tips for maintaining passwords. This should be a must for all administrators
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: password management Windows 2003

Posted at 04:52 AM in Video | | TrackBack (0)

SQL Server 2000 Video Tutorial: Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - view details

This video is mainly an architecture/sysinternals type of video designed to show you how things work "behind the scenes" with IDENTITY columns. You'll learn how SQL Server chooses the values, how you can influence those values as well as tips and tricks for using IDENTITY columns and Best Practices. IDENTITY columns (and all surrogate keys) are often easy to use but not completely understand by new users. If you use IDENTITY columns in your databases then you'll appreicate this thorough treatment of how IDENTITY columns work in SQL Server.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: IDENTITY, auto number, sequence, surrogate key, alternate key

Posted at 04:52 AM in Video | | TrackBack (0)

Microsoft SQL Server Video Tutorial: Templates in SQL Server Management Studio - What They Are and How to Use Them

Templates in SQL Server Management Studio - What They Are and How to Use Them - view details

Templates were added to SQL Server 2000's Query Anaylzer and were a very handy tool (though mostly unused). SQL Server 2005's Management Studio expands on SQL Server 2000's templates by allowing you to easily add your own templates, write templates in multiple languages (such as T-SQL, XMLA or MDX), and the easy-to-use Template Explorer.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: query template, tsql template, xmla, mdx, dmx, parameter, default value

Posted at 04:51 AM in Video | | TrackBack (0)

DTS Video Tutorial: Part 2 - A Basic Walkthrough of the Built-In Tasks

Part 2 - A Basic Walkthrough of the Built-In Tasks - view details

Part 2 - A Basic Walkthrough of the Built-In Tasks
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Part 2 - A Basic Walkthrough of the Built-In Tasks, beginner, beginning, for beginners, introduction, step by step

Posted at 04:51 AM in Video | | TrackBack (0)

»