These videos are excellent resources for anyone who wants to learn how to program in SQL

SQL PROGRAMMING VIDEOS
SQL Server Programming Part 1 - Stored Procedure Basics	Download
SQL Server Programming Part 2 - Stored Procedure Parameters	Download
SQL Server Programming Part 3 - Variables	Download
SQL Server Programming Part 4 - Output Parameters	Download
SQL Server Programming Part 5 - IF Statements	Download
SQL Server Programming Part 6 - WHILE Loops	Download
SQL Server Programming Part 7 - User Defined Functions	Download
SQL Server Programming Part 8 - Temporary Tables	Download
SQL Server Programming Part 9 - Table Variables	Download
SQL Server Programming Part 10 - Table Valued Functions	Download
SQL Server Programming Part 11 - Common Table Expressions	Download
SQL Server Programming Part 12 - Cursors	Download
SQL Server Programming Part 13 - Dynamic SQL	Download
SQL Server Programming Part 14 - Transactions	Download
SQL Server Programming Part 15 - DML Triggers	Download
SQL Server Programming Part 16 - DDL Triggers	Download
SQL Server Programming Part 17 - The Pivot Operator	Download
SQL Server Programming Part 18 - Dynamic Pivot Tables	Download