Transact SQL training | on site

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

Querying with Transact SQL (T-SQL) (2 days)

TSQ-63: Introductory T-SQL training for developers or users who only need to extract (not modify) data stored in SQL Server databases.

"All of the course was useful, the practical aspects were by far the most useful, the input from the tutor on individual problems was also helpful."

Developer/Web Designer
Credit360
Cambridge

COURSE OUTLINE

This highly rated course is for those working with Microsoft SQL Server who need to extract data using Transact SQL (T-SQL). While attendees gain much experience designing complex T-SQL queries using standard functions, inner joins and aggregate functions, T-SQL action statements which facilitate data or database modification do not form part of this course (for this, see TSQ-64). So as to master the syntax of the language, 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 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

"Not knowing any SQL when I walked in the door I am now leaving with a good knowledge. So in my eyes, the level was perfect and at the right speed."

Commercial Systems and Processes Coordinator
NHBC
Milton Keynes

"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

"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

"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

"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

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:

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

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