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.

"Brilliant course. Would highly recommend to anyone who is new to SQL. Tutor's pace is the main selling point for this course. Great working examples - and help on hand was great."

Systems Support Analyst
Lewisham Homes
London

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

"An excellent teacher. The course gets 10 out of 10 for presentation and preparation. Excellent. I would recommend this to others."

IT Team Leader
Prestige Underwriting Services
Belfast

"Having had very little exposure to SQL, the content is perfect for all entry levels. It's also great that after the course the material can be worked on to gain further knowledge and experience of SQL."

Senior Staff Equipment Engineer
International Rectifier Corporation
Newport

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

"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
LV
Bournemouth

"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

"Absolutely brilliant, strongly recommended to others. Really glad I was entered onto the course. Thank you for your time and help!"

Analyst
Aimia Coalition Loyalty
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:

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

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