SQL Querying for PostgreSQL — A 2 day course

contact usEnquire about this course


This is a course for those who will be writing SQL queries to extract data from PostgreSQL databases for either reporting or data analysis purposes. It does not, therefore, deal with SQL statements that modify either the database, or the data in a database. The emphasis is on the design of simple and complex queries using SQL (and, also, including PostgreSQL specific features).

The 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