Skip to content
Write a review
UdemySqlPaid courseAll LevelsCertificate

PostgreSQL Database Administration on Win/Linux-Part 3 (PT) (Udemy.com)

PostgreSQL Database Administration : Walk-in a Beginner, Walk-Out an Expert (Performance Tuning)

4.6
508 reviews

Created by: Sadiq Basha

Last updated December 2024

icon
What you will learn

  • PostgreSQL Installation from Source Code.
  • Segregation of PostgreSQL Files and Best Practices.
  • Performance tuning PostgreSQL Server Parameters.
  • Query Optimization.
  • Performance Monitoring and Events.
  • Optimizer and Extended Statistics.
  • Error Reporting and logging.
  • PgBadger.
  • Pg_Buffercache.
  • Pg_Prewarm.
  • Internals of Shared Buffers and Clock Sweep Algorithm.

icon
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 Installation from Source Code.

  • Segregation of PostgreSQL Files and Best Practices.

  • Move Pg_Wal and Tempfiles.

  • Performance tuning PostgreSQL Server Parameters.

  • Internals of Shared Buffers and Clock Sweep Algorithm.

  • Autovacuum Tuning.

  • Checkpoint Tuning.

  • Max_Connections.

  • Asynchronous Behaviour.

  • Work_Mem Tuning.

  • Mainteanance_Work_Mem.

  • Autovacuum_Work_Mem.

  • Pg_Stat_Activity.

  • Effective_Cache_Size.

  • Null Value Considerations

  • Partial Indexes.

  • Covering Indexes.

  • Pg_Buffercache Extension.

  • Pg_Prewarm.

  • Query Optimization.

  • Table Access Methods and Joins.

  • Pg_Stat_Bgwriter.

  • Index Optimization.

  • Query Tuning.

  • Performance Monitoring and Events.

  • Optimizer and Extended Statistics.

  • Error Reporting and logging.

  • Pg_Stat_Statements.

  • PgBadger.

  • Server Monitoring.

Read More All Levels All Levels product length iconTime: 8.7h

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.

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.

icon
Instructor Details

Sadiq Basha

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.

Read More

icon
More courses by Sadiq Basha

$74.99

$64.99

All courses by Sadiq Basha

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

All SQL courses

icon
Reviews

4.6

508 ratings on Udemy

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

Write a review

By Sanjay Dharmadhikari on 4/19/2026

The instructor is an expert in Performance tuning and knows the internals of Postgres DB. The style of explanation is engaing and the knowledge gained can be put to practical use.

By Muhammad Khan on 2/11/2026

Very Good introduction and explaination. Please make more videos on other courses with source download features.

By Abhijoy Majumdar on 10/27/2025

Content editing can be improved, lots of grammatical & typographical errors throughout. Else curriculum is comprehensive.

By Ram Kumar Yadav on 5/17/2025

Very nice course , I enhance my knowledge due to this course. A lot of thanks to Mr. Sadiq Basha Sir.

By Ajay Garad on 5/5/2025

I have done PostgreSQL Database Administration Walk-in a Beginner, Walk-Out an Expert (Performance Tuning) , help me to understand the Performance tunning basic concept. Thanks..!

By Arun on 4/1/2025

Awesome Content, Clear explanation, very interactive. The examples and downloadable content is a huge advantage for refresh the knowledge. Great work Man :)

By Mohinder Paul Singh on 3/22/2025

This course is excellent for beginners. The pace of teaching is outstanding, and the explanations are comprehensive, including new version features and changes with examples. It thoroughly explains the topic, not just how to do it but also why. Detailed demos illustrate the underlying processes, enhancing comprehension. Thanks for making this course and looking forward more courses on 'MySQL DBA Administrator' and 'SQL Server Administrator'.

By Anonymized User on 3/13/2025

Sound knowledge by the instructor. Been working with Postgres for a few years, and good to refresh my knowledge. Sample scripts for monitoring will help a lot going forward.

By Swarnavikram Mani on 11/25/2024

Good course , expecting more courses in Postgresql latest versions and more PG tools, also expecting more courses in other DB technologies as well

By Ravi chakra Peddireddy on 10/4/2024

This course is excellent for beginners who want to become Database administrators and very useful for experience candidates who is looking for more knowledge on known topics.

Showing all 10 reviews on CourseDuck

Read all 508 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 : 92 / 100

PostgreSQL Database Administration on Win/Linux-Part 3 (PT)
Visit course on Udemy Write a review
  • Video Duration: icon 8.7h
  • Price: $19.99
  • Provider: icon Udemy
  • Updated: icon December 2024
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com