SQL Programming and Stored Procedures

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.

You do not need any formal qualifications to attend this course, although you should read the course pre-requisites carefully.

Price for course is £695.00 including lunch at a local restaurant, full colour courseware, exercise booklets, a USB stick, Wise Owl pen and all drinks and refreshments!

Wise Own – specialist Microsoft training

Wise Owl provide Microsoft computer software training across the UK. Training can be delivered both at our city centre training venues, or at your offices.

When we say Microsoft training courses, we mean training in everything from MS Access, MS Excel, MS Project and MS Visio through to SQL Server database and ASP.NET training.  We also train in programming in C#, VB and VBA, including Visual Basic macros.

Wise Owl employs 5 dedicated trainers, who train exclusively for us.  With small class sizes and excellent courseware, we like to think we're just that bit better than other computer training companies. Check out our courses and see for yourself. We provide Microsoft training for 51 of the FTSE 100 companies, so we must be doing something right!

Wise Owl offers:

• References from 137 companies viewable on our website
• Small class sizes
• Friendly and expert trainers

Send an » Information Request to ask about our public open courses or to see how we can help you meet your bespoke training needs.  Alternatively, call Sandi on (01457) 858877, who will help you without trying to sell you training that you don't need!

Get more information from Wise Owl by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.

Fill out to send an e-mail to Wise Owl

* =  Required field

Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date	--- Choose ---18/05/2010 Manchester11/08/2010 Manchester18/10/2010 Manchester
Message

Contact Wise Owl

SSRS, 2008, Analysis Services, cubes, SQL Server Reporting Services, SQL, T-SQL, Transact-SQL, MySql, Access, SQL Server, 2005, 2000, MySQL, database, Microsoft, stored procedures microsoft,accredited,bespoke,open courses,london,manchester,birmingham