❗The content presented here is sourced directly from Udemy platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [July 18th, 2023]
This course, Amazon Aurora PostgreSQL from A to Z, is designed to help Cloud Architects, Engineers, Database Administrators, Cloud Developers, and anyone interested in learning how Aurora Postgres is different from the community version of Postgres. It will cover topics such as designing and deploying highly available and scalable Aurora PostgreSQL clusters, ensuring security of the DB cluster, effectively using Aurora features such as Global Database, Serverless, Cloning, Cache management, monitoring using CloudWatch metrics, Events, Logs, and query performance tuning. Prerequisites for the course include experience with any RDBMS, basic Unix shell scripting, and an open mind to learn. The course is divided into multiple sections, each starting with a lesson titled "Section Objectives". Upon completion of the course, students will be able to design and deploy highly available and scalable Aurora PostgreSQL clusters, ensure security of the DB cluster, effectively use Aurora features, carry out monitoring, and query performance tuning.
Course Syllabus
Introduction
PostgreSQL Fundamentals
Amazon RDS & Aurora
Setup an Aurora DB Cluster
Amazon RDS Aurora Architecture
Aurora Metrics, Logging & Events
Aurora Scaling & High Availability
Cluster Configuration Management & Extensions
Query Performance Analysis
PostgreSQL commands - Vacuum, Analyze, Explain
Query performance tuning for waits
RDS Aurora Security
Aurora Global Database
Aurora Backup & Recovery
Aurora Cloning
Aurora Serverless v2
Cluster Maintenance