PostgreSQL training | on site

We deliver low cost PostgreSQL training in london  midlands  bristol  scotland  wales  uk-wide

SQL Querying for PostgreSQL (2 days)

PSQ-80: Introduction to SQL training for developers or users who need only to extract (not modify) data from PostgreSQL databases

"I loved this course. It was really fun, useful and has given me SQL confidence. I feel I can write a script without tweaking someone else's. I also have a good method of working and will try to remember all of the tutor's tips! Brilliant. Can you come back please? "

Information Analyst
CBSA
Dudley

COURSE OUTLINE

This SQL training course is for those who need to extract data specifically from PostgreSQL relational databases. While attendees gain much experience designing complex SQL queries using standard PostgreSQL functions, joins and subqueries, SQL action statements which facilitate data or database modification are not covered. 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

"The courseware is excellent. The notes are brilliant and the fact I can take them away with me will make life much easier when putting my learning into practice."

Business And Performance Information Manager
Wiltshire County Council
Trowbridge

"Think it will be very useful for me in the long run. All the materials will be great to refer back to. Have definitely learnt new things and (probably better!) ways of doing things."

Customer Insight Analyst
ASOS.com
London

"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

"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

"The best course I have been on in a good number of years, I feel I have learnt a lot but also know there is so much more to learn. I will continue to use the material to enhance my learning."

Senior Analyst
RWE Npower
Sunderland

"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

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:

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