Database5
PostgreSQL Database Administration
Duration
5 Days
Upcoming Batch
19 October 2026 - 23 October 2026
Batch Options
4 hours & 8 hours
Language
English / Arabic
Course Overview
The PostgreSQL Database Administration course is an extensive training program crafted to empower participants with the expertise needed to effectively manage and oversee PostgreSQL databases. Covering a broad spectrum from foundational PostgreSQL Server concepts to advanced functionalities, including client-server architecture, installation, configuration, and security protocols, this course leaves no stone unturned. Participants will delve into diverse aspects of database administration, including server management, metadata handling, transaction management, concurrency control, and performance optimization. Moreover, they will gain insights into table partitioning, extension utilization, and the implementation of robust security protocols to safeguard data integrity. Furthermore, the course delivers hands-on instruction on monitoring, diagnostics, routine maintenance, backup and recovery procedures, data manipulation, and replication techniques. Emphasizing real-world applications, it incorporates best practices for database upgrades and migrations, such as transitioning from Oracle to PostgreSQL using tools like Ora2PG. Upon completion, learners will emerge equipped with both theoretical knowledge and practical experience, ready to excel as proficient PostgreSQL Database Administrators, ensuring the reliability, integrity, and high performance of database systems.
Target Audience
- Database Administrators (DBAs)
- System Administrators managing database servers
- IT Professionals looking to transition into database roles
- Data Analysts requiring knowledge of database administration for complex querying
- Developers who need to understand the backend database management
- DevOps Engineers involved in CI/CD processes requiring database integration
- Technical Project Managers overseeing database projects
- Software Architects designing systems with PostgreSQL databases
- Data Scientists needing to manage and query large datasets
- Business Intelligence Professionals seeking to understand the database layer
- Database Migration Specialists
Course Content
19 modules · 74 topics01Module 1- Introduction to PostgreSQL Server and Advance Features0 topics
02Module 2- Postgres Client Server Architecture0 topics
03Module 3- Getting Started4 topics
- Installing the PostgreSQL Server
- Setting Environment Variables
- Creating a Cluster
- Running Server
04Module 4- SQL Language8 topics
- Configuring of PostgreSQL Server
- Connection Settings
- Security and Authentication
- Resource Settings
- WAL
- Error Reporting and Logging
- Autovacuum
- Runtime Statistics, etc.
05Module 5- Server Control3 topics
- Postgres hosed based access configuration
- Multiple server installation on one machine
- Remote connection establishment
06Module 6- Client and Tools2 topics
- Introduction To PSQL: Commands and Parameters
- • Using graphical administration tools- pgAdmin 4: 1. Installation 2. Binary path setting 3. Remote server connection
07Module 7- Creating and Managing Databases4 topics
- Object Hierarchy
- Databases and Schemas
- Tablespaces
- • Exploring Databases: 1. Locating the database server's message log 2. Locating the database's system identifier 3. Listing databases on this database server 4. How much disk space does a table use? 5. Which are my biggest tables?
08Module 8- Obtaining Metadata0 topics
09Module 9- Transactions & Concurrency Control0 topics
10Module 10- Database Administration7 topics
- Performing actions on many tables
- Writing a script
- Adding/removing schemas
- Moving objects between schemas
- Adding/removing tablespaces
- Moving objects between tablespaces
- Using materialized views
11Module 11- Table Partitioning2 topics
- Range Partitioning
- List Partitioning
12Module 12- Extensions2 topics
- Accessing objects in other PostgreSQL databases (postgres_fdw, dblink)
- File_fdw, hstore, citext,etc.
13Module 13-Security9 topics
- User Management
- Superuser
- Roles and Users
- Groups and Access Control
- Ownership, Etc.
- Preventing Connections
- Checking secure password
- Auditing Changes
- Encrypting Sensitive data
14Module 14- Monitoring and Diagnosis11 topics
- Real-time viewing using pgAdmin
- Checking whether a user is connected
- Checking which queries are running
- Checking which queries are active or blocked
- Knowing who is blocking a query
- Killing a specific session
- Knowing when a table was last used
- Usage of disk space by temporary data
- Understanding why queries slow down
- Producing a daily summary of log file errors
- Analyzing the real-time performance of your queries
15Module 15- Performance and Concurrency6 topics
- Find and Tune Slow Running Queries
- Collecting regular statistics from pg_stat* views
- Finding out what makes SQL slow
- Speeding up queries without rewriting them
- Discovering why a query is not using an index
- Forcing a query to use an index
16Module 16- Regular Maintenance6 topics
- Controlling automatic database maintenance
- Removing issues that cause bloat
- Identifying and fixing bloated tables and indexes
- Monitoring and tuning vacuum
- Updating Table Statistics
- Vacuuming • Re-indexing
17Module 17- Backup and Recovery5 topics
- Planning backups
- Backup Types
- Logical: 1. Pg_dump 2. Pg_dumpall
- • Physical: 1. Standalone hot physical database backup 2. Hot physical backup and continuous archiving 3. PgBaseBackup
- • Restore: 1. Pg_restore 2. Recovery to a point in time 3. Restore Physical Backup 4. Recovery of a dropped/damaged table 5. Recovery of a dropped/damaged database
18Module 18- Moving Data1 topic
- Exporting/Importing Data To/From A Flat File
19Module 19- Replication and Upgrades4 topics
- • Replication: 1. Replication best practices 2. Streaming Replication 3. Implement Hot Standby 4. Replication Slots 5. Logical Replication o repmgr
- Handling Switchover & Failover
- • Upgrading Best Practices: 1. Upgrading - minor releases 2. Upgrading - major release(pg_upgrade)
- Migration from Oracle to Postgres using Ora2PG (introduction)
Schedule Dates
4 upcoming batchesSession TypePhysical sessions run at our training facility.
| Batch Dates | Duration | Batch Options | Language | Action |
|---|---|---|---|---|
| 19 October 2026 - 23 October 2026 | 5 Days | 4 hours & 8 hours | English / Arabic | |
| 25 January 2027 - 29 January 2027 | 5 Days | 4 hours & 8 hours | English / Arabic | |
| 26 April 2027 - 30 April 2027 | 5 Days | 4 hours & 8 hours | English / Arabic | |
| 26 July 2027 - 30 July 2027 | 5 Days | 4 hours & 8 hours | English / Arabic |
Can’t find a suitable date? Request a schedule that fits your team.
Request More InformationFAQs
What is PostgreSQL Database Administration?
PostgreSQL Database Administration involves managing and maintaining PostgreSQL databases, ensuring they operate efficiently, securely, and reliably. This course provides comprehensive training on these tasks.
Who is the PostgreSQL Database Administration course designed for?
This course is designed for database administrators, IT professionals, developers, and anyone involved in managing PostgreSQL databases or interested in advancing their skills in database administration.
What topics are covered in the PostgreSQL Database Administration course?
The course covers a wide range of topics including PostgreSQL Server basics, advanced features, client-server architecture, installation, configuration, security, server control, metadata management, transactions, concurrency control, performance tuning, table partitioning, extensions, security measures, monitoring, diagnostics, maintenance, backup and recovery, data movement, replication, and database migration.
What are the prerequisites for enrolling in the PostgreSQL Database Administration course?
While there are no strict prerequisites, a basic understanding of databases and SQL would be beneficial for participants. Familiarity with PostgreSQL or other database management systems is helpful but not required.
How is the PostgreSQL Database Administration course delivered?
The course may be delivered through a combination of instructor-led training sessions, hands-on exercises, case studies, and interactive discussions. Depending on the provider, it may be offered in person, virtually, or through self-paced online modules.
What are the benefits of completing the PostgreSQL Database Administration course?
Completing this course equips participants with the skills and knowledge needed to effectively manage PostgreSQL databases. It enhances career prospects, improves job performance, and enables individuals to contribute more effectively to their organization’s database management efforts.
How We Deliver
Flexible Training Options to Meet Your Needs
Choose how you learn — live online, in-classroom, at your workplace, or internationally. CounselTrain delivers certified IT training across the UAE in the format that fits your team.
Select the method that best suits your needs.
Online Instructor-Led Training
Learn from the comfort of your workplace or at home through live virtual sessions led by expert trainers.
Learn moreHighlights
Classroom Training
Participate in interactive, face-to-face training in our top 5-star training facilities in Dubai.
Learn moreHighlights
Onsite Training
Learn a customised curriculum in your workplace to ensure the most impact and team participation.
Learn moreHighlights
Overseas Training
Participate in our international training sessions and improve your abilities with world-class instructors.
Learn moreHighlights
Related Courses
Other courses in the same category that might interest you.
Database9
55246-A: SQL 2016 AlwaysOn High Availability
View Course
Database10
Designing Database Solutions for Microsoft SQL Server 2014 from Microsoft
View Course
Database15