AWS Certified Database – Specialty (DBS-C01)

Paths

AWS Certified Database – Specialty (DBS-C01)

Authors: Craig Golightly, Ian Fogelman, Kim Schmidt, Raj Saha, Muhammad Sajid, Anthony Sequeira

This path helps you understand the evolving landscape of databases and what AWS services are available to use those databases. It also serves as an overview of the different... Read more

What You Will Learn

  • Understand different database types and use cases including data stored and access patterns
  • Describe AWS database offerings including strengths and limitations of each service
  • Perform workload-specific database design
  • Automate database solution deployments
  • Determine data preparation and migration strategies
  • Migrating from on premises to the cloud
  • Designing database test environments
  • Execute and validate data migration
  • Determine maintenance tasks and procedures
  • Determine backup and restore strategies
  • Manage the operational environment of a database solution
  • Determine monitoring and alerting strategies
  • Troubleshoot and resolve common database issues
  • Optimize database performance
  • Encrypt data at rest and in transit
  • Determine monitoring and alerting strategies
  • Evaluate auditing solutions
  • Using security groups and NACLs
  • Recognize potential security vulnerabilities within database solutions
  • Managing constraints of time, cost, security and complexity when designing and implementing a database solution

Pre-requisites

  • Experience working in an AWS account
  • Basic understanding of databases

Path Courses

TO NAVIGATE THIS PATH: Our paths follow the same pattern as reading a book in English. Start at the top from the left. Work your way left to right as you work down the page. Left to right and top to bottom. You'll find mixed content modalities with written guides, video content, and practice labs. Some of our certification courses also have a Practice Exam located at the right column of this page. Now let's jump in! Just click on the title of the first learning resource in the top left of the list.

This path helps you understand the evolving landscape of databases and what AWS services are available to use those databases. It also serves as an overview of the different skills and responsibilities a database specialist needs to know. You’ll then be guided through several courses that go deeper into specific AWS database services to gain an in-depth understanding of when and how to best use each service. This knowledge is valuable for both real-life design and implementation as well as preparing to take the AWS Database Specialty Exam.

AWS Databases: The Big Picture

by Craig Golightly

Nov 26, 2020 / 1h 49m

1h 49m

Start Course
Description

Data is one of the most valuable assets for organizations. How you store and organize that data can either enhance or limit what you can do. In this course, AWS Databases: The Big Picture, you’ll learn to choose the best database for the job and identify which AWS service you can leverage for your implementation. First, you’ll explore use cases for different database types. Next, you’ll discover the AWS services that implement different types of databases. Finally, you’ll learn what is involved with being a database specialist - including design, maintenance, optimization, and troubleshooting. When you’re finished with this course, you’ll have the skills and knowledge of AWS Databases needed to use the right tool for the job based on your data and application needs.

Table of contents
  1. Course Overview
  2. Becoming a Database Specialist
  3. Understanding AWS Database Offerings
  4. Designing Workload-Specific Databases
  5. Migrating and Deploying Databases
  6. Managing and Operating Databases
  7. Monitoring and Troubleshooting Databases
  8. Applying Database Security

Amazon RDS: Best Practices

by Ian Fogelman

Mar 12, 2021 / 3h 21m

3h 21m

Start Course
Description

RDS allows you to launch many database backends quickly with AWS. In this course, Amazon RDS: Best Practices, you'll learn about the AWS RDS service from onboarding an on-premises database to the cloud. First, you'll discover how the relational database service helps with backups and snapshots. Next, you'll explore how to manage the different database environments inside your VPC. Finally, you'll learn how to effectively administer your RDS instances. When you're finished with this course, you'll have the knowledge and first-hand experience with RDS management techniques to help prepare for the AWS Database specialization exam.

Table of contents
  1. Course Overview
  2. On-prem to Cloud: Amazon RDS Migration
  3. Amazon RDS IAM Access Management
  4. Designing Your Amazon RDS Environments
  5. Amazon RDS Database Backups
  6. Managing the Amazon RDS Operational Environment
  7. Amazon RDS and AWS CloudFormation
  8. Amazon RDS Performance
  9. Amazon RDS Maintenance
  10. Amazon RDS Troubleshooting
  11. Configuring Security and Encryption in Amazon RDS

