PostgreSQL Database Administration
Learn how to install, administer, maintain, backup, recover, and tune a PostgreSQL database with this comprehensive administration course. Suitable for beginners and experienced DBAs, you’ll gain practical hands-on experience in managing PostgreSQL databases and optimizing performance. With its advanced features and dedicated open-source community, PostgreSQL is a popular choice for large-scale organizations. Enhance your database administration skills and stay updated with the latest security measures in this valuable course. Ideal for database administrators and DBAs.
What you’ll learn
- Install and Configure Postgres
- Perform backups and restores
- Create Roles and Grant Permissions
- How To Manage Tablespaces
- How To Optimize Database Backups
- How To Migrate Databases
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
Examine statistics and system tables
Manage tablespaces
Carry out periodic maintenance with VACUUM autovacuum
Backup and restore databases
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.
Who this course is for:
- Database administrators
- DBAs
User Reviews
Be the first to review “PostgreSQL Database Administration”
You must be logged in to post a review.
There are no reviews yet.