PostgreSQL training | on site

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

Introduction to SQL for PostgreSQL (2 days)

PSQ-81: Introductory SQL training for those who need to extract data from and update data in PostgreSQL databases.

"The pace was very appropriate. The tutor sensed when we wanted to get stuck in and when we wanted to discuss something and let us run with either when they arose."

Commercial Business Insight Analyst
PRETTYLITTLETHING.com
Manchester

COURSE OUTLINE

This introduction to SQL training course is specifically for PostgreSQL database developers or users who need to to be competent extracting data from, and updating data in, PostgreSQL relational databases. The course is highly practical in nature and the focus throughout is on coding SQL (with PostgreSQL variances) 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, PostgreSQL or relational database experience is assumed.

An Overview of PostgreSQL Relational Databases

Introducing SQL for PostgreSQL

Retrieving Data with PostgreSQL SQL: First Steps

Using WHERE to Filter Results

Getting Results From Multiple Tables

Using Standard PostgreSQL Functions

Working with Dates

Grouping and Summarizing Results

Working with Subqueries

Working with Views

Inserting, Updating and Deleting Data

"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

"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

"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

"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

"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

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 PostgreSQL training on your site, we charge an all-inclusive, fixed price of:

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

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

Contact us

For PostgreSQL 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