beginner Level

3 Hands-on labs

Amazon Aurora - Cloud SQL DB Essentials

By Julie Elkins

We cover the essentials of Amazon Aurora and Amazon Aurora Serverless.

Get Started See Pricing See Pricing

6 hours

43 Lessons
3 Hands-On Labs

About the course

Hi and welcome to Amazon Aurora – Cloud SQL DB Essentials! Throughout this course, we will learn what a database is and what makes Amazon Aurora such an awesome database solution for your environment. We will cover the essentials of Amazon Aurora and Amazon Aurora Serverless. We take some deeper dives into Aurora features, management, pricing, connectivity, security, performance, and troubleshooting. Let’s get started!

Contact Sales Get Started See Pricing See Pricing

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Practice alongside courses in Cloud Playground

What is Cloud Playground? Cloud Playground lets you build skills in real-world AWS, Google Cloud, and Azure environments. Spin up risk-free Sandboxes, Servers and Terminals and follow along with courses, test a new idea or prepare for exams.

Plans & Pricing

Choosing is the first step

Whether you’re a small team, a global enterprise, or somewhere in between, we offer multiple plans so you can choose the one that best fits your needs.

Business Basic

^$ 41.59 / user monthly

Billed as $499 / user yearly

Hands-on learning for smaller teams
Unlimited courses, quizzes, and practice exams
Full learn-by-doing experience with Hands-on Labs and Cloud Playground
User and skills analytics

Business Plus

Scalability for larger teams and entire organizations
Everything in Business Basic, plus:
Evaluate team readiness with Skills Assessment
Manage teams, single sign-on (SSO), and reporting
Fast-track learning with Study Groups and Accelerator Programs
Dedicated Customer Success Manager

Business Basic

$499 / year

Business Plus

$699 / year

Unlimited Courses

Learning without limits

Teams learn from anywhere with unlimited access to certification courses and deep dives on AWS, Azure, GCP, Linux, and so much more.

Unlimited Hands-on Labs

Learn faster by doing

Teams learn by doing with guided labs based on real-world scenarios in a secure, risk-free environment. Build new skills in as little as 15 minutes.

Learning Paths

Take your teams from novice to guru

Not sure how to proceed? We’ll guide you through the exact skills your team needs to progress from novice to guru across a variety of cloud specialties, including Architect, Security, and DevOps.

Cloud Playground - Servers

Cloud on demand

Your learners can spin up pre-configured, auto-provisioned servers in just a few clicks. Provide safe practice environments and never worry about a surprise cloud bill.

Cloud Playground - Instant Terminal

SSH on demand

Quickly and safely launch a secure, in-browser SSH terminal into any instance on any provider – even behind a firewall.

Cloud Playground - Sandboxes

Learn by doing

Teams learn faster by doing with Cloud Playground. Try out new cloud skills in live AWS, Azure, and GCP sandbox environments — without racking up a surprise bill. Cloud along with courses, test ideas, and prepare for exams.

ACG Original Series

Keep up with the cloud

Stay up-to-date on all things cloud with weekly and monthly videos about the latest developments in AWS, Azure, GCP, and Kubernetes.

Practice Exams

Put skills to the test

Learners prepare for certs with practice exams that mimic the real thing. Plus, they get personalized pointers on how to improve their scores.

Quizzes

Pop quiz, hot shot

Quickly check knowledge on a variety of topics and know where to brush up with short quizzes.

Community Forums

Cloud with friends

Learners get the help they need, when they need it, from industry experts and others in the community.

ACG Mobile Apps

Keep ACG in your pocket

Teams learn cloud from anywhere with our mobile apps for iOS and Android.

Mobile Offline Mode

Learn off the grid

No internet connection? No problem. Download courses for offline access with our app for iOS and Android.

Records of Completion

Achievement unlocked

Records of completion make it easy for your learners to mark and showcase progress.

Video Transcripts & Captions

For the record

Learners read along when sound isn’t an option and skip furiously scribbling notes. Our transcripts and captions are also fully searchable, making it easy to find exactly what they’re looking for.

