Postgres Training

Get trained by experts.

PGSQL-220

Postgresql Administrator training
Formats: Asynchronous
Blended
Online
Part-time
Onsite
Level: Intermediate
Prerequisites:
Recommended Knowledge
Basic Knowledge of Databases
Experience with SQL
Familiarity with PostgreSQL Basics

Formats: We offer our training content in a flexible format to suit your needs. Contact Us if you wish to know if we can accommodate your unique requirements.

Level: We are happy to customize course content to suit your skill level and learning goals. Contact us for a customized learning path.

Postgresql Administrator (PGSQL-220)

This comprehensive course targets IT professionals and database administrators seeking to deepen their knowledge in PostgreSQL administration. Covering a wide range of administrative tasks, the course provides insights into the best practices for database setup, maintenance, performance tuning, security, and troubleshooting. Through hands-on exercises and real-world case studies, participants will learn to ensure the reliability, security, and optimal performance of PostgreSQL databases.

Target Audience:
Affordable Training

We offer self-paced, mentored or
Instructor-led, remote or in-person courses Allow
our experts to guide you in mastering Postgres.

Get a Quote
  • Database administrators and IT professionals responsible for managing PostgreSQL databases.
  • Systems administrators looking to expand their database management skills.
  • IT professionals aiming to transition into database administration roles.
Prerequisites:
  • Basic knowledge of SQL and relational databases.
  • Familiarity with command-line operations and Linux environments.
  • Prior experience with PostgreSQL or other relational databases is beneficial but not mandatory.

Course Outline: PostgreSQL Database Administration

Module 1: PostgreSQL Fundamentals​​​​

  • Introduction to PostgreSQL
  • History and Architecture
  • Key Features and Benefits
  • Installation and Setup
  • Installation on various platforms
  • Initial server configuration
  • Creating and Managing Databases
  • Creating, dropping, and altering databases
  • Managing users and roles
  • The psql Command-Line Interface
  • Basic commands and navigation
  • Common administrative tasks with psql

Module 2: PostgreSQL Configuration

  • Server Configuration Parameters
  • Understanding key configuration parameters
  • Modifying configuration files
  • Restarting the server with changes
  • Client Connection Configuration
  • Configuring client connections
  • Connection pooling
  • Resource Management
  • Memory management
  • Disk space management

Module 3: PostgreSQL Security

  • Security Best Practices
  • Implementing strong passwords
  • Securing network connections
  • Authentication Methods
  • Password authentication
  • Peer authentication
  • LDAP authentication
  • Role-Based Access Control (RBAC)
  • Creating and managing roles
  • Granting and revoking privileges
  • Encryption and Data Masking
  • Encrypting data at rest and in transit
  • Data masking techniques

Module 4: Backup and Recovery

  • Backup Strategies
  • File system backups
  • Logical backups
  • Streaming backups
  • Recovery Scenarios
  • Single-user mode recovery
  • Point-in-Time Recovery (PITR)
  • Backup and Recovery Tools
  • pg_dump, pg_restore
  • WAL archiving

Module 6: Performance Monitoring and Tuning

  • Monitoring PostgreSQL Performance
  • Server statistics
  • Query monitoring
  • Log analysis
  • Query Tuning
  • Analyzing query plans with EXPLAIN
  • Creating and using indexes effectively
  • Resource Limits
  • Setting resource limits for users and databases
  • Vacuuming and Analyzing
  • Understanding vacuuming and analyzing
  • Optimizing vacuuming parameters

Module 7: Advanced Administration

  • Advanced Indexing Techniques
  • Multicolumn indexes
  • Partial indexes
  • Expression indexes
  • Concurrency Control
  • Transaction isolation levels
  • Locking mechanisms
  • PostgreSQL Extensions
  • Installing and using PostgreSQL extensions

Module 8: Troubleshooting and Maintenance

  • Common Troubleshooting Issues
  • Connection problems
  • Performance bottlenecks
  • Deadlocks
  • Log Analysis
  • Interpreting server logs
  • Maintenance Tasks
  • Regular maintenance procedures

Learning Outcomes:

Upon completion, participants will have a solid understanding of PostgreSQL administration, including the ability to configure, secure, and optimize PostgreSQL servers, manage data integrity and replication, and troubleshoot common issues. They will be well-equipped to maintain the performance and reliability of PostgreSQL databases in a production environment.

This course outline aims to provide PostgreSQL administrators with the knowledge and skills necessary to effectively manage and optimize PostgreSQL databases, ensuring high availability, security, and performance.

Contact Us

Please contact us for any queries via phone or our contact form. We will be happy to answer your questions.

3 Appian Place,373 Kent Ave
Ferndale,
2194 South Africa
Tel: +2711-781 8014 (Johannesburg)
  +2721-020-0111 (Cape Town)
ZA

Contact Form

Jumping Bean Contact Form!

Contact Form