PostgreSQL on AWS Aurora

Inquire now

PostgreSQL on AWS Aurora is a practical, hands-on training program designed to help IT professionals develop the skills needed to deploy, administer, secure, and optimize PostgreSQL databases using Amazon Aurora. The course covers essential database administration concepts, Aurora architecture, configuration, security, backup and recovery, monitoring, performance optimization, high availability, and scalability. Participants will gain practical experience managing PostgreSQL workloads in the AWS cloud and learn how to build reliable, secure, and high-performing database environments for modern applications.

Course Overview:

PostgreSQL on AWS Aurora is a comprehensive, hands-on training program designed to help participants build practical skills in deploying, managing, securing, and optimizing PostgreSQL databases on Amazon Aurora. The course begins with an introduction to AWS, VPCs, security groups, Amazon RDS, and Aurora architecture before progressing into PostgreSQL SQL fundamentals and advanced database capabilities.

Participants will learn how to create and configure Aurora PostgreSQL DB clusters, manage connections and storage, migrate data, and work with SQL features such as joins, aggregate functions, views, triggers, transactions, foreign keys, window functions, and inheritance. The course then explores advanced database administration topics including indexing, transaction isolation, concurrency, locking, deadlocks, query execution plans, and performance optimization.

The program also provides practical knowledge of Aurora security, high availability, replication, scaling, backups, snapshots, point-in-time recovery, monitoring, and failover. Participants will work with Aurora replicas, parameter groups, Performance Insights, database activity streams, logging, execution plan management, and troubleshooting techniques.

By the end of the course, participants will be able to apply PostgreSQL and AWS Aurora best practices to build and maintain secure, reliable, scalable, and high-performing cloud database environments for modern applications.

 

Target Audience:

This course is designed for:

  • Database Administrators (DBAs)
  • PostgreSQL Database Administrators
  • PostgreSQL Developers
  • AWS Cloud Engineers
  • Cloud Database Engineers
  • Database Engineers
  • DevOps Engineers
  • System Administrators
  • Software Developers working with PostgreSQL databases
  • Data Engineers
  • Cloud Architects
  • Solutions Architects
  • IT Professionals responsible for database deployment, performance, security, or cloud infrastructure

 

Pre-requisites:

Participants should have:

  • Working knowledge of SQL and C programming.
  • Basic understanding of database concepts and relational databases.
  • Basic system administration experience with Unix/Linux or Windows.
  • Familiarity with general cloud or AWS concepts is helpful but not required.

 

Course Duration:

  • 21 hours – 3 days

 

Course Content:

Day 1

  1. Introduction to AWS
  • VPC
  • Security Groups
  1. Understanding RDS
  • RDS Introduction
  • Different DB Engines in RDS
  • PostgreSQL in Aurora
  • Architectural Fundamentals
  1. What is Aurora DB?
  • Aurora DB Clusters
  • Connection Management
  • Storage and Reliability
  • Security
  • High Availability & Replication
  1. Setup
  • Aurora PostgreSQL DB Cluster
  • Configuration
  • Understanding the billing model
  • Migrating Data
  1. PostgreSQL SQL Language specifics
  • Querying a Table
  • Joins Between Tables
  • Aggregate Functions
  • Updates
  • Deletions
  1. Advanced SQL
  • Views, Triggers, Analytical Functions
  • Foreign Keys
  • Transactions
  • Window Functions, Inheritance

 

Day 2

  1. Indexes
  • Index types
  • Indexes and ORDER BY
  • Combining Multiple Indexes
  • Operator Classes and Operator Families
  • Examining Index Usage
  • Full Text Search
  1. Transaction Isolation and Concurrency
  • Transaction Isolation Levels
  • Serializable Isolation Level
  • Explicit Locking
  • Table-Level Locks
  • Table-level lock modes
  • Conflicting lock modes
  • Row-Level Locks
  • Deadlocks
  • Advisory Locks
  • Using EXPLAIN
  1. Security
  • SSL Server File Usage
  • Data Protection
  • Identity and Access Management
  • Logging and Monitoring
  • Compliance, Resilience
  • Best Practices
  1. Managing an Aurora DB Cluster
  • Adding Replicas
  • Performance and Scaling
  • Parameter Groups
  • Cloning Databases
  • Auto Scaling
  1. Backing Up and Restore
  • Backup Storage
  • Creating a DB Cluster Snapshot
  • Restoring from a DB Cluster Snapshot
  • Copying a Snapshot
  • Sharing a Snapshot
  • Point-in-Time Recovery
  • Maintaining DB Cluster
  • Updates

 

