AWS Databases

Paths

AWS Databases

Authors: Jeff Hopper, Aaron Medacco, Stefan Roman, Michael Brown, Tom Compagno

Do you need a database? Which database type do you need for your project? The answers to these questions and how to implement your database on AWS is what you’ll learn from this path.

What you will learn:

  • Relational and Non-Relational Databases on AWS
  • Data Migration on AWS
  • Data Warehousing on AWS
  • Graph Database on AWS

Pre-requisites

Learners need to know general cloud computing principles and be familiar with the AWS platform to succeed on this path.

Beginner

In this section you’ll cover the relational database options on AWS. You’ll learn how to configure them, and you’ll learn how to manage them.

Creating, Connecting, and Monitoring Databases with Amazon RDS

by Jeff Hopper

Feb 20, 2019 / 1h 50m

1h 50m

Start Course
Description

Data persistence is at the core of every line of business application. In this course, Creating, Connecting, and Monitoring Databases with Amazon RDS, you will learn foundational knowledge of managing the five third-party database engines provided by RDS. First, you will learn the common configurations shared among each these engines. Next, you will discover any specific configurations of each engine. Finally, you will explore several of the supporting features provided by RDS, such as Read Replicas, Database Backups, and Database Monitoring. When you’re finished with this course, you will have the skills and knowledge of Amazon RDS needed to create, connect to, and monitor the five third-party database engines.

Table of contents
  1. Course Overview
  2. Introducing Amazon RDS
  3. Amazon RDS and MariaDB
  4. Amazon RDS and SQL Server DB
  5. Amazon RDS and MySQL DB
  6. Amazon RDS and Oracle DB
  7. Amazon RDS and PostgreSQL
  8. Read Replicas, Restoring, and Monitoring RDS

Administering Amazon Aurora on Amazon RDS

by Aaron Medacco

Dec 10, 2018 / 3h 26m

3h 26m

Start Course
Description

AWS is reinventing the relational database landscape with their fast-growing engine, Amazon Aurora. In this course, Administering Amazon Aurora on Amazon RDS, you'll learn everything you'll need to migrate and operate Aurora clusters in AWS. First, you'll see the innovations Aurora is making and how to create an Aurora cluster. Next, you'll discover how to migrate existing databases to Aurora and how to manage, scale, and monitor those databases. Finally, you'll explore Aurora cloning, integration with other AWS services like Lambda, and bleeding edge technologies, Aurora Serverless and Aurora Multi-Master. After taking this course, you'll have gained the skills necessary to provide real-world value to organizations using Amazon Aurora.

Table of contents
  1. Course Overview
  2. Introduction to Amazon Aurora
  3. Creating an Aurora Cluster
  4. Migrating Data to an Aurora Cluster
  5. Managing Our Aurora Cluster
  6. Replication with Aurora
  7. Cloning Aurora Databases
  8. Aurora Integration with Other AWS Services
  9. Aurora Serverless and Aurora Multi-Master

Intermediate

In this section you’ll learn about the other types of databases on AWS that are not relational. You’ll learn about data warehousing as well, and you’ll be ready to move to more advanced topics.

AWS DynamoDB Fundamentals

by Stefan Roman

Jun 25, 2019 / 2h 18m

2h 18m

Start Course
Description

AWS DynamoDB service can in some cases replace standard relational databases, and therefore vastly reduce operational costs and management overhead that often comes with relational databases. In this course, AWS DynamoDB Fundamentals, you will gain the ability to manage and interact with the DynamoDB service. First, you will learn the basics by creating a simple DynamoDB table. Next, you will discover advanced features such as autoscaling, global tables, and table backups. Finally, you will explore how to interact with the table using the AWS Console, AWS command line tools, and Python. When you are finished with this course, you will have the skills and knowledge of DynamoDB basic and advanced features, needed to architect, manage, and interact with complex DynamoDB tables.

Table of contents
  1. Course Overview
  2. Creating Simple DynamoDB Tables
  3. Creating Elaborate DynamoDB Tables
  4. Backing up and Recovering DynamoDB Tables
  5. Monitoring DynamoDB Tables with CloudWatch
  6. Handling DynamoDB Objects

Data Warehousing with Amazon Redshift

by John Montgomery

Jun 28, 2019 / 1h 30m

1h 30m

Start Course
Description

