Amazon Aurora PostgreSQL from A to Z
Learn to design & manage Amazon Aurora PostgreSQL DB Clusters
Lo que serás capaz de hacer
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: Design & deploy highly available, and scalable Aurora PostgreSQL clusters Ensure 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, Logs 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. Hands on with AWS Experience with any RDBMS Basic Unix shell scripting 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
- 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 ...
Temario
UNIDAD 1 - Introduction · 2 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Your instructor
- Get the MOST out of this course
UNIDAD 2 - PostgreSQL Fundamentals · 6 leccionesUNIDAD 2 - PostgreSQL Fundamentals
UNIDAD 2 - PostgreSQL Fundamentals
- Section Objectives
- Part-1 : Storage, Processes & Query processing
- Part-2 : WAL, Checkpointing, Archiver & Background processes
- Part-3 : High availability, Standby servers & Replication
- Part-4 : Scaling, Read vs Write scaling
- Part-5 : Tools, Config, Logs & Catalog
UNIDAD 3 - Amazon RDS & Aurora · 6 leccionesUNIDAD 3 - Amazon RDS & Aurora
UNIDAD 3 - Amazon RDS & Aurora
- Section Objectives
- AWS PostgreSQL options
- RDS Vs Aurora PostgreSQL
- Aurora specific features
- Aurora - PostgreSQL version & releases
- Deciding between RDS & Aurora PostgreSQL
UNIDAD 4 - Setup an Aurora DB Cluster · 8 leccionesUNIDAD 4 - Setup an Aurora DB Cluster
UNIDAD 4 - Setup an Aurora DB Cluster
- Section Objectives
- Development environment & project repository
- Hands on : Test VPC Setup
- Hands on : Aurora DB Cluster Setup
- Hands on : Bastion Host Setup
- Hands on : Windows Bastion Host Setup
- AWS CLI & Utility Scripts
- Hands on : Test Setup Cleanup
UNIDAD 5 - Amazon RDS Aurora Architecture · 10 leccionesUNIDAD 5 - Amazon RDS Aurora Architecture
UNIDAD 5 - Amazon RDS Aurora Architecture
- Section Objectives
- Aurora Storage Architecture
- Database Instance Classes & I/O performance
- Database Instance Right Sizing
- Primary instance, Replicas & Endpoints
- Hand on : Read Replica
- Aurora Reads & Writes
- AZ +1 Fault Tolerance Model
- Aurora Standby Replication
- Hands on : Replication Lag
UNIDAD 6 - Aurora Metrics, Logging & Events · 13 leccionesUNIDAD 6 - Aurora Metrics, Logging & Events
UNIDAD 6 - Aurora Metrics, Logging & Events
- Section Objectives
- Baseline, KPI & Metric Monitoring
- Introduction to Pgbench tool
- RDS CloudWatch Metrics & Dimensions
- RDS Aurora Metrics
- Hands on : Aurora CloudWatch Metrics
- RDS Enhanced Metrics
- Hands on : Enhanced Metrics
- RDS Database Logs
- PostgreSQL Log files & configuration
- Hands on : Checkout PostgreSQL Logs
- RDS Events
- Hands on : RDS Event retention to CloudWatch
UNIDAD 7 - Aurora Scaling & High Availability · 8 leccionesUNIDAD 7 - Aurora Scaling & High Availability
UNIDAD 7 - Aurora Scaling & High Availability
- Section Objectives
- Aurora Storage Scaling
- Aurora Compute Scaling
- Hands on : Vertical Scaling
- Hands on : Auto Scaling
- Aurora Failover
- Hands on : Aurora failover
- Aurora Cluster Cache Management
UNIDAD 8 - Cluster Configuration Management & Extensions · 8 leccionesUNIDAD 8 - Cluster Configuration Management & Extensions
UNIDAD 8 - Cluster Configuration Management & Extensions
- Section Objectives
- Cluster & DB Parameter Groups
- Hands on : Parameter Groups
- RDS Option Groups & Extensions
- PostgreSQL Extensions
- Aurora Supported Extensions
- Hands on : Address standardizer extension
- Hands on : Using the S3 extension
UNIDAD 9 - Query Performance Analysis · 8 leccionesUNIDAD 9 - Query Performance Analysis
UNIDAD 9 - Query Performance Analysis
- Section Objectives
- PostgreSQL Stats Subsystem
- PostgreSQL Stats Functions
- Hands on : Stats views and functions
- PostgreSQL Wait events and Locks
- Hands on : Wait & Lock events
- pg_stat_statements extension
- Hands on : pg_stat_statements extension
UNIDAD 10 - PostgreSQL commands - Vacuum, Analyze, Explain · 11 leccionesUNIDAD 10 - PostgreSQL commands - Vacuum, Analyze, Explain
UNIDAD 10 - PostgreSQL commands - Vacuum, Analyze, Explain
- Section Objectives
- PostgreSQL Query Processing, Plan, Paths, Optimizer
- Explain command
- Hands on : Explain command
- PostgreSQL Analyze command
- Multi Version Concurrency Control (MVCC)
- Vacuuming - Addressing table bloat
- Vacuum - Addressing the wraparound
- Vacuum command
- Hands on : vacuum command
- Auto vacuuming
UNIDAD 11 - Query performance tuning for waits · 17 leccionesUNIDAD 11 - Query performance tuning for waits
UNIDAD 11 - Query performance tuning for waits
- Section Objectives
- Performance Insights Overview
- Performance Insights Counters
- DB Load & Active Sessions
- Hands on : Performance Insights dashboard
- IO Wait Events
- Buffer Cache Tuning
- Hand on - Performance Insights
- Aurora IO XactSync Event
- Hands on : IO XactSync Event
- IO Events : DataFileRead, BufFileRead, BufFileWrite
- Hands on : BufFileRead & BufFileWrite IO Events
- Lightweight Lock Waits
- Heavyweight Lock Waits
- Hands on : Lock transactionid
- Client & Timeout wait events
- Hands on : Timeout wait event
UNIDAD 12 - RDS Aurora Security · 15 leccionesUNIDAD 12 - RDS Aurora Security
UNIDAD 12 - RDS Aurora Security
- Section Objectives
- Data Encryption Support
- Hands on : Force TLS/SSL connection
- Database Network Security
- RDS Aurora Access & Authorization Control
- Password Authentication
- Hands on : Password Authentication
- Aurora IAM Authentication
- Hands on : IAM Authentication
- Introduction to Kerberos and AWS Managed AD
- Hands on : Setup AWS Managed AD
- RDS Aurora Kerberos Authentication
- Hands on : Setup Aurora PostgreSQL for Kerberos
- PostgreSQL Pgaudit Extension
- Hands on : pgAudit extension
UNIDAD 13 - Aurora Global Database · 10 leccionesUNIDAD 13 - Aurora Global Database
UNIDAD 13 - Aurora Global Database
- Section Objectives
- Aurora Global Database
- Hands on : Setup Aurora global DB cluster
- Managing the Aurora global DB
- Hands on : Planned global DB failover
- Aurora global DB monitoring
- Disaster Recovery (DR) & Managed RPO
- DR & Aurora Endpoint management
- Hands on : Endpoint management
- Hands on : Aurora global DB cleanup
UNIDAD 14 - Aurora Backup & Recovery · 11 leccionesUNIDAD 14 - Aurora Backup & Recovery
UNIDAD 14 - Aurora Backup & Recovery
- Section Objectives
- PostgreSQL backup and restore
- Hands on : PostgreSQL pg_dump
- Hands on : PostgreSQL pg_restore
- Aurora Automatic & Manual backups
- Hands on : Restoring from a snapshot
- Hands on : Point in time recovery (PITR)
- Backup Encryption, Copying and Sharing
- Hands on : Snapshot export to S3
- Backup Costs and Monitoring
- AWS Backup Service
UNIDAD 15 - Aurora Cloning · 4 leccionesUNIDAD 15 - Aurora Cloning
UNIDAD 15 - Aurora Cloning
- Section Objectives
- Aurora Cloning & Copy on write protocol
- Hands on : Create an Aurora Clone
- Cross account cloning
UNIDAD 16 - Aurora Serverless v2 · 6 leccionesUNIDAD 16 - Aurora Serverless v2
UNIDAD 16 - Aurora Serverless v2
- Section Objectives
- Aurora Serverless v2 DB Instance
- Hands On : Build a Aurora cluster with Serverless v2
- High availability considerations
- Serverless v2 DB instance capacity scaling
- Monitoring considerations
UNIDAD 17 - Cluster Maintenance · 6 leccionesUNIDAD 17 - Cluster Maintenance
UNIDAD 17 - Cluster Maintenance
- RDS and PostgreSQL versioning
- Aurora PostgreSQL upgrade
- Minor version upgrade
- Major version upgrade
- Hands on - PostgreSQL native replication
- Aurora PostgreSQL releases & deprecation
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
17 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
Cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Rajeev Sakhuja.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 17 unidades · 149 lecciones · 60 h
- 12 meses de acceso
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Rajeev Sakhuja; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.


