Skip to content
UdemyIT & SoftwarePaid courseAll LevelsCertificate

PostgreSQL Database Administration Essential Training (Udemy.com)

PostgreSQL 16 Database Administration Essential Training

Created by: Emar Morrison

Last updated January 2025

icon
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

icon
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.

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More courses by Emar Morrison

$69.99

icon
More IT & Software courses

$49.99

$10.99

$124.99

$19.99

$11.99

$19.99

icon
Reviews

4.1

140 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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?

Showing all 10 reviews on CourseDuck

Read all 140 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 82 / 100