PostgreSQL Database Administration on Windows/Linux- Part 1

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

4.47 (5205 reviews)

Udemy

platform

English

language

Databases

What you will 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

Course Gallery

PostgreSQL Database Administration on Windows/Linux- Part 1 – Screenshot 1 — Screenshot 1 – PostgreSQL Database Administration on Windows/Linux- Part 1

PostgreSQL Database Administration on Windows/Linux- Part 1 – Screenshot 2 — Screenshot 2 – PostgreSQL Database Administration on Windows/Linux- Part 1

PostgreSQL Database Administration on Windows/Linux- Part 1 – Screenshot 3 — Screenshot 3 – PostgreSQL Database Administration on Windows/Linux- Part 1

PostgreSQL Database Administration on Windows/Linux- Part 1 – Screenshot 4 — Screenshot 4 – PostgreSQL Database Administration on Windows/Linux- Part 1

Charts

Students

Price

Rating & Reviews

Enrollment Distribution

Comidoc Review

Our Verdict

Explore the fundamentals of PostgreSQL administration in this expertly-crafted course, but prepare for occasional challenges stemming from subtitle inconsistencies, demonstration errors, and varying screen visibility. Enhancements to organization and technical specifics would elevate this valuable learning experience further, particularly when addressing real-world scenarios like database replication and upgrades. A worthwhile endeavor for PostgreSQL beginners ready to commit time and energy towards understanding the latest features through v16.

What We Liked

The course provides a thorough explanation of PostgreSQL concepts, going beyond just how-to instructions and clarifying why certain procedures are done.
Demonstrations are clear and informative, with some background details shown to enhance understanding.
Well-structured sessions and demo sessions cater effectively to new learners, providing crisp examples that make the content easily comprehensible.
The course layout covers a wide range of PostgreSQL topics in detail and is further enhanced by additional documents and modules on newer PostgreSQL versions.

Potential Drawbacks

There's some repetition in the content, with a significant portion dedicated to reading PowerPoint slides verbatim.
The course could benefit from improved screen visibility, as small font sizes hinder Windows demo understanding.
Occasionally, there are discrepancies between spoken words and auto-generated subtitles which might cause confusion.
A handful of demonstration errors were noted, and certain topics like logical replication during upgrades could be expanded upon.