AWS Flash - Amazon Aurora PostgreSQL for Developers

The course is designed to help developers understand and work with Amazon Aurora, a highly scalable and durable PostgreSQL-compatible database service. The course starts by introducing relational databases and the Structured Query Language (SQL), ensuring a solid foundation for understanding PostgreSQL and its capabilities.

Participants will then explore the architecture of Amazon Aurora, learning how it builds upon the strengths of PostgreSQL to deliver enhanced performance, reliability, and scalability. The course covers techniques for optimizing queries and transactions, enabling developers to write efficient code that can handle high-volume workloads.

Additionally, the course emphasizes the importance of monitoring and troubleshooting, teaching participants how to identify and address performance issues in their applications. By the end of the course, developers will be well-prepared to leverage the power of Amazon Aurora PostgreSQL to build robust, scalable, and high-performing applications.

• Course level: 200 - Intermediate
• Duration: 1 day

Activities

This course includes presentations, demonstrations and assessments.

Course objectives

In this course, you will:

• Know how to query a PostgreSQL Database using SQL.
• Understand how to optimize queries and transactions.
• Understand Amazon Aurora specific architecture.
• Know how to identify issues with existing queries with monitoring.

Intended audience

This course is intended for:

• Developers writing queries against Amazon Aurora PostgreSQL databases

Prerequisites

We recommend that attendees of this course have:

• Cloud Practitioner level knowledge of AWS

Course outline

Module 1: Relational Databases and structured query language

• When and why use a Relational Database concepts
• Structured query language (SQL)
• Practical SQL

Module 2: Advanced SQL/PostgreSQL

• SQL Advanced
• Transactions

Module 3: Amazon Aurora PostgreSQL

• PostgreSQL introduction
• Concurrency in PostgreSQL
• Amazon Aurora architecture
• Focus on consistency
• Amazon Aurora developer features

Module 4: Understanding query processing in PostgreSQL

• PostgreSQL Optimizer
• Query Plan Analysis

Module 5: Monitoring and Operations

• Monitoring
• Troubleshooting and operations

Module 6: Optimizing Best Practices

• Connection pooling - RDS Proxy
• Avoid long running transactions
• Use TOAST responsibly
• Partition big tables
• Distribute read activity
• Leverage indexes