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 tutor managed the impossible and made me enjoy being on an SQL course. He also taught me a lot and made me keen to learn more."

Icon Technical Consultant
Linedata
Edinburgh

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

"Excellent course, would recommend to colleagues. The tutor did an excellent job of bringing alive what would otherwise have been quite a dry subject matter!"

Senior Account Manager
CBSA
Dudley

"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. 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

"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

"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

"Not knowing any SQL when I walked in the door I am now leaving with a good knowledge. So in my eyes, the level was perfect and at the right speed."

Commercial Systems and Processes Coordinator
NHBC
Milton Keynes

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:

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

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