Transact SQL training | on site

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

Transact-SQL (T-SQL) Skills Booster (2 days)

TSQ-52: Practical skills booster Transact SQL (T-SQL) training for existing SQL Server T-SQL developers or users who wish to take their existing T-SQL skills to the next level.

"Brilliant (very appropriate) as there was enough for everyone to do over two days - from people like me (where SQL was a complete alien language) to people who have used SQL extensively."

Statistical Officer
Department for Transport
London

COURSE OUTLINE

This practical, workshop-style, Transact-SQL (T-SQL) training course is for existing SQL Server T-SQL developers or users who wish to take their existing T-SQL skills to the next level. The course is highly practical in nature. Attendees learn by doing at their own individual pace and the focus throughout is on coding T-SQL by hand. The 'T-SQL Basics Checkup' section at the start of the course is mandatory (attendees must demonstrate their basic skills before progressing to the workshop section of the course). All other listed topics are prioritised by the attendee on a 'Pick and Choose' basis (the tutor may suggest an ideal order of working). On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are made available online for each attendee.

Suggested Prerequisites

Introductory level Transact-SQL (T-SQL) skills are required as a prerequisite for this course.

T-SQL Basics Checkup

Beyond the Inner Join

Better Subqueries

Resolving T-SQL Data Type Issues

Specific T-SQL Techniques

Some Advanced T-SQL Techniques

"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

"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

"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

"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

"All of the course was useful, although I have worked with SQL a lot I was always told that there's a certain way for things to be done, but never knew why. I am leaving the course with a full understanding around the reasoning of certain actions."

Operations Analyst
Vanquis Bank
Maidstone

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:

£1095.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:

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