AWS Certified Database - Specialty (DBS-C01)

By Kelby Enevold

Introduction to AWS database technologies on a per-service basis in preparation for the AWS Certified Database Specialty (DBS-C01) exam.

23.1 hours
  • 86 Lessons
  • 11 Hands-On Labs
  • 1 Practice Exam

About the course

In this course, we’ll explore workload-specific database design, discuss how different database types are best leveraged, and dive into services like RDS, Aurora, and DynamoDB. This course aims to provide the fundamentals required to pass the AWS Certified Database Specialty (DBS-C01) exam by introducing AWS database technologies on a per-service basis.

Throughout the course, we’ll go over deploying AWS database resources, managing those resources, and migrating them to additional regions or database engines. We’ll also cover monitoring and troubleshooting — discussing RDS and Aurora features like Performance Insights and Enhanced Monitoring — and how to perform investigations and minimize downtime, thereby increasing availability.

We’ll also touch on using services like Redshift for data warehousing and analytical workloads, and discuss popular migration methodologies between engines and services (including lessons on both homogeneous and heterogeneous migrations using AWS Database Migration Service).

Going into the AWS Certified Database Specialty exam, it’s important that students feel comfortable performing administrative tasks on database resourcees — including everything from configuring backups, to cross-region replication, to best-practice migration methodologies.

After completing this course, students will have the knowledge required to properly leverage various AWS database offerings, such as RDS, Aurora, Aurora serverless and global database, DynamoDB, Database Migration Service, and even services like Redshift and Neptune. Students will have a foundational understanding of which database service is best leveraged for a given workload, taking feature availability into account.

  • Chapter 1 2 Lessons Introduction 9:12

    Course Introduction

    1:49

    Prerequisites and Course Overview

    7:23
  • Chapter 2 3 Lessons AWS Databases 28:49

    Purpose-Built Databases

    10:14

    Understanding RTO and RPO

    6:52

    AWS Database Services Overview

    11:43
  • Chapter 3 14 Lessons Relational Database Service 2:35:20

    Overview of Amazon RDS

    10:47

    Understanding Read Replicas

    10:24

    Understanding Multi-AZ

    12:54

    Using Backup and Restore

    11:20

    Monitoring in RDS

    14:15

    Working with RDS Logs

    14:18

    Security in RDS

    14:59

    Working with RDS in a VPC

    11:03

    Managing RDS Resources

    20:42

    Understanding RDS Maintenance

    10:41

    Troubleshooting RDS

    13:16

    Pricing Models in RDS

    10:41

    Deploying an Amazon RDS Multi-AZ and Read Replica

    0:00 Hands-On Lab

    Restoring an Amazon RDS Instance Using Snapshots

    0:00 Hands-On Lab
  • Chapter 4 27 Lessons Amazon DynamoDB 2:34:00

    DynamoDB Architecture

    7:35

    DynamoDB Items

    4:01

    Using the AWS Management Console

    13:32

    Creating a DynamoDB Table

    0:00 Hands-On Lab

    Console Metrics and CloudWatch

    5:30

    Alerts and Alarms

    5:03

    Errors and Codes

    6:56

    Partitions, Partition Keys, and Sort Keys

    5:48

    Performance Units: RCU and WCU

    5:46

    Consistency Model (Strongly vs. Eventual)

    2:24

    Scans and Queries

    7:36

    PutItem

    2:33

    Batch Operations

    3:52

    Provisioned vs. On-Demand Capacity Modes

    5:22

    Auto Scaling

    7:19

    Indexes: Part 1

    4:23

    Indexes: Part 2

    8:49

    Working with DynamoDB Local and Global Indexes

    0:00 Hands-On Lab

    Importing Tables Using AWS Database Migration Service

    10:24

    On-Demand vs. Continuous (PITR) Backup

    3:12

    Offloading Large Attribute Values to S3

    3:28

    Transactions

    6:18

    Time to Live (TTL)

    4:09

    DynamoDB Accelerator (DAX) Architecture

    11:42

    Global Tables

    4:18

    Encryption

    10:33

    DynamoDB VPC Endpoints

    3:27
  • Chapter 5 13 Lessons Amazon Aurora 1:56:28

    Understanding Aurora Architecture

    8:38

    Getting Started with Amazon Aurora

    10:36

    Working with Aurora Replicas

    10:48

    Managing an Aurora Cluster

    9:33

    Common Backup and Restore Methods

    8:22

    Working with Aurora in a VPC

    11:24

    How to Use Aurora Global Database

    7:42

    Using Aurora Serverless

    13:42

    Understanding Aurora Security

    8:28

    Using Aurora Cloning

    13:33

    Troubleshooting Aurora (Coming Soon!)

    13:42

    Creating an Amazon Aurora RDS Database (MySQL Compatible)

    0:00 Hands-On Lab

    Creating and Connecting to an Aurora Serverless Database via CLI

    0:00 Hands-On Lab
  • Chapter 6 5 Lessons Additional Database Services 20:51

    Overview of Neptune, DocumentDB, and QLDB

    9:14

    Understanding Redshift Architecture

    5:48

    Loading and Unloading Data with Redshift

    5:49

    Loading and Retrieving Data in Neptune

    0:00 Hands-On Lab

    Loading Data into a Redshift Cluster

    0:00 Hands-On Lab
  • Chapter 7 11 Lessons Migrating Data to AWS Databases 1:05:03

    Picking the Right Migration Tool

    12:33

    Introduction to Database Migration Service

    6:58

    DMS Data Migration Sources and Targets

    8:54

    Using the Schema Conversion Tool

    6:06

    Migrating Using DMS with Data Validation

    4:27

    Using AWS Glue

    6:35

    Large Migrations Using Snowball Edge

    4:27

    Using DMS for Cross-Account Migration

    5:06

    Investigating DMS Tasks

    9:57

    Using the AWS DMS to Migrate Data to an Aurora Database

    0:00 Hands-On Lab

    Migrating from a Relational Database to DynamoDB

    0:00 Hands-On Lab
  • Chapter 8 9 Lessons Monitoring and Optimization 3:43:47

    Improving Database Performance Using ElastiCache

    6:56

    Leveraging Performance Insights

    5:01

    CloudWatch Logs

    10:38

    Working with Trusted Advisor

    4:21

    CloudWatch Application Insights

    3:36

    Advanced Audit Logging

    4:36

    Deploying with CloudFormation

    8:39

    Using Elasticache to Improve Database Performance

    0:00 Hands-On Lab

    AWS Certified Database - Specialty

    3:00:00 Quiz
  • Chapter 9 3 Lessons Conclusion 14:35

    Review Checklist

    7:24

    Useful Resources

    3:27

    What's Next

    3:44

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!