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.

"Presented very well - felt reassured that I had support if I needed it, and getting it before I realised how much I needed it!"

IT Manager
the reader
Liverpool

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

"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

"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

"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

"Very slick, well run and organised. Covered a lot in a short space of time, good that we have the opportunity to continue learning outside of the course. Thanks."

Performance Analyst
Leicestershire County Council
Leicester

"Met needs perfectly - a good grounding in SQL and the tools to take away to refresh myself if need be. The material to take away is ideal."

Senior Analyst
RWE Npower
Sunderland

"Excellent - I am a complete beginner to SQL and have been amazed at how much I have learned in these three days and how far I am going to be able to go on this basis."

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