Day 3

  1. Monitoring an Aurora DB Cluster
  • Overview of Monitoring
  • Viewing a DB Cluster
  • Aurora DB Cluster Metrics
  1. Performance Insights
  • Aurora Recommendations
  • Database Activity Streams
  • RDS Event Notification
  • Log Files
  • Logging API Calls
  1. Security
  • Updating Applications for New SSL/TLS Certificates
  • Migrating Data to Aurora PostgreSQL
  • Logical Replication
  1. Execution Plans
  • Managing Query Execution Plans for Aurora PostgreSQL
  • Best Practices for Query Plan Management
  • dba_plans view
  • Capturing Execution Plans
  • Using Managed Plans
  1. Fast Recovery after Failover

 

  1. Upgrading Engine Version

 

  1. Best Practices with Aurora PostgreSQL

 

  1. Troubleshooting Techniques

Inquire now

Best selling courses

Duration: 5 days – 35 hrs   Overview The “SOC Network and Threat Detection and Analysis” training course is designed to equip Security Operations Center (SOC) analysts and IT security professionals with the skills and knowledge required to detect, analyze, and respond to network threats effectively. This comprehensive course covers essential topics such as threat...

Duration 1 day – 7 hrs   Overview   This 1-day training builds upon basic warehouse operations knowledge and introduces key logistics concepts involved in the movement and coordination of goods—especially wet and dry food items—within and outside the warehouse. Participants will explore transport logistics, inbound and outbound coordination, documentation practices, and cold chain considerations,...

Duration 2 days – 14 hrs   Overview   This hands-on course provides an introduction to Splunk, a powerful platform for searching, monitoring, and analyzing machine-generated data. The training focuses on how developers and QA professionals can leverage Splunk to gain insights from logs and metrics, improve application observability, detect anomalies, and support test validation....

Duration 3 days – 21 hrs   Overview.   This course is designed for fresh graduates aspiring to build a career in Data Science. It introduces the fundamentals of data science, focusing on data analysis, visualization, and basic machine learning concepts using Python. The course provides hands-on practice with real-world datasets, equipping participants with the...

Duration 5 days – 35 hrs   Overview   The Microsoft Certified: Azure Administrator Associate (AZ-104) Training Course is designed for IT professionals who want to develop expertise in managing Microsoft Azure environments. This course provides hands-on training on deploying, managing, and monitoring Azure services, including virtual machines, networking, storage, identity, and security.   Objectives...

ARTIFICIAL INTELLIGENCE / MACHINE LEARNING / DEEP LEARNING

Capstone Workshop: Build Your Own GenAI Toolkit TECH AI

GenAI Toolkit Training is a practical, hands-on capstone workshop designed to help participants bring their generative AI knowledge together into a personalized toolkit of AI tools, prompts, workflows, and practical solutions. Rather than simply learning individual AI platforms, participants will learn how to select and combine the right tools to address real-world technical and professional...

In this course, you will gain practical foundation level training that enables immediate and effective participation in big data and other analytics projects. Learn ways of storing data that allow for efficient processing and analysis, and gain the skills you need to store, manage, process, and analyze massive amounts of unstructured data to create an appropriate data lake.

Advanced Laravel Engineering Scalable Architecture, Performance, Testing, Queues & DevOps equips developers with the skills to design scalable Laravel applications, optimize performance, implement automated testing, manage queues, and integrate DevOps practices for reliable, production-ready deployments.   Duration 5 Days – 35 hrs   Overview This advanced-level bootcamp is designed for teams building large-scale or mission-critical...

// BG EARTH WHEN NOT PLAYING

We use cookies on our website to personalize your experience by storing your preferences and recognizing repeat visits. By clicking “Accept”, you agree to the use of all cookies. You can also select “Cookie Settings” to adjust your preferences and provide more specific consent. Cookie Policy