Database Fundamentals for AWS

play-arrow
Introduction
Overview
DifficultyBeginner
Duration1h 9m
Students15912
Ratings
4.6/5
starstarstarstarstar-half

Description

*** PLEASE NOTE *** This course has been replaced with two new courses: Database Fundamentals for AWS - Part 1 of 2 and Database Fundamentals - Part 2 of 2.

 

This course will provide you with an introduction to the cloud database services offered by AWS. In this course, we will first explore the fundamentals of cloud databases, outline the cloud databases provided by AWS before exploring how to get started selecting and using the AWS Database Services. 

Intended Audience

This course suits anyone interested in learning more about the database services offered by AWS. 

Prerequisites

The course is an introductory level course so there are no specific database skills or experiences required as a pre-requisite. Having a basic understanding of cloud computing will help you gain the most from this course. I recommend completing “What is cloud computing?” first if you are new to cloud computing.

Learning Objectives

On completing this course you will have an understanding of the different types of database services available to you within the AWS cloud platform. You will be able to recognize and explain the various database services offered by AWS, and be able to identify and select which database service might suit a specific use case or requirement.

Outline

First, we learn to recognize and explain the basics of a cloud database service. 
We then learn to recognize and explain the differences between non-relational and relational databases before taking a high-level pass over the family of AWS database services available.
We then dive in the Non Relational Databases 
- Amazon DynamoDB
- Amazon Elasticache 
- and Amazon Neptune exploring use cases for when we might want to use a non-relational database service.


Next, we dive into amazon RDS - the AWS Relational Database Service, exploring the database services provided by RDS. We then examine the services and their various use cases in the context of a scenario. 

Agenda

The Basics - What is a Cloud Database?

Overview of the AWS Database Services

AWS Non Relational Databases
- Amazon DynamoDB
- Amazon Elasticache
- Amazon Neptune

AWS Relational Database Service
- The RDS Service
- MySQL for RDS

- Microsoft SQL Server for RDS
- Oracle for RDS
- MariaDB for RDS
- PostGresSQL for RDS
- Amazon Aurora for RDS

Summary 

Feedback

If you have thoughts or suggestions for this course, please contact Cloud Academy at support@cloudacademy.com.

Updates

22-01-2020: Added note about Amazon Elasticache being used as a cache in front of Amazon RDS services

Notes

For additional training on the topics covered in this course, please take a look at the following Cloud Academy content:

Courses

Working with Amazon DynamoDB

Introduction to the Amazon ElastiCache Service

Amazon Aurora High Availability

Labs

Create Your First Amazon RDS Database

Getting Started with Amazon Aurora Database Engine

Introduction to DynamoDB

Configure Amazon DynamoDB triggers with AWS Lambda

Transcript

- [Andrew] Hello, and welcome to Database Fundamentals. This introductory level course will provide you with an introduction to the database services offered by Amazon Web Services. My name is Andrew Larkin and I'll be your instructor for this course. Now, if you have any questions or comments on this content, or you'd like some help deciding where to start, please feel free to contact me or my team at support@cloudacademy.com, we are here to help. Now this course suits anyone interested in learning more about the database services offered by AWS. The course is an introductory level content, so there's no specific database skills or experiences that you're required to have as a prerequisite. Having a basic understanding of cloud computing will help you gain the most from the content. So I'd recommend completing What is Cloud Computing first if you are new to the cloud computing concept. On completing this course, you'll have an understanding of the different types of database services available to you within the AWS cloud platform. You'll be able to recognize and explain the various database services offered by AWS. And will be able to identify and select which database services might suit a specific use case or requirement. Now in this course we will first explore the fundamentals of cloud databases, how a cloud database differs from databases you might run in your server room for example. We will then learn to explain the differences between non-relational and relational databases, before taking a high level pass over the family of AWS database services that are available. We're then going to dive into the non-relational databases, Amazon DynamoDB, Amazon Elasticache, and Amazon Neptune, exploring use cases for when we might use any of these non-relational database services. Next we dive into Amazon RDS, or the AWS Relational Database Service. And in that we explore MySQL for RDS, Microsoft SQL Server for RDS, Oracle of RDS, MariaDB for RDS, PostGresSQL for RDS, and the Amazon Aurora product for RDS. We're then gonna summarize what we've learned with a simple comparison chart to help us to understand the use cases and features of each of the database services that are offered by AWS, so we can recognize and explain the various use cases that might suit either or each service. So, if you're ready, let's get started.

About the Author
Students84629
Courses95
Learning paths52

Head of Content

Andrew is an AWS certified professional who is passionate about helping others learn how to use and gain benefit from AWS technologies. Andrew has worked for AWS and for AWS technology partners Ooyala and Adobe.  His favorite Amazon leadership principle is "Customer Obsession" as everything AWS starts with the customer. Passions around work are cycling and surfing, and having a laugh about the lessons learnt trying to launch two daughters and a few start ups.