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

"Spot on! Loved working at my own pace and not being lectured to all day. This is by far the best way to learn and for me to take information in."

Systems Analyst
Unite Integrated Solutions
Bristol

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

"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

"An excellent teacher. The course gets 10 out of 10 for presentation and preparation. Excellent. I would recommend this to others."

IT Team Leader
Prestige Underwriting Services
Belfast

"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

"I can honestly say that there was nothing in the course that was not useful. It was truly informative and I feel I know a lot more now."

Analysis Manager
NHS Sefton
Bootle

"Presented very well. I found the tutor to be knowledgeable and entertaining. He got me interested in a subject that would normally not be interesting."

Operations Manager
Instructus
London

"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

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:

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

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