PostgreSQL Database Administration Essential Training (Udemy.com)
PostgreSQL 16 Database Administration Essential Training
Created by: Emar Morrison
Last updated January 2025
What you will learn
- How to Install and Configure Postgres
- How to Perform Backups and Restores
- How to Create Roles and Grant Permissions
- How To Manage Tablespaces
- How To Optimize Database Backups
- How To Migrate Databases
How it compares
Against the other 1,182 rated Udemy courses in IT & Software on CourseDuck:
- Rating4.1 out of 5higher than 9% of them
- Reviews140#922 of 1,183 by number of reviews
- Length1.9 hoursshorter than 85% of them
- Last updatedJanuary 2025earlier than 56% of them
Course Description
PostgreSQL Administration Course Overview
This course is targeted at beginners and 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, 15 an 16 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.
Instructor Details
- 4.1 Rating
140 Reviews
Emar Morrison
Emar J. Morrison is an experienced database administrator with almost a decade of expertise in the field. He has worked with various organizations, both big and small, and has played an instrumental role in the successful implementation and maintenance of their databases. Emar is well-versed in various cloud platforms, including Amazon Web Services (AWS) and Microsoft Azure.
Apart from his work in database administration, Emar is also an avid investor with a keen interest in the stock market. He believes in the importance of investing as a means of building wealth and achieving financial freedom. Emar has spent years studying the strategies of successful investors and has honed his skills in identifying promising investment opportunities. He has a passion for sharing his knowledge with others and is dedicated to helping people achieve their financial goals.
In addition to his work as a database administrator and investor, Emar is also a content creator. He is passionate about writing and creating informative and engaging content about database administration, cloud platforms like AWS and Azure, investing, and personal finance. Emar's content is designed to educate and empower his audience, providing them with the tools and knowledge they need to succeed.
More courses by Emar Morrison
More IT & Software courses
D3.js Data Visualization Fundamentals - Hands On (2026)
4.9 (3,917 Reviews)
Provider: Udemy
Time: 4.6h
$49.99
Hands-On Training: Streaming Data with Apache Kafka on Azure (2025)
4.9 (103 Reviews)
Provider: Udemy
Time: 3.7h
$10.99
Oracle Grid Infrastructure and RAC using Oracle Database 19c (2026)
4.8 (2,499 Reviews)
Provider: Udemy
Time: 8.7h
$19.99
PowerShell Scripting & Automation: The Complete Hands-On (2026)
4.8 (1,750 Reviews)
Provider: Udemy
Time: 9.6h
$11.99
AWS EC2 Crash Course + Load Balancing with Demos and PDFs (2025)
4.8 (866 Reviews)
Provider: Udemy
Time: 3.7h
$19.99
Reviews
By Román Bernabe on 5/16/2026
Short, straight to the point, covers all essential and daily administration tasks. Pefect for accidental DBAs or DBA who suddenly need to manage a Postgres db.
By Shaikh Saima Abdul Qadir on 4/11/2025
In this course only installation was in windows but all command and backup restore all things were explain in linux. It was good content but your course heading should be Potgresql Admin course on linux/Unbunto. Definitions were not explain well. Only readed data which are present on screen.
By Aravind Sanga on 12/25/2024
My main concern is that I find it difficult to understand some words during the conversation, possibly due to differences in pronunciation. Additionally, the explanations lack detail at times, which makes it hard for me to follow and there is no proper use of closed captions (CC), which further affects clarity.
By Andrew Sandrini Vaz on 8/5/2024
I liked it very much. I learned very much about Postgres Administration Basics.
By Hesham M on 6/1/2024
Till now, it is clear and good experience.
By Vijayant singh tomar on 5/15/2024
i have good experience with udemy.
By Iip Permana on 1/14/2024
Some of the video not link with the next one, such as in the installation process of linux, instructor ask to download linux server, but later instructor used linux desktop to simulate a remote server
By Suganthi Thirumeni on 10/4/2023
it's good course for people who know other DB and new to Postgres. Short and sweet! has enough to work on Postgres confidently!
By Abdul Yakubu on 2/7/2023
This is a good introductory session for Postgres. The only draw back is, the instructor didn't give assignments. Watching a demo can be easy, but it's nice to have a hands on trial of what was thought. Without the practise sessions, it made the tutoring boring.
By Alessandro Mortola on 12/31/2022
Good course to me, but I would have liked to go deeper on the security topic, not only explaining roles and grants in general but to teach how to configure them in a production environment. This has consequences also on backups when they are used to move a database from one cluster to another: what about the ownership of the database, of the tables? Is it better the plain text or custom format? And with which other options?
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 82 / 100