Amazon Aurora: Best Practices

by Kim Schmidt

Oct 7, 2020 / 3h 59m

3h 59m

Start Course
Description

Amazon Aurora is a relational database built for the cloud. In this course, Amazon Aurora: Best Practices, you’ll learn to leverage Aurora’s scalability, high performance, high availability, durability, and security while taking advantage of the management tasks that are managed for you. First, you’ll explore the architectural improvements that make Aurora a cut above the competition. Next, you’ll discover the feature improvements that this architecture enables, as well as how to efficiently and effectively design, deploy, access, monitor, use, and maintain Amazon Aurora clusters to improve performance, reduce costs, and jumpstart data transformation and innovation. Finally, you’ll learn how to utilize advanced functionalities like data migration, schema conversion, and troubleshooting techniques. When you’re finished with this course, you’ll have the skills and knowledge of Amazon Aurora needed to utilize AWS’s relational database for traditional relational database functionalities, and also know what it can for machine learning and artificial intelligence.

Table of contents
  1. Course Overview
  2. Understanding Amazon Aurora's Amazing Architecture
  3. Introducing Amazon Aurora's Resulting Feature Improvements
  4. Building and Launching Amazon Aurora Clusters
  5. Managing and Maintaining Amazon Aurora Clusters
  6. Securing Amazon Aurora
  7. Logging, Monitoring, and Auditing Amazon Aurora Clusters
  8. Exploring Amazon Aurora's Unique Backup and Restore Strategies
  9. Examining Amazon Aurora Data Migration Strategies
  10. Designing Amazon Aurora Test Environments
  11. Troubleshooting Amazon Aurora
  12. Recognizing Amazon Aurora's Extended Capabilities

Amazon DynamoDB: Best Practices

by Raj Saha

Oct 14, 2020 / 3h 17m

3h 17m

Start Course
Description

Amazon DynamoDB is a fully managed, highly available, durable NoSQL database, and a powerful alternative to its SQL counterpart.

In this course, Amazon DynamoDB: Best Practices, you’ll learn key features of DynamoDB, along with how to analyze requirements to design DynamoDB solutions.

First, you’ll explore how to design responsive, scalable, and highly available DynamoDB databases.
Next, you’ll discover migration strategies, backup restore and automated deployments for DynamoDB.
Finally, you’ll learn how to optimize database performance and secure your database.

When you’re finished with this course, you’ll have the skills and knowledge of an AWS database architect needed to answer questions from the DynamoDB domain of the AWS Certified Database - Specialty (DBS-C01) Certification exam.

Table of contents
  1. Course Overview
  2. Designing Databases with DynamoDB
  3. Automate Dynamo DB Deployments with CloudFormation
  4. Migrate Data into DynamoDB with DMS, SCT, Glue
  5. Determining Backup and Restore Strategies
  6. DynamoDB Logging, Monitoring, Alerting, and Troubleshooting
  7. Optimizing DynamoDB Performance
  8. Managing Dynamo DB Data with Streams, Scans, and Query
  9. Securing DynamoDB with Encryption and IAM

Amazon ElastiCache: Best Practices

by Raj Saha

Jan 11, 2021 / 2h 21m

2h 21m

Start Course
Description

Amazon ElastiCache is a fully managed in-memory data store compatible with Redis and Memcached. In this course, Amazon ElastiCache: Best Practices, you’ll learn key features of ElastiCache, along with how to analyze requirements to design ElastiCache solutions. First, you’ll explore how to design responsive, scalable, and highly available ElastiCache databases. Next, you’ll discover migration strategies. Then, you'll dive into backup restore and automated deployments for ElastiCache. Finally, you’ll learn how to optimize database performance and secure your database. When you’re finished with this course, you’ll have the skills and knowledge of an AWS database architect needed to answer questions from the ElastiCache domain of the AWS Certified Database: Specialty (DBS-C01) Certification Exam.

