Amazon Aurora PostgreSQL from A to Z

PS:

• Focus of this course is on Designing, Building and Managing Aurora PostgreSQL clusters

• This course will NOT teach you SQL or Database design

Who will benefit from this course?

• Cloud Architects, & Engineers looking to leverage Aurora PostgreSQL

• Database Administrators interested in diving deep into Aurora Postgres

• Cloud Developers looking to leverage Aurora Postgres for building cloud native applications

• Anyone interested in learning how Aurora Postgres is different from community version of Postgres

Objectives

By the end of this course you will be able to:

1. Design & deploy highly available, and scalable Aurora PostgreSQL clusters

2. Ensure security of your DB cluster from all perspectives (Network, Data, A&A ...)

3. Effectively use the Aurora features such as Global Database, Serverless, Cloning, Cache management etc.

4. Carry out monitoring using CloudWatch metrics, Events, Logs

5. Query performance tuning using tools such as Performance Insights

Pre-Requisites

This course is intended for anyone who is interested in using AWS Aurora PostgreSQL database for their cloud applications. If you are new to PostgreSQL then no worries as the course starts with the fundamentals of PostgreSQL.

1. Hands on with AWS

2. Experience with any RDBMS

3. Basic Unix shell scripting

4. Open to learn

Course outline

Course is divided into multiple sections. Each section starts with a lesson titled "Section Objectives". To gain a better understanding of the topics covered in the course, please check out the first lesson (preview) in sections of your interest.

• Fundamentals of PostgreSQL

• Aurora Architecture deep dive & cluster setup

• Monitoring features and tools (CloudWatch, Enhanced Monitoring, Performance Insights ..)

• Designing highly available, and scalable clusters

• Cluster configuration management

• Query performance tuning

• Aurora Postgres Security

• Effectively using Aurora features such as Global Database, Serverless, Cache management

• Aurora Disaster Recovery

• Backup Recovery

• Cluster management tasks such as vaccuming, analyze, explain etc.

Why I built this course?

Aurora is complex and architecturally very different from the databases available in the market. When I started to learn it, the biggest challenge was the non availability of Aurora specific information. The only source of information is the Amazon Aurora documentation website which in my humble opinion is not the most effective way to learn. It took me quite sometime to wrap my head around Aurora's architecture and features; the tutorials in the documentation involve manual steps, mostly on the console, as a result they are not easy to follow. Long story short, for folks new to Aurora (& Postgres) learning Aurora can be daunting.

Based on my personal experience with learning Aurora Postgres, I decided to put together this course to help others get up to speed with Aurora in minimum possible time. So if I have to describe in one line, why I built this course  - "It is to accelerate students learning".

Disclaimer

• Course content developed using publicly available sources such as AWS documentation & blogs

• Opinions/views expressed in the course are my (Rajeev Sakhuja) own and does not reflect opinions/views of my employer or Amazon/AWS