sql training | on site

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

A Foundation in Transact SQL (T-SQL) (3 days)

TSQ-65: Fixed price Transact SQL training delivered on your site at any UK location.

"A good learning experience."

Senior Divisional Analyst
The Royal Wolverhampton Hospitals
(Wolverhampton)

COURSE OUTLINE

This course is aimed at those working with Microsoft SQL Server who need to extract and insert data to an in-depth level and who also need to create and modify database objects. 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 provided on a free USB pen drive to take away.

Suggested Prerequisites

No prior T-SQL training or relational database experience is assumed.

Relational Databases and SQL: An Overview

T-SQL Statements and Queries: Their Structure

Retrieving Data with T-SQL: First Steps

Using WHERE to Filter Results

Getting Results From Multiple Tables

Using Standard T-SQL Functions

Grouping, Summarizing and Ranking Results

Working with Subqueries

Working with Views

Inserting, Updating and Deleting Data

Inserting, Updating and Deleting in a Transaction Environment

Creating and Modifying Tables

lumia development

home | about us | 100% guarantee | comments | how to order | privacy policy | terms and conditions | contact us

UK-wide: 01785 318806  London: 0207 305 7179  or:  EMAIL US

FIXED PRICE !

To deliver this Transact SQL training on your site, we charge an all-inclusive, fixed price of:

£795.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 12 attendees per course - email us now to find out how!

NO EXTRAS !

The price includes:

  • The tutor
  • All tutor expenses
  • Course laptops
  • Course software
  • Projector
  • Course notes
  • Example data
  • Extension leads

Additionally, each attendee is given a USB pen drive containing course data files.

EASY !

All you have to organise is:

  • The attendees
  • The room

EMAIL US NOW !

Yes We Can !

We can deliver our SQL training on your site anywhere in the UK:

Aberdeen Bath Bedford Bedfordshire Belfast Berkshire Birmingham Brighton Bristol Cambridge Canary Wharf Cardiff Central London Cheltenham City of London Coventry Croydon Derby Devon Edinburgh Essex Exeter Glasgow Gloucester Hampshire Inverness Ipswich Kent Lancashire Leamington Spa Leeds Leicester Leicestershire Liverpool Livingston London Manchester Middlesborough Milton Keynes Newcastle Newport Northampton Northamptonshire Northern Ireland Norwich Nottingham Nottinghamshire Oxford Perth Plymouth Portsmouth Preston Reading Scotland Sheffield Slough South Wales Southampton Suffolk Sunderland Swindon Telford the East Midlands the Midlands the NHS the North East the South East the South West the UK the West Midlands Wales Warrington Warwick Warwickshire Watford Winchester Wolverhampton Worcestershire York Yorkshire

Contact us

For SQL training requirements in London, Midlands, Bristol, Scotland, Wales and across the UK, contact:

London:

Lumia Development
2nd Floor
145-157 St John St
London
EC1V 4PY
0207 305 7179

Bristol and West:

Lumia Development
Park House
10 Park St
Bristol
BS1 5HX
0117 915 4531

Midlands and UK-wide:

Lumia Development
Parkfield House
Park St
Stafford
ST17 4AL
01785 318806