These are the most relevant services where you would train yourself if you want to be a Database Specialty
Cloudformation:
- stack set
- delete policy resource
- stack policy
Neptune
- How to load data
- if it is convienient to Load from S3 or prem
- How to sign
- Type of file to use
- Graph DB definition and when to use
VPC
- Security group
- Private/Public subnets
- VPN
- Direct connect
- VPC Endpoints
RDS Oracle
- Standard & Enterprise editions
RDS
- How to copy snapshots (encr/decr)
- storage autoscaling
- how to handle storage
- SNS event notifications
- GP2 and IO storage types
Aurora
- Aurora serverless
- Aurora Lambda
- Aurora global
- Aurora cloning
- Aurora autoscaling Replica
- Backtrack
- IAM authoritation
- When to use active streams
Redshift
- How to copy snapshots (encr/decr)
Region
- Replica lag (Aurora, aurora replica, CRRR, global)
Dynamodb
- Global table
- Provisioning vs On-demand
- PITR
- Backup
- LSI
- GSI
- Slow scan, only of the 15% RCU used, how to speed the scan? Set limit and offset
- When to use DAX
- When to use streams
Elasticache Redis
- Is it writeable?
- Is it only a cache and it needs a persistent storage?
- Redis reserved-memory-percent parameter
AWS Trust Advisor
- How to receive alerts
- How to use it
- What does it do
Scenarios
- Backup & Restore
- the most convenient
- the most secure and less-lost solution
- PK and SK of a DDB table
Other minor services to learn
- How to share logs
- How to use KMS and KMS CMK for all the resources
- TCP Keepalive
- Athena and Redshift spetrum
- Application insights
- Systems Manager Parameter Store vs Secret Manager
- Glue
Good luck!