loading...
Cover image for AWS Database: The Journey to Certification

AWS Database: The Journey to Certification

helenanders26 profile image Helen Anderson ・5 min read

A little while ago I wrote about what the Exam Guides recommend to study for the AWS Cloud Practitioner and Associate exams.

It took a while, but I got up to speed with everything for S3 to subnets and CloudWatch to cost optimisation.

My next challenge is to study towards the new Database Specialty Certification. There aren't too many resources and online courses as it's a new exam so I've created my own list of resources I'll be using to get there.

This exam requires 5+ years of experience with AWS and their database offerings. So I'll be taking it slow-and-steady with plenty of practice, reading and working through tutorials.


What are we learning about?
Back to Basics
RDS and Aurora
DynamoDB
Database Migration Service and Schema Conversion Tool
Redshift
More resources


What are we learning about?

The Exam Guide breaks down the content of the exam to:

Domain 1: Workload-Specific Database Design - 26%

  • Select appropriate database services for specific types of data and workloads
  • Determine strategies for disaster recovery and high availability
  • Design database solutions for performance, compliance, and scalability
  • Compare the costs of database solutions

Domain 2: Deployment and Migration - 20%

  • Automate database solution deployments
  • Determine data preparation and migration strategies
  • Execute and validate data migration

Domain 3: Management and Operations - 18%

  • Determine maintenance tasks and processes
  • Determine backup and restore strategies
  • Manage the operational environment of a database solution

Domain 4: Monitoring and Troubleshooting - 18%

  • Determine monitoring and alerting strategies
  • Troubleshoot and resolve common database issues
  • Optimize database performance

Domain 5: Database Security - 18%

  • Encrypt data at rest and in transit
  • Evaluate auditing solutions
  • Determine access control and authentication mechanisms
  • Recognise potential security vulnerabilities within database solutions

Back to Basics

Like the other speciality exams, there are no Associate level certifications to pass first. However, it's recommended to have a foundation-level knowledge of the core services.


RDS and Aurora

By the time I get to the exam, I should be able to identify when a relational database is an appropriate solution. Specifically, the pricing, limitations, disaster recovery scenarios, compliance, scalability, and when multi-AZ is appropriate.

Training

Docs

Blogs

Whitepapers

Videos


DynamoDB and NoSQL

I should know DynamoDB really well and when this is a better option. Specifically, primary keys, composite keys, partition keys, sort keys, and sharding.

Training

Docs

Whitepapers

Videos


Database Migration Service and Schema Conversion Tool

I should know when to use the DMS, SCT or both, and how to get set up.

Training

Docs

Blogs

Whitepapers

Videos


Redshift

I should be able to answer questions on distribution keys, partitioning, cross-region replication, auto-scaling, and when Redshift should be considered over RDS.

Training

Docs

Videos


More resources


That's quite the list, but I'm sure there will more as I get through the AWS coursework as well. Is anyone else on Dev working toward this new certification?


Read More:

Posted on by:

helenanders26 profile

Helen Anderson

@helenanders26

Making applications go faster at Raygun, AWS Data Hero, and tag moderator on Dev.to. Database concept you don’t understand? Let me know, I’ll write a post!

Discussion

markdown guide
 

Very cool, Helen. I also want to take some of the specialties. But I do want to do some of the professional ones first... How do you plan (or have you) split your time between reading / researching vs. hands on experimenting?

 

The plan is to delve into the coursework and reading then tackle the practice and hands-on exercises to lock it in.

If it's anything like the Associate questions the questions will be super long and wordy so the practice will go a long way :)

 

Great write up Helen, was disappointed at the lack of literature for this cert. This will save many of us quite a bit of leg work.

 

Thanks Seth :) Hopefully as more and more folks do the exam there will be more and more out there. The exam guide isn't giving too much away so I've got my eyes peeled for more hints and tips to add to this post as time goes on.