Table of contents
  1. Course Overview
  2. Designing Databases with Amazon ElastiCache
  3. Optimizing Amazon ElastiCache Performance
  4. Automate Amazon ElastiCache Deployments with AWS CloudFormation
  5. Migrate and Backup/Restore of ElastiCache
  6. Amazon ElastiCache Logging, Monitoring, Alerting, and Troubleshooting
  7. Securing Amazon ElastiCache with Encryption and IAM

Amazon DocumentDB: Best Practices

by Muhammad Sajid

Mar 9, 2021 / 2h 40m

2h 40m

Start Course
Description

Cloud developers today require in-depth knowledge for managing and running distributed cloud services such as Amazon DocumentDB, without incurring unnecessary cost and compromising on security and performance. In this course, Amazon DocumentDB: Best Practices, you'll learn to design a highly available and scalable document database solution. First, you'll explore when to use NoSQL databases in general and common scenarios where Amazon DocumentDB excels. Next, you'll learn how to create and manage a secure, performant, and cost-effective Amazon Document DB cluster and perform basic query operations. Finally, you'll learn how to perform maintenance tasks and migration activities on Amazon DocumentDB. When you're finished with this course, you'll have the skills and knowledge to create and manage a compliant database solution by following the industry’s best practices.

Table of contents
  1. Course Overview
  2. Amazon DocumentDB: Quickstart
  3. Automating Deployments Using AWS CloudFormation
  4. Optimizing Database for Performance
  5. Monitoring, Logging, and Alert Strategies
  6. Managing Amazon DocumentDB Clusters
  7. Backing up and Restoring Strategies
  8. Data Preparation and Migration Strategies
  9. Securing Database Clusters and Access Management
  10. Troubleshooting and Resolving Common Issues

Amazon Redshift: Best Practices

by Anthony Sequeira

Dec 23, 2020 / 3h 8m

3h 8m

Start Course
Description

While many AWS Solutions Architects and SysOps administrators understand the RDBMS systems, they have little experience with data warehouse solutions. In this, course, AWS Redshift: Best Practices, you’ll learn to design, deploy, and maintain AWS Redshift solutions. First, you’ll explore the basic components and architectures of Redshift. Next, you’ll discover the many best practices associated with querying and operating Redshift. Finally, you’ll learn how to secure and monitor AWS Redshift. When you’re finished with this course, you’ll have the skills and knowledge of the best practices of AWS Redshift. These skills are needed to ensure your Redshift solution is performance, operationally sound, highly available, secure, and cost effective.

Table of contents
  1. Course Overview
  2. Designing and Deploying AWS Redshift
  3. Preparing and Migrating Data to AWS Redshift
  4. Managing and Optimizing AWS Redshift
  5. Securing AWS Redshift
  6. Monitoring and Auditing AWS Redshift
  7. Troubleshooting AWS Redshift

Amazon Neptune: Best Practices

by Anthony Sequeira

Oct 1, 2020 / 3h 2m

3h 2m

Start Course
Description

While many Cloud Architects and SysOps Engineers are very familiar with the traditional relational database models in AWS, there are often many that do not understand graph database technology. In this course, Amazon Neptune: Best Practices, you’ll learn to leverage the performance, flexibility, and agility of graph databases in AWS. First, you’ll explore critical topics related to graph database deployment. Next, you’ll discover how to automate and monitor graph databases in the AWS Neptune service. Finally, you’ll learn how to secure and troubleshoot AWS Neptune databases. When you’re finished with this course, you’ll have the skills and knowledge of the AWS Neptune service needed to succeed with graph databases hosted in AWS thanks to the managed service of Neptune.

Table of contents
  1. Course Overview
  2. Designing and Deploying AWS Neptune
  3. Preparing and Migrating Data to AWS Neptune
  4. Managing and Optimizing AWS Neptune
  5. Securing AWS Neptune
  6. Monitoring and Auditing AWS Neptune
  7. Troubleshooting Issues and AWS Neptune