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
