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
Curriculum
- 1 Section
- 18 Lessons
- 5 Days
- Course Outline18
- 1.1Module 01: Introduction
- 1.2Module 02: PostgreSQL System Architecture
- 1.3Module 03: Installation
- 1.4Module 04: Database Clusters
- 1.5Module 05: Configuration
- 1.6Module 06: Postgres Data Dictionary
- 1.7Module 07: Introduction to PSQL
- 1.8Module 08: pgAdmin IV
- 1.9Module 09: SQL
- 1.10Module 10: Backup and Recovery & Point-in Time
- 1.11Module 11: Routine Maintenance
- 1.12Module 12: Security
- 1.13Module 13: Moving Data
- 1.14Module 14: Transactions and Concurrency
- 1.15Module 15: Table Partitioning
- 1.16Module 16: Performance Tuning
- 1.17Module 17: PostgreSQL Replication
- 1.18Module 18: Hands-On/Test