Free SQL Server Video Tutorial: An Overview of the Northwind Database

An Overview of the Northwind Database - download

Scott Whigham walks you through the layout of the Northwind database in this video. Northwind is used for many demos and videos throughout the site due to how easy it is to work with. This is not a long video but will serve to familiarize you with the sample database used in many of the T-SQL-based videos.

NOTE: You can download the Northwind (and Pubs) sample databases from the microsoft.com website here

---

• Source: http://www.learnsqlserver.com
• Category: SQL Server Training
• Skill Level: 100 (Beginner)
• Length: 13:41 (8.36MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: sample database, sample db, install sample, oltp database, beginner, beginning, for beginners, introduction, step by step

Free Exchange Server Video Tutorial: Building Mail Universal Distribution Groups and Dynamic Distribution Groups

Building Mail Universal Distribution Groups and Dynamic Distribution Groups - download

How to Build Mail Universal Distribution Groups and Dynamic Distribution Groups

---

• Source: http://www.learnexchange.com
• Category: Exchange Server Training
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:16 (9.43MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: How to Build Mail Universal Distribution Groups and Dynamic Distribution Groups

Free Exchange Server Video Tutorial: POP3 and IMAP4 in Exchange 2003

POP3 and IMAP4 in Exchange 2003 - download

This video takes a look at the IMAP4 and the POP3 protocol configuration in Exchange System Manager (ESM) so that our Exchange server will listen for IMAP4 and POP3 requests on the internet. Grant Moyle, Exchange trainer, explains what POP3 and IMAP4 are and how they are used on the world wide web today

---

• Source: http://www.learnexchange.com
• Category: Exchange Server Training
• Skill Level: 100 (Beginner)
• Length: 14:59 (7.67MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: POP3 IMAP4 with Exchange, IMAP4 with Exchange, POP3 with Exchange, beginner, beginning, for beginners, introduction, step by ste

Free SQL Server Video Tutorial: Part 1 - How to Be a Proactive DBA: What Are Alerts?

Part 1 - How to Be a Proactive DBA: What Are Alerts? - download

Alerts in SQL server are a very important piece for the administrator to understand; especially the DBA?s who actively manage their server and want to be proactive with their management. Alerts allow you to define a response to an event or condition and in this introductory video tutorial your instructor Scott Whigham will divulge more on the world of alerts in SQL Server 2005.

Highlights from this video:

• SQL Server log
• Alert basics
• Three firing instances of an event or condition
• Operators in SQL
• How an event occurs in SQL server and RAISEERROR
• Severity levels of errors

and much more

---

• Source: http://www.learnsqlserver.com
• Category: SQL Server Training
• Skill Level: 200 (Beginner - Intermediate)
• Length: 12:00 (11.0MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance

Free Transact SQL Video Tutorial: 01 - An Introduction to Datatype Conversion

01 - An Introduction to Datatype Conversion - download

Datatype conversion is what we, as developers, have to deal with on a daily basis. No matter what the language, data type conversion is a daily event. This video helsp introduce the concept from a SQL Server-specific standpoint.

Highlights from this video:

• Overview of the various datatypes available in SQL Server
• Numbers
• Strings
• Dates
  
• Differences between various datatypes
  
• Using 'SELECT 123' statements and how SQL Server implements such queries
  
• How SQL Server performs datatype conversions in expressions

and much more

---

• Source: http://www.LearnTransactSQL.com
• Category: SQL Server Training
• Skill Level: 200 (Beginner - Intermediate)
• Length: 11:00 (7.26MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: data type conversion, cast, convert, cast and convert, numeric, decimal, varchar(max), nvarchar(max), float, real, int32, int64

Free Transact SQL Video Tutorial: Part 1 - Identity Columns - When Should I Use an Identity Column?

Part 1 - Identity Columns - When Should I Use an Identity Column? - download

IDENTITY columns are some data modeler's Best Friend yet others avoid them like the plague in favor of "Natural Keys" only and/or GUIDs. This video, part one in a series, walks you through the if, ands, and buts of using IDENTITY columns, points out some suggested use of IDENTITY columns and finished with a few Gotchas of using IDENTITY columns.

---

• Source: http://www.LearnTransactSQL.com
• Category: SQL Server Training
• Skill Level: 100 (Beginner)
• Length: 19:05 (14.1MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: identity, update identity, autonumber, auto-number, auto number, seed, increment, beginner, beginning, for beginners, introducti

Free Windows 2003 Video Tutorial: Setup Your DHCP Server

Setup Your DHCP Server - download

Grant Moyle teaches you how to setup your DHCP server so that you can allocate IP addresses dynamically. You'll use the Add/Remove Windows Components dialog box to add/modify your Windows installation for DHCP and then configure the server to assign dynamic IP addresses. You'll also pick up tips on subnetting and creating/working-with subnet masks

---

• Source: http://www.learnwindows2003.com
• Category: Windows Server System Training
• Skill Level: 200 (Beginner - Intermediate)
• Length: 15:31 (10.7MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: DHCP server setup