AWS: Databases

Overview

Class Central Tips

AWS: Databases Course is the second course of Exam Prep (DEA-C01): AWS Certified Data Engineer - Associate Specialization. This course assists learners in designing relational and non-relational databases using AWS services. This course focuses on configuring No-SQL and Graph databases using Amazon DocumentDB, Amazon DynamoDB, Amazon Keyspaces, and Amazon Neptune. The course also guides implementing relational and data warehouses using Amazon RDS and Amazon Redshift respectively. This course is divided into two modules and Lessons and Video Lectures further segment each module. This course facilitates learners with approximately 3:00-3:30 Hours of Video lectures that provide both Theory and Hands-On knowledge. Also, Graded and Ungraded Quizzes are provided with every module to test the ability of learners. Module 1: Relational Database and Data Warehouse in AWS Module 2: Non-Relational Databases in AWS By the end of this course, a learner will be able to: - Implement and configure relational databases in AWS using Amazon RDS. - Examine data warehouse solutions in AWS. - Implement and configure non-relational databases in AWS using Amazon DynamoDB, Amazon Keyspaces, etc. This course is intended for individuals who want to enhance their skills working with on-premises and AWS Cloud-based relational and non-relational databases and have one or two years of experience in configuring database solutions for applications.

Syllabus

Relational Database and Data Warehouse in AWS

Welcome to Week 1 of the AWS: Databases course. In this week, you will be introduced to Relational Database and Data Warehouse services in AWS. You will learn the concept of Amazon RDS. You will explore some of Amazon Redshift's features such as Automatic Table Optimization, Column Compression, and Stored Procedures. By the end of the week, you will learn how to work with SQL queries using Amazon Redshift.

Non-Relational Databases in AWS

Welcome to Week 2 of the AWS: Databases course. This week, you will be introduced to Non-Relational Databases in AWS. You will explore Amazon DynamoDB Accelerator (DAX) which is a fully managed, highly available caching service built to improve performance for Amazon DynamoDB. By the end of the week, you will learn the advanced features of Amazon DynamoDB with its components.

Other Non-Relational Databases in AWS

Welcome to Week 3 of the AWS: Databases course. This week, you will be introduced to Amazon Keyspaces, Amazon MemoryDB for Redis, and Amazon Neptune in AWS. You will learn the features and use cases of other non-relational databases in AWS. By the end of the week, you will understand the difference between MemoryDB for Redis and ElastiCache for Redis.