An Overview of the UPDATE Statement - Video Series Video Category: SELECT, INSERT, UPDATE and DELETE - Data Manipulation Language Skill Level: 200 (Beginner - Intermediate) Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008 This series will demonstrate to you how to utilize proper syntax and rules when working with the UPDATE statement. Highlights: Introduction and Explanation of the three SQL Language Classifications DEFAULT DML STATEMENT Open and Completed Transaction Statements Introduction to IF and ELSE statements within Transactions. Proper utilization and syntax with the UPDATE STATEMENT and SET COMMAND. Common Errors in real world uses of SELECT and FROM statements and how to rectify those errors Introduction to JOINS and UPDATES

Videos in this Series:

Title Skill Length Download Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact...   200 14 mins. Download Pt. 2 - How Transactions and Locks Affect UPDATE and SELECT Statements   300 9 mins. Download Pt. 3 - Writing UPDATE Statements That Reference Multiple Tables (Subqueries)   300 10 mins. Download Pt. 4 - Writing UPDATE Statements That Reference Multiple Tables (FROM Clause)   400 12 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

Helpful Keyboard Shortcuts: "Windows key" + "M" minimizes all windows Book You Should Probably Own: Brian Knight's "Professional SQL Server 2005 Integration Services" Windows Server 2003 Tips and Tricks: You can now disable the original "Administrator" account. One bonus tip: create a separate account with administrator privileges before disabling the "Administrator" account