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
Target Audience and Job Roles
▪ 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
-
-
Lesson 1: Introduction
-
Lesson 2: PostgreSQL System Architecture
-
Lesson 3: Installation
-
Lesson 4: Database Clusters
-
Lesson 5: Configuration
-
Lesson 6: Postgres Data Dictionary
-
Lesson 7: Introduction to PSQL
-
Lesson 8: pgAdmin IV
-
Lesson 9: SQL
-
Lesson 10: Backup and Recovery & Point-in Time
-
Lesson 11: Routine Maintenance
-
Lesson 12: Security
-
Lesson 13: Moving Data
-
Lesson 14: Transactions and Concurrency
-
Lesson 15: Table Partitioning
-
Lesson 16: PostgreSQL Replication
-
Lesson 17: PostgreSQL Replication
-
Lesson 18: Hands-On/Test
-