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.

"The quality of the course was fantastic. The inclusion of notes, examples and answers before the projects was great, as were the individual projects themselves and how they progressed in difficulty as you moved your way through each module."

Commercial Business Insight Analyst
PRETTYLITTLETHING.com
Manchester

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

"Think it will be very useful for me in the long run. All the materials will be great to refer back to. Have definitely learnt new things and (probably better!) ways of doing things."

Customer Insight Analyst
ASOS.com
London

"Found all the course useful. Was concerned that the mixture of experience was going to either hold some back or leave others head scratching. I am and pleased to say neither happened."

Communications Manager
Department for Work and Pensions
Newcastle Upon Tyne

"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

"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

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

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

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

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