Course Code: PSQL
Duration: 3 days
The SQL for PostgreSQL course is designed to give delegates practical experience in writing SQL statements and scripts using PostgreSQL. The basic SELECT statement, the use of SQL functions, and the basic table and view handling statements are introduced.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
The course aims to provide the delegate with the knowledge to be able to use SQL to manipulate data held in a PostgreSQL database and to progress their SQL skills beyond the basics.
This is an ideal course for anyone who needs to use and understand the Structured Query Language (SQL) to query, report and update data in a PostgreSQL database.
The delegate will learn and acquire skills as follows:
There are no formal pre-requisites for the SQL for PostgreSQL course, although an understanding of databases and exposure to information technology in general would be useful. This knowledge can be gained by attendance on the Relational Databases & Data Modelling Overview course.
Tarn was fantastic. Very thorough teaching and all in a friendly and engaging manner. I had internet issues that caused me to miss quite a bit of the morning session on day 2 and Tarn offered to stay after the days training had finished to fill me in on what I missed. I really appreciated this and think it spoke volumes about the care and attention Tarn had for our training.
Keean - Apprentice Data Analyst - IT
Tarn was extremely good at explaining concepts, and was always patient in answering questions. A very good instructor.
Neil - tester - Government
Brilliant course Tarn done very very well considering it was all on Zoom. Course content was good and the system was good apart from it kicked me out once for apparently being on too long but it let me back in straight away.
Callum - Data Assistant
Fantastic training that was well paced with good detail. Overcame the barrier of remote teaching. Good online resources that worked well and the use of sql server in utilities focused well to learn the syntax.
Warren - Information Analyst
I thoroughly enjoyed this course. Trainer was friendly and very knowledgeable about all aspects of the course. The explanation of the subject matter was always easy to follow and he was able to answer all of my questions in a simple and easily understandable manner. Thank you very much!
Rory - Trainee Database Developer - Government
Very good course with a friendly instructor who was obviously well experienced and great at teaching. I would recommend this course for anyone needing further experience in PostgreSQL.
George - Graduate Technical Engineer - IT
Duration: 3 days
Price: £1,350.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum