Skip to content

PostgreSQL on AWS Aurora Training in Singapore and India

Sale Sale
Original price Rs. 174,000.00
Original price Rs. 174,000.00 - Original price Rs. 174,000.00
Original price Rs. 174,000.00
Current price Rs. 135,000.00
Rs. 135,000.00 - Rs. 135,000.00
Current price Rs. 135,000.00
Overview
PostgreSQL on AWS Aurora Training by Cloud Enabled Pte Ltd in Singapore and India
Course Summary

The course talks about How to get going with PostgreSQL on the AWS Aurora Database Engine. It starts with basic PostgreSQL syntaxes and then slowly starts discussions on more advanced topics like replications, HA, optimizations etc.

Course Objectives
Course Pre- requisites
  • A working knowledge of SQL and C
  • Basic system administration (Unix/Linux or Windows)
Course Duration
  • 21 hours – 3 days
Course Outline

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
  2. Upgrading Engine Version
  3. Best Practices with Aurora PostgreSQL
  4. Troubleshooting Techniques
Training Delivery Mode

Online - Live Instructor Led training 

Due to Covid - we dont engage classroom training till situations are ok

Got Questions

Please email to info@thecloudenabled.com and we will be happy to help

This course is designed , developed and delivered by Cloud Enabled Pte Ltd