Amazon Aurora PostgreSQL from A to Z

Amazon Aurora PostgreSQL from A to Z

What you’ll learn

Fundamentals of PostgreSQL
RDS Aurora Architecture & Internals
Build & Manage Aurora PostgreSQL Database
Designing a Aurora PostgreSQL cluster
Best practices for Aurora PostgreSQL
Effectively use features such as Global DB, Cloning, Serverless, CCM …

Requirements

Experience with any RDBMS
Working knowledge of AWS cloud
Basic Unix shell scripting
Open to dive deep & learn

Description

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

Overview

Section 1: Introduction

Lecture 1 Your instructor

Lecture 2 Get the MOST out of this course

Section 2: PostgreSQL Fundamentals

Lecture 3 Section Objectives

Lecture 4 Part-1 : Storage, Processes & Query processing

Lecture 5 Part-2 : WAL, Checkpointing, Archiver & Background processes

Lecture 6 Part-3 : High availability, Standby servers & Replication

Lecture 7 Part-4 : Scaling, Read vs Write scaling

Lecture 8 Part-5 : Tools, Config, Logs & Catalog

Section 3: Amazon RDS & Aurora

Lecture 9 Section Objectives

Lecture 10 AWS PostgreSQL options

Lecture 11 RDS Vs Aurora PostgreSQL

Lecture 12 Aurora specific features

Lecture 13 Aurora – PostgreSQL version & releases

Lecture 14 Deciding between RDS & Aurora PostgreSQL

Section 4: Setup an Aurora DB Cluster

Lecture 15 Section Objectives

Lecture 16 Development environment & project repository

Lecture 17 Hands on : Test VPC Setup

Lecture 18 Hands on : Aurora DB Cluster Setup

Lecture 19 Hands on : Bastion Host Setup

Lecture 20 Hands on : Windows Bastion Host Setup

Lecture 21 AWS CLI & Utility Scripts

Lecture 22 Hands on : Test Setup Cleanup

Section 5: Amazon RDS Aurora Architecture

Lecture 23 Section Objectives

Lecture 24 Aurora Storage Architecture

Lecture 25 Database Instance Classes & I/O performance

Lecture 26 Database Instance Right Sizing

Lecture 27 Primary instance, Replicas & Endpoints

Lecture 28 Hand on : Read Replica

Lecture 29 Aurora Reads & Writes

Lecture 30 AZ +1 Fault Tolerance Model

Lecture 31 Aurora Standby Replication

Lecture 32 Hands on : Replication Lag

Section 6: Aurora Metrics, Logging & Events

Lecture 33 Section Objectives

Lecture 34 Baseline, KPI & Metric Monitoring

Lecture 35 Introduction to Pgbench tool

Lecture 36 RDS CloudWatch Metrics & Dimensions

Lecture 37 RDS Aurora Metrics

Lecture 38 Hands on : Aurora CloudWatch Metrics

Lecture 39 RDS Enhanced Metrics

Lecture 40 Hands on : Enhanced Metrics

Lecture 41 RDS Database Logs

Lecture 42 PostgreSQL Log files & configuration

Lecture 43 Hands on : Checkout PostgreSQL Logs

Lecture 44 RDS Events

Lecture 45 Hands on : RDS Event retention to CloudWatch

Section 7: Aurora Scaling & High Availability

Lecture 46 Section Objectives

Lecture 47 Aurora Storage Scaling

Lecture 48 Aurora Compute Scaling

Lecture 49 Hands on : Vertical Scaling

Lecture 50 Hands on : Auto Scaling

Lecture 51 Aurora Failover

Lecture 52 Hands on : Aurora failover

Lecture 53 Aurora Cluster Cache Management

Section 8: Cluster Configuration Management & Extensions

Lecture 54 Section Objectives

Lecture 55 Cluster & DB Parameter Groups

Lecture 56 Hands on : Parameter Groups

Lecture 57 RDS Option Groups & Extensions

Lecture 58 PostgreSQL Extensions

Lecture 59 Aurora Supported Extensions

Lecture 60 Hands on : Address standardizer extension

Lecture 61 Hands on : Using the S3 extension

Section 9: Query Performance Analysis

Lecture 62 Section Objectives

Lecture 63 PostgreSQL Stats Subsystem

Lecture 64 PostgreSQL Stats Functions

Lecture 65 Hands on : Stats views and functions

Lecture 66 PostgreSQL Wait events and Locks

Lecture 67 Hands on : Wait & Lock events

Lecture 68 pg_stat_statements extension

Lecture 69 Hands on : pg_stat_statements extension

Section 10: PostgreSQL commands – Vacuum, Analyze, Explain

Lecture 70 Section Objectives

