PostgreSQL Database Administration on Windows/Linux- Part 1

Add to wishlistAdded to wishlistRemoved from wishlist 0
Last updated on October 7, 2026 5:16 am

PostgreSQL Database Administration on Windows/Linux- Part 1

★★★★★
$3,509.00
$509.00
 in stock
as of November 6, 2026 2:49 am

New courses on PostgreSQL Database Administration: For Replication Check : Part 2 , For Performance Tuning : Part 3

Created by: Sadiq Basha
Senior Production Database Administrator
Rating:4.55 (4999reviews)     21603students enrolled

What Will I 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 v16- New Features

Requirements

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

Target audience

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

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
Write a review

There are no reviews yet.

Be the first to review “PostgreSQL Database Administration on Windows/Linux- Part 1”

Your email address will not be published. Required fields are marked *

Best Sellers News