Course Code: PSQLADM
Duration: 5 days
This PostgreSQL Administration course covers administration, maintenance, security and performance tuning of PostgreSQL version 10, 11 and 12 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 and 12 databases. This course is also suitable for users of PostgreSQL 9 databases.
The delegate will gain an understanding of:
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
The Instructor provided some very good real world examples, and his in-depth knowledge of the subject matter lent a great deal of substance to the course.
Iain - Technical IT Trainer - April 2020
The course was well-structured and included the practical exercises, that helped to understand the subject more easily. It has been very useful.
Rahat - Database Engineer - Academic - February 2020
The large amount of time dedicated to installation and configuration was really beneficial as I am new to Postgres and didn't want to miss out on any important features, particularly in relation to web app security surrounding users. Any questions I had were answered by the instructor in full giving me a good idea on how to apply the course material to my own environment at work. I am going to recommend Stay Ahead MySQL training for other developers in my team as they have had MySQL courses cancelled by (other supplier) twice now and the quality of the courses are equally as comprehensive at Stay Ahead.
Steven - Defence - February 2020
Trainer was really helpful during my Postgres Administration course. I have not used Linux operating system before but with the material I was able to find my way around using the terminal as the course material was well detailed. Thanks. Good job.
Toheeb - Database Administrator - Leisure - December 2019
Very good training, instructor very responsive to questions and knowledgeable all-round. It was also helpful as an added bonus that our instructor knew many other database engines which helped me understand by referring between the two for similarities.
Daniel - Government
Having been told to install and manage a PostgreSQL database, this course was exactly what I needed. It covered everything I need to know and now I have plenty to work with back in the office. I would certainly recommend this course to anyone who is starting out managing PostgreSQL databases. The trainer was very knowledgeable and put across the content in an easily understood way and ensured we all had a thorough understanding of each topic. A very good week.
Neil - DBA - Retail / Hire
Duration: 5 days
Price: £1,995.00 exc. VAT
Live Virtual Classroom
Our Customers Include
Our Course Curriculum