UdemyHighest Rated on UdemyPostgresqlPaid courseAll LevelsCertificate

PostgreSQL Database Administration on Windows/Linux- Part 1 (Udemy.com)

Master PostgreSQL like a Pro—Entire Course Fully Updated to Version 17 with Cutting-edge features!

4.6

7,007 reviews

Created by: Sadiq Basha

Last updated July 2025

Our take

Based on the ratings of 7,007 students, a sample of their written reviews and the syllabus, as the course stood in July 2025. No course pays to be reviewed.

This is a server-side course, not a SQL tutorial. Sadiq Basha, a database administrator with about 20 years across Oracle, SQL Server and PostgreSQL, walks through architecture, storage, installation on Windows and Linux, configuration files, users and schemas, and psql. It runs 14.3 hours over 118 lectures in 21 sections. Around 29,900 students have enrolled, and it carries the Highest Rated badge. The audience list puts DBAs and accidental DBAs first, and the content fits that.

Reviewers like the clear explanations and the short videos. One says every command worked in their own lab, and another liked that it starts with how Postgres works instead of install steps. One student loved the instructor's pace. Of roughly 7,000 ratings, about 3,500 are five stars and 2,700 are four, with 642 at three. The sample has almost no complaints, so the cons are minor. There are no coding exercises, only 16 quizzes, so practice is left to the learner alongside the videos.

The biggest block is backup, restore and automation at about 2.4 hours, including continuous archiving and point-in-time recovery. Maintenance covers vacuum and reindexing, and there is a full upgrade section. The headline says the course was updated to version 17, but the syllabus shows version tours only through 16, last refreshed in July 2025. There is no replication or high availability section here. Still, it is a solid pick for anyone moving into Postgres administration who already knows basic database concepts.

Best forSysadmins and accidental DBAs who want to learn how Postgres runs, gets backed up and stays healthy.

Skip it ifYou want to learn SQL or build apps. This is mostly about running the server, not writing queries.

Pros

Starts with process and memory architecture, so later admin tasks make sense
Backup section runs about 2.4 hours, with continuous archiving and PITR
Short videos with demos that students say they could repeat in their own lab
Covers vacuum, reindexing, upgrades and a pgAdmin 4 tour in one place

Cons

No coding exercises and only 16 quizzes, so hands-on practice is self-directed
Headline says version 17, but the syllabus tours stop at version 16
No replication or high availability topics, and the title says Part 1

Explanation is very clear, videos are short and all the commands used works perfectly as I tried them in my lab environment.

Edoh Tony Godwin, a student

Listed for all levels, but it assumes basic database concepts plus working knowledge of Windows and Linux.

What you will learn

Understand PostgreSQL Process and Memory Architecture.
Install PostgreSQL on Windows and Linux.
How to Setup Environment Variable on Windows and Linux.
Automating Backup and DBA Maintenance Task
PostgreSQL Configuration Files.
Pg_basebackup (Full & Incremental)
How to Create Database/User/Schema from utility and Psql commands.
How to use PSQL command line interface to connect to PostgreSQL.
CRUD operations on PostgreSQL.
Table Inheritance in PostgreSQL.
Partitioning in PostgreSQL using Table Inheritance.
Copy table from/to PostgreSQL.
How to Create/Move/Drop Tablespace.
Logical (pg dump, pgdumpall), Physical backup (Offline, Online).
Continuous Archiving and PITR.
What is Explain plan and how to calculate cost of query.
Maintenance (Updating planner statistics, Vacuum, Routine Reindex, Cluster).
PostgreSQL Directory Structure.
How to use Pgadmin 4 Interface.
Uninstall PostgreSQL on Windows and Linux.
How to Upgrade PostgreSQL
Journey into Postgresql v13
Postgresql v13 - New Features
Let's Explore Postgresql v15
Postgresql v15- New Features
Postgresql v16- New Features

Course content

21 sections · 118 lectures · 14 hours of video 16 quizzes

1Introduction 1 free preview2 lectures · 1 quiz · 8 min
2PostgreSQL Architecture 1 free preview7 lectures · 1 quiz · 28 min
3Storage Internals 1 free preview3 lectures · 1 quiz · 15 min
4PostgreSQL Installation on Windows & Linux4 lectures · 1 quiz · 26 min
5Database Cluster5 lectures · 1 quiz · 27 min
6PostgreSQL Directory Layout3 lectures · 1 quiz · 15 min
7Configuration Files7 lectures · 1 quiz · 51 min
8Create Objects(Database/User/Schema) and Privileges9 lectures · 1 quiz · 51 min
9Psql Command Line Interface4 lectures · 1 quiz · 34 min
10Working with Pg System Catalog1 lecture · 1 quiz · 10 min
11CRUD Operations in PostgreSQL7 lectures · 1 quiz · 52 min
12Table Inheritance, Table Partitioning and Copy Table in PostgreSQL8 lectures · 1 quiz · 49 min
13Working with Tablespace4 lectures · 1 quiz · 28 min
14Backup, Restore and Automation19 lectures · 1 quiz · 2.4 hours
15Maintenance in PostgreSQL13 lectures · 1 quiz · 1.3 hours
16Introduction to Pgadmin 4 Interface1 lecture · 17 min
17PostgreSQL Upgrade4 lectures · 1 quiz · 1.2 hours
18Uninstall PostgreSQL on Windows & Linux2 lectures · 10 min
19Journey into Postgresql- v13 1 free preview4 lectures · 46 min
20Let's Explore Postgresql -v154 lectures · 49 min
21Tour of Postgresql -v16 1 free preview7 lectures · 47 min

