Advanced SQL training course June 27, 2011

If you are comfortable creating queries in SQL, maybe it is time to move on to learn more advanced programming topics? This two day course assumes that you know how to query data using SQL, and shows you how to really progam in SQL Server. Learn how to write stored procedures; learn the differences between temporary tables, table variables, common table expressions, derived tables and the two types of table-valued function, and when to use each tool; find out what cursors are, and when you should avoid them; and learn about debugging and error trapping. A fun two days getting to know SQL better! This courses uses SQL Server 2005, although you can choose to use SQL Server 2008 if you prefer - the differences are small.

Official Website: http://www.wiseowl.co.uk/courses/sql-stored-procedures.htm