PostgreSQL Database Administration on Windows/Linux- Part 1

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

Created by: Sadiq Basha
Senior Production Database Administrator

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