PostgreSQL Database Administration on Windows/Linux- Part 1 | Udemy

PostgreSQL Database Administration on Windows/Linux- Part 1 [Update 05/2023]
English | Size: 3.3 GB
Genre: eLearning

PostgreSQL Database Administration : Walk-in a Beginner, Walk-Out an Expert ( Updated with Latest Postgresql V15)

What you’ll learn
Understand PostgreSQL Process and Memory Architecture.
Install PostgreSQL v12 on Windows and Linux.
How to Setup Environment Variable on Windows and Linux.
PostgreSQL Directory Structure.
PostgreSQL Configuration Files.
How to use PSQL command line interface to connect to PostgreSQL.
How to Create Database/User/Schema from utility and Psql commands.
Learn how to use pg system catalogs.
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).
What is Transaction Id Wraparound Failure and Vacuum Freeze.
How to use Pgadmin 4 Interface.
Uninstall PostgreSQL on Windows and Linux.
Bonus Module
Course Extra Documents
Journey into Postgresql v13
Postgresql v13 – New Features
Let’s Explore Postgresql v15
Postgresql v15- New Features

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 v12 – Windows and Linux

Setup PostgreSQL v12 Environment Variables – Windows and Linux

PostgreSQL Page Layout

Database Directory Layout

PostgreSQL Configuration Files

Cluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)

Createdb/Dropdb, Createuser/Dropuser Utility

Create Schema and Schema Search Path

Psql Interface Commands

Pg System Catalogs

Working with PostgreSQL Objects

CRUD Operations

Table Inheritance

Table Partitioning

Tablespace in PostgreSQL

Backup, Continuous Archiving and PITR (Point-in-Time-Recovery)

Explain plan and Query Execution Cost

Maintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Cluster)

Data Fragmentation

Transaction ID wraparound, Vacuum freeze, Auto_Vacuum Demon

Pgadmin 4

Uninstall PostgreSQL v12 on Windows and Linux

Bonus Module

Journey into Postgresql v13

Postgresql v13 – New Features

Let’s Explore Postgresql v15

Postgresql v15 – New Features

Who this course is for:
Database Administrators
Accidental DBA’s
Architects and Analyst
Anyone who is curious about PostgreSQL



If any links die or problem unrar, send request to

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.