Aws Postgresql Rds Essential Training

PostgreSQL Database Administration on AWS

What you'll learn

DBAs who are responsible for managing and maintaining PostgreSQL databases

Students and Learners: Those studying computer science, information technology, or related fields who want to expand their knowledge of databases and cloud tech

Professionals Transitioning to AWS

IT professionals, including system administrators and cloud architects, who want to gain expertise in deploying and managing PostgreSQL

Requirements

Experience administering any relational database would be helpful.

An AWS account free tier account

Description

Welcome to AWS PostgreSQL RDS Essential Training! In this comprehensive course, you will dive into the world of Amazon Web Services (AWS) and learn how to effectively deploy, manage, and optimize PostgreSQL databases using Amazon RDS (Relational Database Service). Whether you are a database administrator, developer, or IT professional, this course will equip you with the essential skills to harness the power of PostgreSQL on the AWS cloud platform.Here is some of what you will learn:Launching a PostgreSQL database instance on Amazon RDS.Configuring security settings and access control for the database.Configuring Multi-AZ deployments for high availability.Understanding automated backups and database snapshots.Restoring data from backups and snapshots.Monitoring and Performance TuningImplementing security measures for PostgreSQL databases.Integrating with other AWS services like S3, Lambda, and CloudWatch.Next steps and further resources for continued learning.By the end of this AWS PostgreSQL RDS Essential Training, you will have the skills and knowledge necessary to deploy and manage PostgreSQL databases effectively on the AWS cloud platform. You will be equipped to make informed decisions, optimize performance, and ensure the security and availability of your PostgreSQL databases on Amazon RDS. Let's get started on your journey to becoming an AWS database expert!

Overview

Section 1: Getting started with Amazon RDS

Lecture 1 What is with Amazon RDS

Lecture 2 DB instance classes

Lecture 3 RDS DB instance storage classes

Lecture 4 Regions, Availability Zones, and Local Zones

Lecture 5 Configuring AWS Command Line Interface (AWS CLI)

Lecture 6 AWS Free Tier Account

Lecture 7 Amazon Simple Storage Configuration

Section 2: Configuring Postgres RDS Instance

Lecture 8 Creating a Postgres Database Instance

Lecture 9 Working with parameter groups

Lecture 10 Managing Postgres RDS instance

Lecture 11 Installing Postgres on EC2 Instance

Lecture 12 Installing PG Admin 4 V7.4

Lecture 13 Connecting to Postgres RDS Instance

Lecture 14 Installing Azure Data Tools

Section 3: Backing up and restoring

Lecture 15 Working With RDS Backups

Lecture 16 Configuring Automated Backups

Lecture 17 Restoring Automated Backups

Lecture 18 Replicating automated backups to another AWS Region

Lecture 19 Creating a DB snapshot

Lecture 20 Restoring from a DB snapshot

Lecture 21 Copying a DB snapshot

Lecture 22 Exporting DB snapshot data to Amazon S3

Lecture 23 Deleting a DB snapshot

Section 4: Securing Your SQL Server

Lecture 24 Understanding PostgreSQL roles and permissions

Lecture 25 Understanding the rds_superuser role

Lecture 26 Controlling user access to the PostgreSQL database

Lecture 27 Delegating and controlling user password management

Lecture 28 Using SCRAM for PostgreSQL password encryption

Section 5: Importing data into PostgreSQL on Amazon RDS

Lecture 29 Basic Linux Commands: Linux For Beginners

Lecture 30 Importing a PostgreSQL database from an Amazon EC2 instance

Lecture 31 Exporting data from an RDS PostgreSQL DB instance to Amazon S3

Lecture 32 Exporting data from an RDS for PostgreSQL DB instance to EC2

Lecture 33 Importing data from Amazon S3 into an RDS for PostgreSQL DB instance

Lecture 34 Transporting PostgreSQL databases between DB instances

Section 6: Amazon RDS High Availability

Lecture 35 What is Multi-AZ?

Lecture 36 Multi-AZ DB instance deployments

Lecture 37 Disabling Multi-AZ DB Instance Deployments

Lecture 38 Multi-AZ DB Cluster Deployments

Lecture 39 Working with read replicas for Amazon RDS for PostgreSQL

Section 7: Monitoring metrics in an Amazon RDS instance

Lecture 40 Overview of monitoring metrics in Amazon RDS

Lecture 41 Viewing instance status and recommendations

Lecture 42 Viewing metrics in the Amazon RDS console

Lecture 43 Monitoring Amazon RDS metrics with Amazon CloudWatch

Section 8: Monitoring events, logs, and streams in an Amazon RDS DB instance

Lecture 44 Views RDS logs and events

Lecture 45 RDS Event Subscription

Section 9: Working with the PostgreSQL autovacuum on Amazon RDS for PostgreSQL

Lecture 46 Postgres RDS Routine Maintenance

Lecture 47 Vacuuming Basics for Postgres RDS

Lecture 48 Allocating memory for autovacuum

Lecture 49 Recovering Disk Space

Database Administrators (DBAs),Developers,IT Professionals,Cloud Enthusiasts