Mastering Amazon (AWS) Aurora RDS – 2023 (24 Hands On Demos)

Learn everything about Amazon (AWS) Aurora, a fully managed database engine compatible with MySQL & PostgreSQL | 24 Labs

Amazon Aurora (Aurora) is a fully managed relational database engine that’s compatible with MySQL and PostgreSQL. You already know how MySQL and PostgreSQL combine the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases.  The code, tools, and applications you use today with your existing MySQL and PostgreSQL databases can be used with Aurora. With some workloads, Aurora can deliver up to five times the throughput of MySQL and up to three times the throughput of PostgreSQL without requiring changes to most of your existing applications.

What you’ll learn

  • What is Amazon Aurora?.
  • AWS Account Setup & Navigation.
  • Aurora Versions & Instances.
  • Aurora Storage.
  • Aurora Reliability.
  • Aurora Replication.
  • Creating an Aurora MySQL DB cluster.
  • Aurora Global Databases.
  • Backing up & Restoring an Aurora DB Cluster.
  • Aurora Serverless.
  • RDS Proxy.
  • Security for Aurora.
  • Monitoring Metrics in an Aurora DB Cluster.
  • Monitoring Events, Logs & Streams in Aurora.
  • Blue/Green Deployments for Database Updates.
  • Pricing for Aurora.
  • Best Practices with Aurora.

Course Content

  • Introduction & Overview for Amazon (AWS) Aurora Database –> 3 lectures • 8min.
  • Amazon (AWS) Account Setup & Navigation –> 3 lectures • 11min.
  • Amazon (AWS) Aurora Database Versions & Instances –> 2 lectures • 7min.
  • Amazon (AWS) Aurora Database Storage –> 2 lectures • 7min.
  • Amazon (AWS) Aurora Database Reliability –> 3 lectures • 14min.
  • Amazon (AWS) Aurora Database Replication –> 4 lectures • 9min.
  • Creating an Amazon (AWS) Aurora Database MySQL cluster –> 7 lectures • 16min.
  • Amazon (AWS) Aurora Global Databases –> 14 lectures • 29min.
  • Backing up & Restoring an Amazon (AWS) Aurora Database Cluster –> 8 lectures • 13min.
  • Amazon (AWS) Aurora Database Serverless –> 9 lectures • 17min.
  • Amazon (AWS) Aurora RDS Proxy –> 4 lectures • 11min.
  • Security for Amazon (AWS) Aurora Database –> 5 lectures • 7min.
  • Monitoring Metrics in an Amazon (AWS) Aurora Database Cluster –> 5 lectures • 8min.
  • Monitoring Events, Logs & Streams in Amazon (AWS) Aurora Database –> 5 lectures • 10min.
  • Blue/Green Deployments for Amazon (AWS) Aurora Database Updates –> 4 lectures • 8min.
  • Pricing for Amazon (AWS) Aurora Database –> 8 lectures • 18min.
  • Best Practices with Amazon (AWS) Aurora Database –> 1 lecture • 3min.

Mastering Amazon (AWS) Aurora RDS - 2023 (24 Hands On Demos)

Requirements

Amazon Aurora (Aurora) is a fully managed relational database engine that’s compatible with MySQL and PostgreSQL. You already know how MySQL and PostgreSQL combine the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases.  The code, tools, and applications you use today with your existing MySQL and PostgreSQL databases can be used with Aurora. With some workloads, Aurora can deliver up to five times the throughput of MySQL and up to three times the throughput of PostgreSQL without requiring changes to most of your existing applications.

Aurora includes a high-performance storage subsystem. Its MySQL- and PostgreSQL-compatible database engines are customized to take advantage of that fast distributed storage. The underlying storage grows automatically as needed. An Aurora cluster volume can grow to a maximum size of 128 tebibytes (TiB). Aurora also automates and standardizes database clustering and replication, which are typically among the most challenging aspects of database configuration and administration.

An Amazon Aurora DB cluster consists of one or more DB instances and a cluster volume that manages the data for those DB instances. An Aurora cluster volume is a virtual database storage volume that spans multiple Availability Zones, with each Availability Zone having a copy of the DB cluster data. Two types of DB instances make up an Aurora DB cluster:

This course will provide you with all the skills needed learn, understand, setup, configure and monitor Aurora RDS.  Many organizations are using Amazon Aurora instead of Oracle or MS SQL Server.  This course will help you understand and become skilled at Aurora RDS to continue to grow your career or personal interests.

Get Tutorial