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.52 (5154 reviews)
22,101
students
13.5 hours
content
Mar 2024
last update
$74.99
regular price
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
Screenshots
Related Topics
3465764
udemy ID
9/1/2020
course created date
10/18/2020
course indexed date
Bot
course submited by