Interactive Diagrams

Study aids on demand

Snag clickable, PDF versions of core concepts to revisit later. Our diagrams make great study aids, help build retention, and can act as handy cheat sheets for a quick refresher down the road.

Email Support

One dashboard to rule them all

Easily assign new users, track learning and ROI with usage and skill analytics, and manage the entire ACG for Business experience from one central location.

Skills Assessment

Know where you stand

Take stock of your organization’s cloud readiness so you can know exactly where to start.

Learning Accelerator

Get to the cloud faster

Fast-track your organization’s path to cloud fluency with sprint-based certification tracks, including weekly lessons, hands-on projects and whitepapers.

Study Groups

Learn better together

Group learners together so they can support each other and build skills faster. Discussing topics and helping others understand concepts boosts retention and builds camaraderie.

Certification Reporting

Skills at a glance

Keep tabs on skills and certifications across your organization to properly staff projects, track progress, and inform learning goals.

Team Management

Easy organization by teams

Create and assign learners to teams for easier management, tracking, and reporting. Designate team coordinators to help keep teams on track, and know who’s conquering the cloud or needs a nudge with the team leaderboard.

Single Sign-On

Invite 10 to 10,000 or more

Use your company’s ID and password to make management and scalability a breeze.

LMS Integration

Connect all the dots

Integrate results and reporting into your existing learning management systems for a 360-degree view of employee skills development.LMS Integration currently available for EdCast and Degreed.

API Access

Get your bits

Automatically transfer raw usage and skills data to your data warehouse or other repository.

Dedicated Customer Success Manager *

We’ve got your back

Get the most out of ACG for Business with a dedicated cloud learning consultant to support you with onboarding, best practices, and more.

Personalized Onboarding *

We’ll show you the ropes

Get up and running the right way. Let one of our learning gurus take you through an onboarding experience tailored to your needs.

Contact Sales

* Available with 50+ seats

Plans & Pricing

Choosing is the first step

Whether you’re an individual learner, a global enterprise, or somewhere in between, we offer several plans so you can choose the one that best fits your needs.

Free

^$ 0 / month

Limited access to basic courses and features
Rotating selection of limited courses
Stay ahead with weekly cloud roundups
Engage with a vibrant community of learners and experts

Personal Basic

^$ 39 ^$ 31.59 / month

Billed as $379 per year

Pay Yearly Pay Monthly

Save 19% with annual plan!

Full access to our hands-on learning library
Includes FREE 7-Day trial
Unlimited courses, quizzes, & practice exams
Unlimited Hands-on Labs
Practice in real multi-platform servers

Start a Free Trial

Personal Plus

^$ 41.59 / month

Billed as $499 per year

Everything in Personal Basic, plus:
Full learn-by-doing experience in real AWS, Azure, & GCP environments!
Unlimited access to full Cloud Sandboxes
Includes FREE 7-Day trial
No account setup or cloud bills

Start a Free Trial

Free

Personal Basic

$379 / year

Personal Plus

$499 / year

Unlimited Courses

limited

Learn without limits

Learn from anywhere with unlimited access to certification courses and deep dives on AWS, Azure, GCP, Linux, and so much more.

Quizzes

limited

Pop quiz, hot shot

Quickly check your knowledge on a variety of topics and know where to brush up with short quizzes.

ACG Original Series

Keep up with the cloud

Stay up-to-date on all things cloud with weekly and monthly videos about the latest developments in AWS, Azure, GCP, and Kubernetes.

Community Forums

Cloud with friends

Get the help you need, when you need it, from industry experts and other learners in the community — and help others in turn.

Learning Paths

Go from novice to guru in your chose specialty

Not sure how to proceed? We’ll guide you through the exact skills you need to gain to progress from novice to guru across a variety of cloud specialties, including Architect, Security, and DevOps.

ACG Mobile Apps

Keep ACG in your pocket

Learn cloud from anywhere with our mobile apps for iOS and Android.

Mobile Offline Mode

Learn off the grid

No internet connection? No problem. Download courses for offline access with our app for iOS and Android.

