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.
The Exam Guide breaks down the content of the exam to:
- 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
- Automate database solution deployments
- Determine data preparation and migration strategies
- Execute and validate data migration
- Determine maintenance tasks and processes
- 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
- Evaluate auditing solutions
- Determine access control and authentication mechanisms
- Recognise potential security vulnerabilities within database solutions
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.
- ExamPro Solutions Architect Associate Coursework
- ExamPro Developer Associate Coursework
- Architecting for the Cloud: AWS Best Practices
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.
- AWS Database Course
- AWS Database Analytics Course
- AWS RDS Service Primer
- AWS PostgreSQL Fundamentals
- AWS PostgreSQL Architecture
- AWS SQL CLI
- AWS PostgreSQL Query Planner
- Implementing a Disaster Recovery Strategy
- Best Practices for Securing Sensitive Data
- Reduce Database Cost and Improve Availability
- Aurora Serverless: Scalable, cost-effective application deployment
- Amazon Aurora storage demystified
- Amazon Aurora Multi-Master: Scaling out database write performance
I should know DynamoDB really well and when this is a better option. Specifically, primary keys, composite keys, partition keys, sort keys, and sharding.
- Amazon DocumentDB deep dive
- Data modelling with Amazon DynamoDB
- Amazon DynamoDB deep dive: Advanced design patterns
- Supercharge your real-time apps with Amazon ElastiCache
I should know when to use the DMS, SCT or both, and how to get set up.
I should be able to answer questions on distribution keys, partitioning, cross-region replication, auto-scaling, and when Redshift should be considered over RDS.
- Exam Readiness: AWS Certified Database - Specialty
- Exam Feedback on A Cloud Guru
- Vladimir Mukhin's Exam Guide
- Jayendra Patil's Cheat Sheets
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?