Transact SQL training | on site

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

Introduction to Transact SQL (T-SQL) (2 days)

TSQ-64: Introductory T-SQL training for developers or users who need to both extract and modify data stored in SQL Server databases.

"The course was presented very professionally, yet friendly. The tutor's effort and experience is evident in all aspects and a credit to why the course is so successful."

Gas Settlement Team Manager
First Utility
Warwick

COURSE OUTLINE

This course is for those working with Microsoft SQL Server who need to extract and update data using Transact SQL (T-SQL) up to the level of working with inner joins, grouping and summarizing results, working with standard functions and performing action queries with INSERT, UPDATE and DELETE. In order to master the syntax of the language, the course is highly practical in nature and the focus throughout is on coding Transact SQL (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

Inserting, Updating and Deleting Data

"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

"The content of the course was self-governed to a large extent and each person got to a level at which they were comfortable."

Network Analysis Team Leader
National Grid
Sindlesham

"I thoroughly enjoyed the course and the tutor was extremely helpful and easy going. Course was fun but I do feel I have learnt a lot."

Billing Administrator
Viridian Energy
Belfast

"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

"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

"Excellent. The course content was pitched exactly where it should have been to take account of people who had used SQL before and people who hadn't."

Finance and Operations Director
Hays Travel
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:

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

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