Who it is for

The instructor says it suits

Database Administrators
Accidental DBA's
Developers
Architects and Analyst
Students
Anyone who is curious about PostgreSQL

What you need before you start

Basic Knowledge of Database Concepts
Internet access is required to download PostgreSQL Server
Working Knowledge on Windows and Linux

Course Description

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.

The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.

Topics covered are:

PostgreSQL Process and Memory Architecture
Installation of PostgreSQL on Windows and Linux
Setup PostgreSQL Environment Variables - Windows and Linux
PostgreSQL Storage Internals
Database Directory Layout
PostgreSQL Configuration Files
Cluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)
Createdb/Dropdb, Createuser/Dropuser Utility
Best Practices for User Management.
Create Schema and Schema Search Path
Pgpass File
Psqlrc.conf
Psql Interface Commands
Pg System Catalogs
Working with PostgreSQL Objects
CRUD Operations
MERGE AND MERGE RETURNING
Table Inheritance
Table Partitioning
Table Partitioning with Inheritance
Tablespace in PostgreSQL
Backup's, Continuous Archiving and PITR (Point-in-Time-Recovery)
Incremental Backups using Pg_basebackup.
Wal Summarizer Process
Explain plan and Query Execution Cost
Maintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Log File Maintenance)
Best Practices for Routine Reindexing.
Data Fragmentation
Vacuum, Vacuum Full, Auto Vacuum Dameon
Best Practices for Vacuum Commands.
Automating Backup's and Maintenance Task.
Pgadmin 4
Upgrade PostgreSQL (Pg_Dumpall & Pg_Upgrade Utility)
Uninstall PostgreSQL on Windows and Linux
Journey into Postgresql v13
Postgresql v13 - New Features
Let's Explore Postgresql v15
Postgresql v15 - New Features
Tour of Postgresql v16
Postgresql v16 - New Features

All Levels

Time: 14.3h

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.

Get the Udemy discount

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

Instructor Details

Sadiq Basha

4.6 Rating
7,007 Reviews

Senior Production Database Administrator with 20 years of extensive experience involving Oracle 21c/19c/12c/11g/10g/9i Databases, Oracle 11i/R12 E-Business Suite and SQL server 2012/2016/2019/2022, PostgreSQL, MongoDB, MySQL and Cloud Technologies (AWS/Azure). Experienced in designing, building and administering Oracle clustered server configurations supporting 21c,19c, 12c and 11g Real Application Clusters (RAC) installations on Linux, Solaris and AIX, HP-UX. Expertise in Always-On Availability Groups (AAG) and HA/DR. High availability 12c Golden gate setup using XAG. Database lead in implementing Cloud Solutions using various AWS Services including EC2, VPC, S3, Glacier, Lambda, RDS etc. Sound knowledge in the domain of Identity Management (OIM) Administration.

PostgreSQL Database Administration on Windows/Linux- Part 2 (2025)
4.6 (1,984 Reviews)

- Provider: Udemy
- Time: 8.3h

$64.99

PostgreSQL Database Administration on Win/Linux-Part 3 (PT) (2024)
4.6 (508 Reviews)

- Provider: Udemy
- Time: 8.7h

$19.99

All courses by Sadiq Basha

Reviews

4.6

7,007 ratings on Udemy

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

Write a review

By Gurupreet Bhatia on 9/4/2026

Just started this course, have some knowledge already on PostgreSQL, but based on explanation of architecture, i can give 5 start, Super explanation and representation

By Abhishek Khandelwal on 8/23/2026

A very good course to learn PostgreSql DBA tasks. Good thing is each module contains how to do it in real environment. We can see the video and practice in our environment.

By Rachel A on 8/9/2026

Yes learned a lot and loved the instructor pace of teaching.

By DEVOUCOUX Laurent on 6/1/2026

A l'issue de cette formation, j'ai acquis une bonne compréhension des processus mis en œuvre dans PostgreSQL.

By Rath on 4/3/2026

Training session is excellent. Thanks for giving example & showing one at a time. This makes my double clear. Really, I am very thankful to this trainer.

By Anonymized User on 3/27/2026

Concepts explained very well with demo. Amazing course and above expectations. Highly recommended for DBAs exploring and interested in PostgreSQL DBA roles.

By Mohamed Juma Mwero on 1/26/2026

Well explained, beginner-friendly, excellent balance between theory and hands-on DBA tasks. Easy to follow and very useful. Highly recommended

By S Sajith Kumar on 1/24/2026

It is really hard to come across good DBA courses these days which primarily focuses on stuff like architecture and important internal components. This course is an absolute gem. Sadiq has done a great job, explaining the core DB techniques and operations in a simpler way and the demonstrations were a added bonus. I highly recommend this course to anyone who is looking forward to get upskilled as a DBA in POSTGRESQL.

By MauricioAndresMiret on 12/23/2025

Excellent course for beginners or those who want to learn PostgreSQL without any prior knowledge. The theory and practice are perfectly blended to ensure the concepts are clear. Thank you very much, Sadiq Basha. See you in part 2!

By Mayank Minal on 12/12/2025

I completed the PostgreSQL Database Administration course on Udemy and found it really helpful. The explanations were clear, the examples were practical, and the overall pace made it easy to follow. Great learning experience.

Showing all 10 reviews on CourseDuck

Read all 7,007 reviews on Udemy