PostgreSQL Database Administration on Windows/Linux- Part 1 [Udemy Coupon Code]

"When you purchase something through one of the links on our site, we may earn an affiliate commission at no additional cost to you."

Limited offer hurry up

PostgreSQL Database Administration on Windows/Linux- Part 1 is a top-rated Udemy course taught by Sadiq Basha — with over 22644+ students enrolled since it launched.

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

Don’t wait! This special offer won’t last long.

Click the button below to Get up to 100% OFF the regular price.

(The discount will be applied automatically at checkout — no code needed!)

Hurry — this discount on PostgreSQL Database Administration on Windows/Linux- Part 1 won’t be around forever. Take action now!

100% off Udemy coupon code

Why enroll in the PostgreSQL Database Administration on Windows/Linux- Part 1 Udemy Course?

  • Udemy gives you access to over 250,000 courses and 85,000 expert instructors worldwide.
  • Courses are led by experienced professionals dedicated to delivering a high-quality learning experience.
  • Many of Udemy’s most popular courses have hundreds of thousands of students enrolled.
  • Udemy offers online coupons, promo codes and voucher for the majority of its courses.

PostgreSQL Database Administration on Windows/Linux- Part 1 Udemy Promotion code

Course Sections
Introduction
Installing PostgreSQL v12 on Windows and Linux
PostgreSQL Architecture
Database Cluster
PostgreSQL Directory Layout
Configuration Files
Create Objects(Database/User/Schema) and Privileges
Using Psql Command Line Interface
Working with Pg System Catalog
CRUD Operations in PostgreSQL
Table Inheritance, Table Partitioning and Copy Table in PostgreSQL
Working with Tablespace
Backup and Restore
Maintenance in PostgreSQL
Introduction to Pgadmin 4 Interface
Uninstall PostgreSQL v12 From Windows and Linux
Bonus Module
Journey into Postgresql- v13
Let’s Explore Postgresql -v15
Tour of Postgresql -v16
Course Description
Requirements
Basic Knowledge of Database Concepts
Internet access is required to download PostgreSQL Server
Working Knowledge on Windows and Linux

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

Tour of Postgresql v16

Postgresql v16 – New Features