The PostgreSQL Database Administration course is a comprehensive guide designed to equip learners with the
skills necessary to manage and maintain PostgreSQL databases effectively. This course covers everything from
the basics of PostgreSQL Server and its advanced features to Client-server architecture, Installation,
Configuration, and Security.
Program Prerequisites
To ensure that you can successfully undertake training in the PostgreSQL Database Administration course,
the following prerequisites are recommended:
▪ Basic familiarity with database concepts and terminology
▪ Knowledge of SQL and experience with any SQL database
▪ Understanding of basic relational database concepts such as tables, indexes, and SQL queries
▪ Familiarity with command-line operations in Linux or Windows
▪ Some experience with server or database management is helpful but not essential
AUDIENCE:
▪ Database Administrators (DBAs)
▪ System Administrators managing database servers
▪ IT Professionals looking to transition into database roles
▪ Developers who need to understand the backend database management
▪ Data Analysts requiring knowledge of database administration for complex querying
▪ Technical Project Managers overseeing database projects
▪ DevOps Engineers involved in CI/CD processes requiring database integration
-
-
Module 01: Introduction
-
Module 02: PostgreSQL System Architecture
-
Module 03: Installation
-
Module 04: Database Clusters
-
Module 05: Configuration
-
Module 06: Postgres Data Dictionary
-
Module 07: Introduction to PSQL
-
Module 08: pgAdmin IV
-
Module 09: SQL
-
Module 10: Backup and Recovery & Point-in Time
-
Module 11: Routine Maintenance
-
Module 12: Security
-
Module 13: Moving Data
-
Module 14: Transactions and Concurrency
-
Module 15: Table Partitioning
-
Module 16: Performance Tuning
-
Module 17: PostgreSQL Replication
-
Module 18: Hands-On/Test
-
