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 49m

1h 49m

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 Overview1m
  2. Introducing Amazon RDS30m
  3. Amazon RDS and MariaDB10m
  4. Amazon RDS and SQL Server DB12m
  5. Amazon RDS and MySQL DB14m
  6. Amazon RDS and Oracle DB10m
  7. Amazon RDS and PostgreSQL9m
  8. Read Replicas, Restoring, and Monitoring RDS20m

Administering Amazon Aurora on Amazon RDS

by Aaron Medacco

Dec 10, 2018 / 3h 25m

3h 25m

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 Overview1m
  2. Introduction to Amazon Aurora25m
  3. Creating an Aurora Cluster19m
  4. Migrating Data to an Aurora Cluster35m
  5. Managing Our Aurora Cluster48m
  6. Replication with Aurora24m
  7. Cloning Aurora Databases 13m
  8. Aurora Integration with Other AWS Services22m
  9. Aurora Serverless and Aurora Multi-Master14m

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 17m

2h 17m

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 Overview2m
  2. Creating Simple DynamoDB Tables12m
  3. Creating Elaborate DynamoDB Tables36m
  4. Backing up and Recovering DynamoDB Tables11m
  5. Monitoring DynamoDB Tables with CloudWatch20m
  6. Handling DynamoDB Objects55m

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 Overview2m
  2. Creating a Neptune DB Cluster20m
  3. Accessing the Graph21m
  4. Loading the Graph25m
  5. Backup and Restore the Graph9m

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 30m

1h 30m

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 Overview1m
  2. Laying the Foundations, Introducing AWS Database Migration Service12m
  3. Deploying a Database Migration Service Replication Instance to AWS23m
  4. Configuring Endpoints for AWS Database Migration Service11m
  5. Creating AWS Database Migration Service Tasks20m
  6. Best Practices and Troubleshooting the Database Migration Service22m

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 Overview1m
  2. Creating a Simple Amazon ElastiCache for Redis Cluster40m
  3. Creating a Complex Amazon ElastiCache for Redis Cluster24m
  4. Backing up and Scaling Redis Clusters15m
  5. Deploying and Managing an Amazon ElastiCache for Memcached Cluster13m
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 activating this benefit, you agree to abide by Pluralsight's terms of use and privacy policy.

I agree, activate benefit