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.

"Most useful? The vast amount of material available both during and post-course - I feel these will really help me to solidify my understanding of what I've learnt."

SQL Support Analyst
Wales Millennium Centre
Cardiff

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

"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

"Presented very well. I found the tutor to be knowledgeable and entertaining. He got me interested in a subject that would normally not be interesting."

Operations Manager
Instructus
London

"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

"Having had very little exposure to SQL, the content is perfect for all entry levels. It's also great that after the course the material can be worked on to gain further knowledge and experience of SQL."

Senior Staff Equipment Engineer
International Rectifier Corporation
Newport

"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

"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

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:

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

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