IIRF Online > Development > Database Design & Development > PostgreSQL > PostgreSQL Database Administration on Windows/Linux- Part 1
PostgreSQL Database Administration on Windows/Linux- Part 1 by Udemy
New courses on PostgreSQL Database Administration: For Replication Check : Part 2 , For Performance Tuning : Part 3
Course Highlights
- 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
Skills you will learn!
Curriculum
2 Topics
PostgreSQL Introduction
PostgreSQL Page Setup
5 Topics
PostgreSQL System Requirement
Installing PostgreSQL v12 on Windows
Setup PostgreSQL Environment Variable on Windows
Installing PostgreSQL v12 on Linux
Setup PostgreSQL Environment Variable on Linux
5 Topics
Process and Memory Architecture
Postmaster Process
Utility Processes
Memory Segments
Physical Files in PostgreSQL
3 Topics
PostgreSQL Cluster (Initdb Start/Stop/Restart/Reload)
PostgreSQL Cluster Demo on Windows
PostgreSQL Cluster Demo on Linux
2 Topics
Database Directory Layout
Base Directory
4 Topics
PostgreSQL.conf
PostgreSQL.Auto.conf
Pg_Ident.conf
Pg_Hba.conf
4 Topics
Create/Drop Database
Create/Drop User
Create/Drop Schema and Search Schema Path
Grant/Revoke Privileges on Database Objects
1 Topic
Psql Commands
1 Topic
Pg_Catalog & Time zones in PostgreSQL
5 Topics
CRUD Introduction
Create Table Data Types Constraints Functions and Operators
Retrieve Data in PostgreSQL
Update Records in a Table
Delete Records in a Table
3 Topics
Table Inheritance
Table Partitioning using Inheritance
Copy Table
4 Topics
Tablespace Introduction
Create Tablespace on Windows and Linux
Move Objects from Tablespace and Drop a Tablespace
Temporary Tablespace in PostgreSQL
13 Topics
Introduction to PostgreSQL Backups
Logical Backups on Windows and Linux
How to Compress and Split Dump Files
Restore Database using Logical Backups through Psql Interface
Restore Database using Logical Backups through Pg_Restore Utility
Offline Backups
Introduction to Online Backups
Setup Continuous Archiving In Windows
Setup Continuous Archiving In Linux
Online Low Level API Backup
Pg_Basebackup Utility
Point-In-Time-Recovery(PITR)
Point-In-Time-Recovery(PITR) - Demo
11 Topics
Introduction to Maintenance
How to Calculate Query Cost and Explain Plan
Updating Planner Statistics\Analyze
Vacuum Freeze
Data Fragmentation
Introduction to Vacuum and Vacuum Full
Transaction ID Wrap Around Failure
How to Vacuum a Database and Remove Data Fragmentation
Routine Re-Indexing
How to Cluster a Table
Auto-Vacuum in PostgreSQL
1 Topic
Pgadmin 4 - Demo
2 Topics
Uninstall PostgreSQL v12 From Windows - Demo
Uninstall PostgreSQL v12 From Linux - Demo
4 Topics
Introduction to PostgreSQL Upgrade
PostgreSQL Upgrade using PG_Dumpall Utility.
Introduction to PG_Upgrade Utility
PostgreSQL Upgrade using PG_Upgrade Utility
4 Topics
Introduction to Postgresql v13
Postgresql v13 - New Features Part 1
Postgresql v13 - New Features Part 2
Postgresql v13 - New Features Part 3
4 Topics
Introduction to Postgresql v15
Postgresql v15 - New Features 1
Postgresql v15 - New Features 2
Postgresql v15 - New Features 3
PostgreSQL Database Administration on Windows/Linux- Part 1
Related PostgreSQL Courses
Thank You!
Your review has been submitted successfully.