Skill map
Platform administration
Operates at least one production database platform deeply. As Database Administrator needs it.
Platform administration skill map
Careers that require it
- Database AdministratorImportance 5 of 5
Courses that teach it
- Apache Cassandra Fundamentals
- AWS Databases
- Cloud Databases
- Column-Family Databases
- Distributed SQL Databases
- Document Databases
- Graph Databases
- Key-Value Databases
- Microsoft SQL Server
- MongoDB Fundamentals
- MySQL Administration
- Neo4j Fundamentals
- NoSQL Fundamentals
- Oracle Database
- Platform Administration
- PostgreSQL Administration
- Redis Fundamentals
- Time-Series Databases
- Vector Databases
HOWTOs
Concrete operational procedures from the courses on this page.
- How to migrate a relational database to Amazon RDS or Aurora with DMS at near-zero downtime
Moving a live relational database onto RDS or Aurora with an AWS DMS full-load-and-CDC task: the schema and index work around the load, the CDC latency gate that decides when a cutover is safe, and the reverse replication path that keeps rollback open.
AWS Databases
- How to restore an Amazon RDS or Aurora database to a point in time after data corruption
Recovering from a bad write by restoring RDS or Aurora point-in-time recovery into a new instance beside the untouched source, validating the restore time, and choosing between a full cutover and a selective repair.
AWS Databases