Transact SQL training | on site

We deliver low cost Transact SQL training in london  midlands  bristol  scotland  wales  uk-wide

Transact-SQL (T-SQL) Programming (2 days)

TSQ-66: Procedural programming techniques for SQL Server developers. Conditional Processing, Stored Procedures, User defined Functions, DML Triggers and Error Handling techniques are covered in a highly practical and modular environment.

"Thank you very much for your time. Great course and delivered well. You have a way of making everything seem so simple and straightforward. Thanks."

European Quotes Team Manager
Premier Farnell


Providing a solid grounding in procedural programming techniques for SQL Server / Transact-SQL (T-SQL) developers, this course is aimed at those with sound experience of SQL basics (on any platform). Variables, Conditional Processing, Stored Procedures, User defined Functions, DML Triggers and Error Handling are covered in a highly practical and modular environment so that attendees learn by doing. Working in a tutorial style environment, one to one interaction is facilitated and encouraged.On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are made available online for each attendee.

Suggested Prerequisites

This is a course for those with sound experience of SQL basics (on any platform).

T-SQL Views Reviewed

Introducing Procedural Programming

Conditional Processing

Harnessing T-SQL Stored Procedures

Understanding User Defined Functions (UDFs)

Implementing Error Handling

Using DML Triggers

"Excellent. The course content was pitched exactly where it should have been to take account of people who had used SQL before and people who hadn't."

Finance and Operations Director
Hays Travel

"I had previously used SQL (pretty much blind) to query our extensive accommodation database without really knowing what I was doing. Now I'll be able to interpret the commands being used, modify them well, and also create new queries from scratch."

Accommodation Services Manager
ECA International

"The overall course was great, I'm pleased I got to come back for a second time to further the knowledge I picked up on the first course. The course material was really useful and the course teacher was really helpful with any problems!! Great course!!"

Analytics Analyst

"I like how I was able to work at my own pace but also felt supported when required. I like how the modules are available to me after the course to complete so I can continue to learn."

Senior Analyst
RWE Npower

"The courseware is excellent. The notes are brilliant and the fact I can take them away with me will make life much easier when putting my learning into practice."

Business And Performance Information Manager
Wiltshire County Council

"Met needs perfectly - a good grounding in SQL and the tools to take away to refresh myself if need be. The material to take away is ideal."

Senior Analyst
RWE Npower

Lumia development

home | about us | 100% guarantee | comments | how to order | privacy policy | terms and conditions | contact us

For superior SQL training UK-wide: EMAIL US


To deliver this Transact SQL training on your site, we charge an all-inclusive, fixed price of:

£1195.00 + vat per day for up to 6 attendees per course.


Our unique, tried and tested, practical methodology means we can successfully get the individal pace right for up to 15 attendees per course - email us now to find out how!


The price includes:

  • The tutor
  • All tutor expenses
  • Course laptops
  • Extension leads
  • Course software
  • Projection facility
  • Course notes
  • Example data
  • Certificate of attendance

Course notes and practical work are made available online for each attendee after the course.


All you have to organise is:

  • The attendees
  • The room


Yes We Can !

We can deliver our SQL training at your venue anywhere in the UK:

Edinburgh Leicester Sheffield Northern Ireland the South East Essex the North West Aberdeen Lancashire Manchester London Oxford Belfast Newcastle Upon Tyne Portsmouth the North East Wales Reading the South West South Wales the East Midlands York the West Midlands Nottingham Cardiff Plymouth Birmingham Leeds Bristol Scotland Glasgow Preston Yorkshire Liverpool Wolverhampton Coventry Leicestershire Hampshire Bedford Chester Slough Middlesbrough Hull Sunderland Berkshire Inverness Cambridge Bedfordshire Newport Northamptonshire Nottinghamshire Southampton Milton Keynes Colchester Peterborough Port Talbot Huntingdon Swindon Lincoln Guildford Bath Suffolk Warrington Brighton Bournemouth Warwickshire Canterbury Swansea Devon Chelmsford Cheltenham Northampton Warwick Exeter Kent Winchester Derby Watford Gloucester Perth Norwich Telford Ipswich Leamington Spa Livingston Eastleigh Pontypridd Torquay Salisbury the South the East the West Newton Abbot Durham Maidstone the North Loughborough

Contact us

For Transact SQL training requirements in London, Midlands, Bristol, Scotland, Wales and across the UK, contact:

Lumia Development
Kemp House
152 City Road
United Kingdom