Microsoft SQL training | SQL Programming and Stored Procedures (2 days)

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 use the main SQL keywords SELECT, FROM, WHERE, GROUP BY and ORDER BY, and shows you how to really progam in SQL Server. Learn how to write stored procedures, create 3 different types of function, use subqueries effectively - and much more!

SQL Programming and Stored Procedures training - Course Contents

The contents of our SQL Programming and Stored Procedures course are as follows (any items marked with a * will be covered if time allows). If you aren't sure if this is the right course for you, please either click on one of the content headings below and try some exercises or call or email us to talk through your options. We want you to be on the right Microsoft SQL training course as much as you do!

Scalar functions
  • Types of function
  • Creating functions
  • Passing arguments
Progamming
  • Global variables (@@)
  • Creating and setting variables
  • IF statements
  • BEGIN/END blocks
  • WHILE loops
Stored procedures and parameters
  • Creating and altering stored procedures
  • Input and output parameters
  • System stored procedures
  • Setting default values
Subqueries
  • The concept of a subquery
  • Using ALL, ANY and IN
  • Correlated subqueries
  • Using EXISTS
Debugging
  • Enabling debugging
  • Stepping through SQL
  • Breakpoints
Error handling
  • TRY / CATCH
  • Using error functions
  • Raising errors
Creating tables
  • Creating tables and columns
  • Temporary tables
  • Table variables
  • SELECT INTO
Cursors (*)
  • Declaring cursors
  • Scrolling through recordsets
  • Cursor speed
Amending data
  • INSERT and UPDATE
  • Identity and Scope_Identity
  • Preventing SQL injection
  • DELETE and TRUNCATE TABLE
Table functions
  • Table-valued functions
  • Rowset functions

To help see if this is the right course for you, you can see and download examples of our SQL courseware. You can also look at the differences between Microsoft SQL versions and see on which SQL version we currently train.

SQL Programming and Stored Procedures training - Pre-requisites

You should only attend this course if you have either attended our two-day introduction to SQL course or if you are comfortable creating queries using SQL.

SQL Programming and Stored Procedures training - Schedule and Prices

Prices for this Microsoft SQL training course are as follows:

There will be a maximum of 6 people on each course, and each person will have their own computer. Please take a moment to see why our Microsoft SQL training courses are so different, then use our easy-to-use web-based or telephone booking system to book your course place. Alternatively, call (01457) 858877 or email our training co-ordinator.

Onsite Microsoft SQL training

In addition to our standard scheduled Microsoft training courses, we also offer onsite Microsoft SQL training. This allows you to create a Microsoft SQL training course uniquely tailored to the needs of your staff, covering only those aspects of Microsoft SQL which they need to learn.

Recommended sites: TechTutorials

All content copyright Wise Owl Business Solutions Ltd 2009.  All rights reserved.