Advanced SQL training course July 31, 2013

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! The course uses SQL Server 2005 or 2008 R2, although you can elect to use 2012 if you prefer (just let us know in advance).

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