Introduction to SQL PostgreSQL — A 2 day course

contact usEnquire about this course


This is a course for those who will be writing SQL both to extract data from PostgreSQL databases for either reporting or data analysis purposes, and also to update data. The aim is to provide a sound foundation of SQL, both in general, and in the context of PostgreSQL. The course is a hands on course and the emphasis is on creating SQL scripts textually, rather than through a GUI.


No prior knowledge of databases or SQL is assumed, but, the course is oriented towards the needs of IT professionals.


Courses in this subject are scheduled on an 'ad-hoc' basis. We can arrange a course at our Carshalton centre or on customer site for any client wishing to send two or more delegates on the same course.

For courses at the Carshalton Centre the fee will be:

On-site course fees are as above + expenses recharged at cost.

For a 1:1 course in Carshalton the fee is £1300 + VAT. For a 1:1 on-site course the fee is £1300 + VAT + expenses recharged at cost.


Introduction to Database Concepts

Introduction to SQL

Retrieving data - SELECT, WHERE and ORDER

Filter Results using the WHERE clause

Queries involving multiple tables

Working with the Standard PostgreSQL Functions

Grouping and Summarizing Results



Inserting, Updating and Deleting Data