Working with AWS Databases
Description
In almost every enterprise solution there will be a requirement for some sort of database, but which service should you use, and how should you architect it? This learning path has been compiled to introduce you to the different AWS database services and some of the features relating to AWS database types.
Learning Objectives
- Gain an understanding of the different types of database services available to you within AWS
- Be able to recognize and explain the various database services offered by AWS.
- Identify and select which database services might suit a specific use case or requirement
- Be able to create an RDS database
- Define the differences between DynamoDB and other databases
- Understand when to use DynamoDB, or when not to use it
- How to create DynamoDB tables, understanding and using best practices for table design
- How to read and write data in DynamoDB tables
- Be able to configure DynamoDB triggers to work with AWS Lambda
- Enable you to recognize and explain the AWS Database Schema Conversion Tool
- Learn to recognize and explain when to use the AWS Database Migration Service and to recognize common-used cases
- Recognize and implement best practices when using the AWS Database Migration Services
- Understand the differences between Multi-AZ instances and Read Replicas
- Understand the different techniques and methods used to implement Multi-AZ across different DB engines
- Understand the limitations and subtle differences between read replicas across different db engine types
Intended Audience
This learning path has been designed for those who are responsible for maintaining and managing databases infrastructure within AWS. It would also be advantageous to Solution Architects and those looking to take an Associate or Professional level AWS certification.
Prerequisites
You should have a basic understanding of AWS core services and VPC infrastructure
Related Training Content
To gain additional knowledge around some of the other services mentioned within this course, you might wish to take a look at the 'Solutions Architect - Associate Certification Preperation for AWS' Learning Path (Feb 2018)
Certificate
Learning Path Steps
This course covers AWS databases at a very high level and will include how they work, their strengths, and what workloads are best suited for them.
This course (part of a two-part series on AWS database fundamentals) introduces you to Amazon RDS, Amazon DynamoDB, Amazon ElastiCache, and Amazon Neptune.
Knowledge Check: Database Fundamentals for AWS Part 1
You will learn the steps to create and use the MySQL Relational Database using Amazon RDS.
A hands-on lab introducing you to the high performance and high availability Amazon Aurora database engine.
This course (part of a two-part series on AWS database fundamentals) introduces you to Amazon Redshift, Amazon QLDB, Amazon DocumentDB, and Amazon Keyspaces.
Knowledge Check: Database Fundamentals for AWS Part 2
Learn how to use the Amazon Redshift service. Create a cluster with a database, copy data from S3, query data using SQL, and resize the cluster.
In this course, you'll learn about RDS multi-AZ and will come away knowing when to implement and use this feature within your own environment.
This course explores Amazon RDS Performance Insights, a performance monitoring and tuning feature that can quickly assess the database load on an Amazon RDS database instance.
This course explores how to scale your RDS databases based on reads or writes, horizontally or vertically.
This introductory course provides a foundational awareness of the tools AWS available to monitor Amazon RDS databases
This course explores the cost metrics associated with the Amazon Relational Database Service, known as RDS.
In this course, you'll learn the fundamentals of Amazon DynamoDB, including table design, reading, writing, and working with large tables.
Move your first steps using DynamoDB. Create tables with and withoud secondary indexes, learn how to add new rows and query your data by using the AWS Management Console.
This short course focuses on the DynamoDB Accelerator, more commonly referred to as DAX.
Learn how to listen to DynamoDB update streams and process batches of records with AWS Lambda to augment your database behavior.
In this course, you'll learn about the AWS Database Migration Service and the AWS Database Schema Conversion Tool and how they can be used to migrate data.
Final Exam: Working with AWS Databases
Stuart has been working within the IT industry for two decades covering a huge range of topic areas and technologies, from data center and network infrastructure design, to cloud architecture and implementation.
To date, Stuart has created 80+ courses relating to Cloud reaching over 100,000 students, mostly within the AWS category and with a heavy focus on security and compliance.
Stuart is a member of the AWS Community Builders Program for his contributions towards AWS.
He is AWS certified and accredited in addition to being a published author covering topics across the AWS landscape.
In January 2016 Stuart was awarded ‘Expert of the Year Award 2015’ from Experts Exchange for his knowledge share within cloud services to the community.
Stuart enjoys writing about cloud technologies and you will find many of his articles within our blog pages.