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

"The course was very well run. I felt I could ask the tutor anything and he wouldn't think it a silly question. The course notes were really well written and very easy to follow. We were all engaged throughout the 3 days. I am extremely happy with the course. "

Catastrophe Analyst
Novae Group
London

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

"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

"I thoroughly enjoyed the course and the tutor was extremely helpful and easy going. Course was fun but I do feel I have learnt a lot."

Billing Administrator
Viridian Energy
Belfast

"Excellent - I am a complete beginner to SQL and have been amazed at how much I have learned in these three days and how far I am going to be able to go on this basis."

Senior Information Analyst
NHS South East London
London

"I like how I was able to work at my own pace but also felt supported when required. I like how the modules are available to me after the course to complete so I can continue to learn."

Senior Analyst
RWE Npower
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

"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

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:

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

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