Course Code: PSQLADM
Duration: 5 days
This PostgreSQL Administration course covers administration, maintenance, security and performance tuning of PostgreSQL version 10, 11, 12, 13 and 14 databases.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
This course aims to provide the delegate with the knowledge to be able to install, administer, maintain, backup, recover and tune a PostgreSQL database.
This PostgreSQL Administration course is designed for professional database administrators who need to gain an understanding of the features and functionality that can be used to manage PostgreSQL 10, 11, 12, 13 and 14 databases. This course is also suitable for users of PostgreSQL 9 databases.
The delegate will learn and acquire skills as follows:
This course assumes a good working knowledge of SQL and specifically of the SELECT, INSERT, UPDATE and CREATE TABLE statements. This knowledge can be obtained by attendance on the pre-requisite SQL for PostgreSQL course.
This course is run on a Linux operating system, therefore a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course
Superb trainer with an extraordinary amount of knowledge. Friendly personality, great attitude and keen to help. Spent a long and tiring but extremely useful week together.
Dani - Database administrator - IT - September 2023
Tarn was a really great instructor indeed - thank you. He was very knowledgeable with the PostgreSQL Product and explained everything really clearly to all of us.
Gareth - SQL DBA - IT - May 2023
I found the course very interesting and very well paced. Tarn was an excellent instructor, very friendly and approachable, and very knowledgeable. I feel I have been given a very good grounding in Postgres and at the same time have the tools to deepen my knowledge.
Graham - Senior Applications Engineer - IT - April 2023
I really enjoyed this course. Course was perfectly customized to meet our needs at work place. Trainer was very professional and had in depth knowledge of the subject.
Ravindra - DBA - IT - April 2023
Tarn was excellent, the fact he knew Oracle and other databases and was able to relate concepts and experiences to PostgreSQL was a huge bonus.
Satbinder - IT - April 2023
Outside of the fact I am in the States and it required me to be up very early for 5 days, I don't regret it for a minute. The course was outstanding. The instructor could not have been better. I have been in IT for 44 years, have taught courses myself, taken many, and believe this was the best course I have ever taken. The material was spot on and all relevant. The labs were perfect and just the right amount. I could not be happier with the knowledge gained and hope I can attend the advanced course in the near future. Thank you again!
John - DBA - Automotive
Live Virtual Classroom
Our Customers Include
Our Course Curriculum