The scale of data being processed today is vastly larger than ever before, and the proper tools must be used to handle and process this data efficiently. In this course, Data Warehousing with Amazon Redshift, you will gain an understanding of how to use Redshift for large-scale, data processing tasks. First, you will learn how to build and configure your own Redshift cluster. Next, you will discover how to design tables for optimal efficiency and performance, and load the data into Redshift from S3. Finally, you will create your own custom transformations for the data. By the end of the course, you will have the skills and knowledge to set up a Redshift cluster for your own organization.

Table of contents
  1. Course Overview
  2. Creating Your First Redshift Cluster
  3. Loading Data into Your Redshift Cluster
  4. Creating Efficient Tables in Redshift
  5. Adding New Functionality to Your Redshift Cluster
  6. Prioritizing Tasks in Your Redshift Cluster

Managing a Graph Database with Amazon Neptune

by Jeff Hopper

Apr 30, 2019 / 1h 19m

1h 19m

Start Course
Description

Implementing a reliable, fault-tolerant graph database solution takes significant effort. Neptune is Amazon's fully managed graph database service, which has been designed to be reliable, durable, and fault-tolerant. In this course, Managing a Graph Database with Amazon Neptune, you will learn foundational knowledge of creating, accessing, and managing an Amazon Neptune cluster. First, you will see how to create a Neptune cluster. Next, you will discover how to access this cluster and perform queries in either Gremlin graph traversal language or RDF's SPARQL query language. Finally, you will explore how to create and restore cluster snapshots. When you're finished with this course, you will have the skills and knowledge of Amazon Neptune needed to manage an Amazon Neptune cluster.

Table of contents
  1. Course Overview
  2. Creating a Neptune DB Cluster
  3. Accessing the Graph
  4. Loading the Graph
  5. Backup and Restore the Graph

Advanced

In this section you’ll learn about migrating data to AWS from other sources. You’ll also learn about Elasticache and how it can be used in conjunction with the other services you’ve already learned.

Migrating Databases with AWS Database Migration Service

by Michael Brown

Apr 26, 2019 / 1h 31m

1h 31m

Start Course
Description

At the core of migrating databases into the AWS cloud is a thorough knowledge of the AWS Database Migration Service (DMS). In this course, Migrating Databases with AWS Database Migration Service, you’ll learn how to migrate databases from on-premise into the AWS cloud. First, you’ll discover how to configure and deploy replication servers that you will use to manage your database migration. Next, you’ll explore DMS tasks - tasks that sit at the heart of your migration. Finally, you’ll learn how to monitor and troubleshoot your database migrations. When you’re finished with this course, you’ll have a foundational knowledge of database migrations that will help you as you move forward to successfully migrate your production databases into AWS.

Table of contents
  1. Course Overview
  2. Laying the Foundations, Introducing AWS Database Migration Service
  3. Deploying a Database Migration Service Replication Instance to AWS
  4. Configuring Endpoints for AWS Database Migration Service
  5. Creating AWS Database Migration Service Tasks
  6. Best Practices and Troubleshooting the Database Migration Service

Connecting and Deploying Amazon ElastiCache

by Tom Compagno

May 15, 2019 / 1h 36m

1h 36m

Start Course
Description

Building and maintaining servers and caches to support your applications can be a time-consuming job. In this course, Connecting and Deploying Amazon ElastiCache, you will gain the ability to deploy complex caches as a service. First, you will learn how to create and connect to a simple Redis cluster. Next, you will enhance your new knowledge by building a more advanced cluster and see ways to scale and protect your cache and its data. Finally, you will explore Memcached as an alternative caching technology and how to properly deploy to maintain max performance and minimize costs. When you are finished with this course, you will have the skills and knowledge of ElastiCache needed to maximize the data needs of a complex system architecture.

Table of contents
  1. Course Overview
  2. Creating a Simple Amazon ElastiCache for Redis Cluster
  3. Creating a Complex Amazon ElastiCache for Redis Cluster
  4. Backing up and Scaling Redis Clusters
  5. Deploying and Managing an Amazon ElastiCache for Memcached Cluster
Offer Code *
Email * First name * Last name *
Company
Title
Phone
Country *

* Required field

Opt in for the latest promotions and events. You may unsubscribe at any time. Privacy Policy

By providing my phone number to Pluralsight and toggling this feature on, I agree and acknowledge that Pluralsight may use that number to contact me for marketing purposes, including using autodialed or pre-recorded calls and text messages. I understand that consent is not required as a condition of purchase from Pluralsight.

By activating this benefit, you agree to abide by Pluralsight's terms of use and privacy policy.

I agree, activate benefit