PostgreSQL training | on site

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

A Foundation in SQL for PostgreSQL (3 days)

PSQ-82: SQL training for those who need to both query and modify PostgreSQL data and create PostgreSQL databases and tables.

"The course was presented well. The SQL documents were well written and I could understand everything. Also, whenever I had a question I would always get the answer I needed."

MI Analyst
Motability Operations
London

COURSE OUTLINE

This is a course for PostgreSQL database developers or users who need to manipulate data by interacting with PostgreSQL relational databases using Structured Query Language (SQL) and who need to progress their SQL skills beyond the basics. It is aimed at those who need to extract data from, and insert data into, existing PostgreSQL databases to an in-depth level and who also need to create and modify PostgreSQL databases and tables. The course is highly practical in nature and the focus throughout is on coding PostgreSQL-based SQL 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

Inserting, Updating and Deleting in a Transaction Environment

Creating and Modifying Tables

"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

"Very slick, well run and organised. Covered a lot in a short space of time, good that we have the opportunity to continue learning outside of the course. Thanks."

Performance Analyst
Leicestershire County Council
Leicester

"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

"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 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

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