Lecture 71 PostgreSQL Query Processing, Plan, Paths, Optimizer

Lecture 72 Explain command

Lecture 73 Hands on : Explain command

Lecture 74 PostgreSQL Analyze command

Lecture 75 Multi Version Concurrency Control (MVCC)

Lecture 76 Vacuuming – Addressing table bloat

Lecture 77 Vacuum – Addressing the wraparound

Lecture 78 Vacuum command

Lecture 79 Hands on : vacuum command

Lecture 80 Auto vacuuming

Section 11: Query performance tuning for waits

Lecture 81 Section Objectives

Lecture 82 Performance Insights Overview

Lecture 83 Performance Insights Counters

Lecture 84 DB Load & Active Sessions

Lecture 85 Hands on : Performance Insights dashboard

Lecture 86 IO Wait Events

Lecture 87 Buffer Cache Tuning

Lecture 88 Hand on – Performance Insights

Lecture 89 Aurora IO XactSync Event

Lecture 90 Hands on : IO XactSync Event

Lecture 91 IO Events : DataFileRead, BufFileRead, BufFileWrite

Lecture 92 Hands on : BufFileRead & BufFileWrite IO Events

Lecture 93 Lightweight Lock Waits

Lecture 94 Heavyweight Lock Waits

Lecture 95 Hands on : Lock transactionid

Lecture 96 Client & Timeout wait events

Lecture 97 Hands on : Timeout wait event

Section 12: RDS Aurora Security

Lecture 98 Section Objectives

Lecture 99 Data Encryption Support

Lecture 100 Hands on : Force TLS/SSL connection

Lecture 101 Database Network Security

Lecture 102 RDS Aurora Access & Authorization Control

Lecture 103 Password Authentication

Lecture 104 Hands on : Password Authentication

Lecture 105 Aurora IAM Authentication

Lecture 106 Hands on : IAM Authentication

Lecture 107 Introduction to Kerberos and AWS Managed AD

Lecture 108 Hands on : Setup AWS Managed AD

Lecture 109 RDS Aurora Kerberos Authentication

Lecture 110 Hands on : Setup Aurora PostgreSQL for Kerberos

Lecture 111 PostgreSQL Pgaudit Extension

Lecture 112 Hands on : pgAudit extension

Section 13: Aurora Global Database

Lecture 113 Section Objectives

Lecture 114 Aurora Global Database

Lecture 115 Hands on : Setup Aurora global DB cluster

Lecture 116 Managing the Aurora global DB

Lecture 117 Hands on : Planned global DB failover

Lecture 118 Aurora global DB monitoring

Lecture 119 Disaster Recovery (DR) & Managed RPO

Lecture 120 DR & Aurora Endpoint management

Lecture 121 Hands on : Endpoint management

Lecture 122 Hands on : Aurora global DB cleanup

Section 14: Aurora Backup & Recovery

Lecture 123 Section Objectives

Lecture 124 PostgreSQL backup and restore

Lecture 125 Hands on : PostgreSQL pg_dump

Lecture 126 Hands on : PostgreSQL pg_restore

Lecture 127 Aurora Automatic & Manual backups

Lecture 128 Hands on : Restoring from a snapshot

Lecture 129 Hands on : Point in time recovery (PITR)

Lecture 130 Backup Encryption, Copying and Sharing

Lecture 131 Hands on : Snapshot export to S3

Lecture 132 Backup Costs and Monitoring

Lecture 133 AWS Backup Service

Section 15: Aurora Cloning

Lecture 134 Section Objectives

Lecture 135 Aurora Cloning & Copy on write protocol

Lecture 136 Hands on : Create an Aurora Clone

Lecture 137 Cross account cloning

Section 16: Aurora Serverless v2

Lecture 138 Section Objectives

Lecture 139 Aurora Serverless v2 DB Instance

Lecture 140 Hands On : Build a Aurora cluster with Serverless v2

Lecture 141 High availability considerations

Lecture 142 Serverless v2 DB instance capacity scaling

Lecture 143 Monitoring considerations

Section 17: Cluster Maintenance

Lecture 144 RDS and PostgreSQL versioning

Lecture 145 Aurora PostgreSQL upgrade

Lecture 146 Minor version upgrade

Lecture 147 Major version upgrade

Lecture 148 Hands on – PostgreSQL native replication

Lecture 149 Aurora PostgreSQL releases & deprecation

AWS Cloud Architects,Application Architects & Developers,DBA’s intending to develop AWS/RDS skills,Anyone interested in learning PostgreSQL and Aurora

Course Information:

Udemy | English | 17h 7m | 4.38 GB
Created by: Rajeev Sakhuja

You Can See More Courses in the IT & Software >> Greetings from CourseDown.com