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.

"I felt the course was an excellent introduction to SQL. The tutor was knowledgeable on the subject and made the material easy to understand. Many thanks."

Information Quality Manager
The Royal Liverpool and Broadgreen University Hospitals
Liverpool

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

"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

"Absolutely brilliant, strongly recommended to others. Really glad I was entered onto the course. Thank you for your time and help!"

Analyst
Aimia Coalition Loyalty
London

"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

"Superb course. The setup of tutor being able to see work in progress kept me on my toes! Would highly recommend this to our other DBA's."

SQL Server Database Administrator
The Land Registry
Plymouth

"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

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

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