Transact SQL training | on site

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

A Foundation in Transact SQL (T-SQL) (3 days)

TSQ-65: Introductory to intermediate level SQL Server-specific Transact-SQL (T-SQL) training for developers or users who need to query and modify data stored in SQL Server.

"It's really good to have all the notes and examples to take away because we covered a lot of ground. I really liked working through the course on individual laptops. Being able to do exercises all the time is much better than sitting through a lot of PowerPoints!"

Project Officer
Centre for Sustainable Energy
Bristol

COURSE OUTLINE

This is an introductory to intermediate level T-SQL training course for those who need to manipulate data by interacting with Microsoft SQL Server and who need to progress their T-SQL skills beyond the basics. The course is highly practical in nature and the focus throughout is on coding T-SQL by hand. On completion, a comprehensive set of course notes, examples, tutor and attendee scripts are made available online for each attendee.

Suggested Prerequisites

No prior T-SQL training or relational database experience is assumed.

Relational Databases and SQL: An Overview

Introducing Management Studio: SQL Server's IDE

T-SQL Statements and Queries: Their Structure

Retrieving Data with T-SQL: First Steps

Using WHERE to Filter Results

Getting Results From Multiple Tables

Getting Confident with T-SQL Joins

Using Standard T-SQL Functions

Working with Dates

Grouping and Summarizing Results

Working with Subqueries

More T-SQL Joins

Inserting, Updating and Deleting Data

"Superb course. The setup of tutor being able to see work in progress kept me on my toes! Would highly recommend this to our other DBA's."

SQL Server Database Administrator
The Land Registry
Plymouth

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

"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

"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

"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

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:

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

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