Overview

PS: Focus of this course is on Designing, Building and Managing Aurora PostgreSQL clustersThis course will NOT teach you SQL or Database designWho will benefit from this course?Cloud Architects, & Engineers looking to leverage Aurora PostgreSQLDatabase Administrators interested in diving deep into Aurora PostgresCloud Developers looking to leverage Aurora Postgres for building cloud native applicationsAnyone interested in learning how Aurora Postgres is different from community version of PostgresObjectives By the end of this course you will be able to:Design & deploy highly available, and scalable Aurora PostgreSQL clustersEnsure security of your DB cluster from all perspectives (Network, Data, A & A...)Effectively use the Aurora features such as Global Database, Serverless, Cloning, Cache management etc.Carry out monitoring using CloudWatch metrics, Events, LogsQuery performance tuning using tools such as Performance InsightsPre-RequisitesThis 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.Hands on with AWSExperience with any RDBMSBasic Unix shell scriptingOpen to learnCourse outlineCourse 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 PostgreSQLAurora Architecture deep dive & cluster setupMonitoring features and tools (CloudWatch, Enhanced Monitoring, Performance Insights..)Designing highly available, and scalable clustersCluster configuration managementQuery performance tuningAurora Postgres SecurityEffectively using Aurora features such as Global Database, Serverless, Cache management Aurora Disaster RecoveryBackup RecoveryCluster 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".DisclaimerCourse content developed using publicly available sources such as AWS documentation & blogsOpinions/views expressed in the course are my (Rajeev Sakhuja) own and does not reflect opinions/views of my employer or Amazon/AWS

Skills

Reviews