| Day | Task | Start Date | Completion Date | Reference Material |
|---|---|---|---|---|
| 2 | - IAM Role & Condition - Practice: + Create an IAM Group + Create IAM Users + Check User Permissions + Create Admin IAM Role + Configure Switch role + Restrict role access + Limit Switch role by IP + Limit switch role by Time + Clean up resources | 10/13/2025 | 10/13/2025 | https://000044.awsstudygroup.com/ |
| 3 | - Granting authorization for an application to access AWS services with an IAM role. - Practice: + Create EC2 Instance + Create S3 bucket + Generate IAM user and access key + Using access key + Generate IAM user and access key + Using IAM role + Clean up resources | 10/14/2025 | 10/14/2025 | https://000048.awsstudygroup.com/ |
| 4 | - Database Concepts review - Amazon RDS & Amazon Aurora - Redshift - Elasticache | 10/15/2025 | 10/15/2025 | https://cloudjourney.awsstudygroup.com/ |
| 5 | - Amazon Relational Database Service (Amazon RDS) - Practice: + Create a VPC + Create EC2 Security Group + Create RDS Security Group + Create DB Subnet Group + Create EC2 instance + Create RDS database instance + Application Deployment + Backup and Restore + Clean up resources | 10/16/2025 | 10/16/2025 | https://000005.awsstudygroup.com/ |
| 6 | - Database Schema Conversion & Migration - Practice: + EC2 Connect RDP Client + EC2 Connect Fleet Manager + SQLSrv Src Config + Oracle connect SrcDB + Oracle config SrcDB + Drop Constraint + MSSQL to aur MySQL target config + MSSQL to aur MySQL create project + MSSQL to aur MySQL SchemConv + Oracle2 MySQL Schema conversion 1 + Create Mig Task And Endpoint + Inspect S3 + Create Severless Migration + Create Event Not + Logs + Troubleshoot Test Scenario Mem Pressure + TroubleShoot Test Scenario Table Err + Clean up resources | 10/17/2025 | 10/17/2025 | https://www.youtube.com/watch?v=cxwAOP1379s&list=PLahN4TLWtox2a3vElknwzU_urND8hLn1i&index=229 |
Gained advanced skills in IAM by implementing conditional role access (IP, time), creating users, groups, and admin roles, and validating secure role switching.
Learned how to securely grant application access to AWS services by replacing access keys with IAM roles on EC2.
Strengthened understanding of AWS database services including RDS, Aurora, Redshift, and ElastiCache.
Successfully deployed a full RDS environment (VPC, security groups, EC2, DB instance) and performed application deployment plus backup/restore operations.
Completed end-to-end database schema conversion and migration workflows for MSSQL→Aurora MySQL and Oracle→MySQL using SCT and DMS, including troubleshooting and event monitoring.