SQL Querying for PostgreSQL — A 2 day course

contact usEnquire about this course

Synopsis

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.

Prerequisites

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

Schedule

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 £1100 + VAT. For a 1:1 on-site course the fee is £1100 + VAT + expenses recharged at cost.

If there are dates showing below this line, a course has been scheduled and places for individuals are available at £700. Otherwise, no courses are currently scheduled and the above fees apply.


Contents

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

Subqueries

Views