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.


WHAT YOU WILL 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


WHO THIS COURSE IS FOR

● Database administrators
● DBAs

1. Introduction
2. Install & Configure Postgres
3. Managing Databases
4. Managing Tablespaces
5. Securing Your Server
6. Backup & Restore Databases
7. Scheduling With pgAgent
8. Routine Database Maintenance Tasks

Emar J. Morrison is a 30-year-old investor with a love for personal finance and investment. For the past four years, he has been investing in the stock market. In 2016, he bought his first stocks with little idea what he was doing. He was, nevertheless, completely enthralled, and he buried himself in it.
He read a lot of books and researched investors like RULE 1 Investing’s Phil Town, Peter Lynch, Michael Lee-Chin, and, of course, Warren Buffet over the next few years. He has read George S. Clason’s The Richest Man in Babylon, Benjamin Graham’s The Intelligent Investor, Money Master The Game, and Tony Robbins’ The Unshakable.