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.

"Most useful? The way the course is structured, enabling the student to work at their own pace so the information can be understood."

Data Analyst
Proxima Support Services
Cwmbran

COURSE OUTLINE

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 course, would recommend to colleagues. The tutor did an excellent job of bringing alive what would otherwise have been quite a dry subject matter!"

Senior Account Manager
CBSA
Dudley

"Next to no experience of SQL queries before this course so I found it all useful. The most useful things for me were learning how to generate and display queries in a neat and understandable format (means I can now unpick my departmental queries more easily!)."

Accommodation Services Manager
ECA International
London

"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
Sunderland

"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
Sunderland

"I can honestly say that there was nothing in the course that was not useful. It was truly informative and I feel I know a lot more now."

Analysis Manager
NHS Sefton
Bootle

"Excellent - I am a complete beginner to SQL and have been amazed at how much I have learned in these three days and how far I am going to be able to go on this basis."

Senior Information Analyst
NHS South East London
London

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

FIXED PRICE !

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.

NEED MORE ?

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!

NO EXTRAS !

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.

EASY !

All you have to organise is:

  • The attendees
  • The room

EMAIL US NOW !

Yes We Can !

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

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

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
London
EC1V 2NX
United Kingdom
enq@lumia.com