Unlimited Hands-on Labs

Get your hands cloudy

Learn by doing with guided labs based on real-world scenarios in a secure, risk-free environment. Build new skills in as little as 15 minutes.

Practice Exams

Put your skills to the test

Prepare for your certs with practice exams that mimic the real thing. Plus, get personalized pointers on how to improve your score.

Interactive Diagrams

Study aids on demand

Snag clickable, PDF versions of core concepts to revisit later. Our diagrams make great study aids, help build retention, and can act as handy cheat sheets for a quick refresher down the road.

Video Transcripts & Captions

For the record

Read along when sound isn’t an option and skip furiously scribbling notes. Our transcripts and captions are also fully searchable, making it easy to find exactly what you’re looking for.

Records of Completion

Achievement unlocked

Earn a little something when you complete courses. Records of completion make it easy to mark and showcase your progress.

Email Support

Cloud on demand

Spin up pre-configured, auto-provisioned servers in just a few clicks. Cloud along with courses, practice whenever you feel like it, and never worry about a surprise cloud bill.

Cloud Playground - Instant Terminal

SSH on demand

Quickly launch a secure, in-browser SSH terminal into any instance on any provider – even behind a firewall.

Cloud Playground - Sandboxes

Personal Plus Only

Learn by doing

Learn by doing with Cloud Playground. Try out new cloud skills in live AWS, Azure, and GCP sandbox environments — without racking up a surprise bill. Cloud along with courses, test an idea at work or prepare for exams.

Free
$0

Personal Basic
$379 / year

Personal Plus
$499 / year

Start Free

Free Trial

Browse Learning

Browse Platforms

Hands-on Labs

Amazon Aurora - Cloud SQL DB Essentials

About the course

Lab Highlights

An Important Note About A Cloud Guru and Linux Academy Courses

Course Introduction

Using the Interactive Diagram

What Is a Database?

What Is Amazon Aurora?

Aurora Database Cluster - Part One

Aurora Database Cluster - Part Two

How Are Databases Used?

Create and Configure an Aurora MySQL Database Cluster

MySQL and PostgreSQL

Global Database

Multi-Master

Parallel Query

Performance Insights

Backtrack

Aurora Serverless

Machine Learning

RDS Proxy

Additional New Aurora Features

Amazon Aurora Pricing

Performing a Proof of Concept

Security, Configuring Access, and Connecting to Your Aurora Database

Importing and Exporting Data

Managing Performance and Scaling for Your Aurora DB Cluster

Best Practices

Connecting to an Aurora DB to Transfer Data

Creating an Aurora DB Cluster with an Instance Parameter Group and a Custom Cluster Endpoint

Using Amazon Aurora Serverless

How Amazon Aurora Serverless Works

Creating an Aurora Serverless DB Cluster

Restoring, Modifying, and Viewing Your Aurora Serverless DB

Using the Data API for Aurora Serverless

Using the Query Editor for Aurora Serverless

Storage and Reliability with Amazon Aurora

High Availability with Amazon Aurora

Working with Amazon Aurora Global Databases

Using the AWS DMS to Migrate Data to an Aurora Database

Performance Tuning and Benchmarking with Amazon Aurora

Troubleshooting

Setting the Capacity of an Aurora Serverless DB Cluster

Troubleshooting Data API Issues

Amazon Aurora Limits

Amazon Aurora Best Practices and Key Take Aways

Plans & Pricing

Choosing is the first step

Business Basic

Business Plus

Learning without limits

Learn faster by doing

Take your teams from novice to guru

Cloud on demand

SSH on demand

Learn by doing

Keep up with the cloud

Put skills to the test

Pop quiz, hot shot

Cloud with friends

Keep ACG in your pocket

Learn off the grid

Achievement unlocked

For the record

Study aids on demand

We’re here to help

One dashboard to rule them all

Know where you stand

Get to the cloud faster

Learn better together

Skills at a glance

Easy organization by teams

Invite 10 to 10,000 or more

Connect all the dots

Get your bits

We’ve got your back

We’ll show you the ropes