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 notes are very comprehensive. I've been on a SQL training course before but the language used in this course made a huge difference as it was written in plain English and easy to follow."

Digital Analyst
The Guardian
London

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

"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

"Next to no experience of SQL queries before this course so I found it all useful. The most useful things for me were learning how to generate and display queries in a neat and understandable format (means I can now unpick my departmental queries more easily!)."

Accommodation Services Manager
ECA International
London

"Having had very little exposure to SQL, the content is perfect for all entry levels. It's also great that after the course the material can be worked on to gain further knowledge and experience of SQL."

Senior Staff Equipment Engineer
International Rectifier Corporation
Newport

"All of the course was useful, although I have worked with SQL a lot I was always told that there's a certain way for things to be done, but never knew why. I am leaving the course with a full understanding around the reasoning of certain actions."

Operations Analyst
Vanquis Bank
Maidstone

"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

"Met needs perfectly - a good grounding in SQL and the tools to take away to refresh myself if need be. The material to take away is ideal."

Senior Analyst
RWE Npower
Sunderland

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:

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