Description
PostgreSQL Administration Course Overview
This course is targeted towards beginners, DBAs with experience using another DBMS such as Microsoft SQL Server, MySQL or Oracle.
Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.
Course Objectives
This course aims to provide the delegate with the knowledge to be able to install, administer, maintain, backup, recover and tune a PostgreSQL database.
Who will the Course Benefit?
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 and 15 databases. This course is also suitable for users of PostgreSQL 9 databases.
Skills Gained
The delegate will learn and acquire skills as follows:
- Install PostgreSQL
- Create a database
- Manage roles and privileges
- Manage schemas
- Examine statistics and system tables
- Manage tablespaces
- Understand error reporting and logging
- Carry out periodic maintenance with VACUUM autovacuum
- Backup and restore databases
- Create indexes to improve table access
- Configure settings for increased performance
PostgreSQL is one of the most advanced open-source platforms available today. Multiple large-scale organizations such as Cisco and Apple use the tool for their web-based and mobile-based application development. It is managed by an open-source community that is dedicated to improving the platform to keep it relevant to today’s time. Another focus for the community of developers is security; they keep evolving PostgreSQL and updating their security measures to keep up with the threats of today.