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.

"The courseware was very good; well laid out, methodically planned out and set up in a way that has allowed me to learn the subject efficiently and fast."

Electricity Analyst
First Utility
Warwick

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

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

"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

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

"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

"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

"The best course I have been on in a good number of years, I feel I have learnt a lot but also know there is so much more to learn. I will continue to use the material to enhance my learning."

Senior Analyst
RWE Npower
Sunderland

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:

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

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