Skip to main content

Amazon RDS for PostgreSQL

Executive Summary

This course teaches developers how to manage PostgreSQL databases in Amazon RDS. Learn to create and configure database instances, migrate data, optimize performance, and implement security. You’ll also master backup and recovery, monitoring, and troubleshooting. Ideal for professionals deploying scalable, cloud-based PostgreSQL systems in AWS.

Programming Professionals Collaborating

Description

This comprehensive course is tailored for computer programming professionals aiming to deepen their expertise in PostgreSQL administration, with a particular focus on managing databases within an Amazon RDS environment. It provides thorough coverage of foundational topics such as PostgreSQL and Amazon RDS basics, creating and configuring database servers, and managing database parameters. The curriculum then advances into more complex areas including data migration, system configuration, ongoing maintenance, and ensuring database security. Students will also gain practical insights into performance tuning, backup and restore procedures, and troubleshooting common issues. The course emphasizes best practices for security, performance optimization, backup and recovery strategies, system monitoring, regular maintenance, and cost management. Ideal for those looking to strengthen their PostgreSQL administration capabilities, this course equips learners with both the theoretical knowledge and practical skills needed to manage production-grade PostgreSQL deployments effectively.

Objectives

  • Understand the key features and architecture of PostgreSQL and Amazon RDS for PostgreSQL.
  • Learn how to create a database server and manage different types of instances.
  • Master the process of creating a database, setting parameters, and choosing options.
  • Gain proficiency in exporting and importing data to and from Amazon RDS and S3.
  • Learn how to configure and maintain PostgreSQL databases, including managed patches, upgrades, and instance maintenance.
  • Understand and implement security measures, including data encryption in transit and at rest.
  • Learn how to tune performance and manage storage types and auto-scaling.
  • Master backup and restore procedures, including snapshots, automated and manual backups, and point-in-time recovery.

Duration

21 hours of intensive training with live instruction delivered over three to five days to accommodate varied scheduling needs. 

Request Information

Course Outline

Introduction to PostgreSQL Administration
  • Overview of PostgreSQL
  • PostgreSQL Architecture
  • Key Features of PostgreSQL
  • Key Features of Amazon RDS for PostgreSQL
Create a Database Server
  • What is an Amazon RDS Instance?
  • Production vs. Development Instances
  • Standalone Instance
  • Clustered Instances
  • Multi-AZ Deployments
Create a Database
  • Creating a Database
  • Database Parameters
  • Database Options
Export/Import Data
  • Migrate to Amazon RDS
  • Export Data to S3
  • Import Data from S3
Configuration and Maintenance
  • Difference between self-managed and managed databases
  • No usual configuration files such as postgresql.conf
  • Managed Patches and Upgrades
  • Parameter Groups
  • Configure PgAudit
  • Instance Maintenance
  • Database Maintenance
Security
  • Data Encryption in Transit
  • Explore encryption at REST and in transit
  • Basic SSL setup
  • Transparent Data Encryption
Performance Tuning
  • Storage Auto Scaling
  • RDS storage types (Gp2 vs Gp3)
Backup and Restore
  • Snapshots
  • Automated Backups
  • Manual Backups
  • Continuous Backups
  • Point-in-Time Recovery
  • Restore a Database from a Snapshot
  • Restore a Database from S3
  • Restore a Database from Another Computer
Monitoring and Logging
  • CloudWatch
  • Enhanced Monitoring
  • Performance Insights
  • Log Exports
  • PgAudit
Connecting to PostgreSQL Database
  • psql Command Line
  • pgAdmin
  • DBeaver
  • Enabling Remote Access
  • Connecting to RDS from EC2
Troubleshooting
  • Common Connectivity Issues
  • Performance Issues
  • Storage-Related Problems
  • Backup and Restore Failures
  • Replication and Read Replica Issues
  • Authentication and Authorization Errors
  • RDS Instance Availability and Failures
Best Practices
  • Security
  • Performance
  • Backup and Recovery
  • Monitoring
  • Maintenance
  • High Availability and Disaster Recovery
  • Cost Management
  • Schema Management and Version Control

Prerequisites

  • No prior experience with PostgreSQL or AWS is necessary.
  • Students should have a basic understanding of SQL, relational databases, and cloud computing.

Training Materials

All students receive comprehensive courseware covering all topics in the course. Courseware is distributed via GitHub in the form of documentation and extensive code samples. Students practice the topics covered through challenging hands-on lab exercises. Students will need a free, personal GitHub account to access the courseware. Students are provided a cloud-based environment for all demonstrations and lab exercises.