Programming with Transact-SQL
Course Outline

DURATION 2 Days
PREREQUISITES A working level of SQL (SELECT, UPDATE and DELETE statements) is assumed. Delegates without this experience should consider the Introduction to SQL course.
DESCRIPTION

Transact-SQL (or SQL) is Microsoft's and Sybase's proprietary extension to SQL. This course will introduce you to the programming features of the language, using Microsoft's SQL Server 2008. With prior knowledge of SQL assumed, this course looks at the procedural programming language functionalities of T-SQL, such as local variables, flow control constructs, error handling and built-in functions.
COURSE DATES Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekday Wed, 8-Jun-11 and Thu, 9-Jun-11 09:30 - 16:30 £714.00

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

TOPICS COVERED

  • Stored procedures
  • User defined functions (UDFs)
  • Local variables
  • Parameters
  • Error handling
  • Using cursors
  • Transaction control
  • Triggers

 

 

 

 

 

 

 


Home | Contact | Terms and Conditions