Course Code: PSQLADM
Duration: 5 days
This PostgreSQL Administration course covers administration, maintenance, security and performance tuning of PostgreSQL version 10, 11, 12, 13, 14, 15 and 16 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, 14, 15 and 16 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
Tarn is an excellent instructor who explained the topics very well. He is very experienced and very knowledgeable. He paced the topics well, after introducing concepts, he showed practical demos using the product, and also assisted during the lab exercises. I would definitely recommend him to my colleagues. I look forward to coming on the Advanced Postgres Administration course. Many Thanks
Arif - DBA - IT - March 2024
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
Live Virtual Classroom
Our Customers Include
Our Course Curriculum