Week 6 Worklog

Week 6 Objectives:

  • Review fundamental database concepts: RDBMS, NoSQL, OLTP/OLAP, indexing, replication, backup strategies.
  • Deep understanding of AWS database services: RDS, Aurora, Redshift, ElastiCache.
  • Deploy a complete application environment using RDS in a secure VPC setup.
  • Learn AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT) for real-world migrations.
  • Perform migrations from MSSQL and Oracle to Aurora MySQL, including troubleshooting and optimization.
  • Utilize S3 as an intermediate storage layer in migration workflows.

Tasks to be carried out this week:

DayTaskStart DateCompletion DateReference Material
1Study Module 06 – Database Overview:
+ 06-01: Database Concepts review
+ 06-02: Amazon RDS & Aurora
+ 06-03: Redshift & ElastiCache		13/10/202513/10/2025AWS Study Group
2Perform RDS Deployment – Lab05 (Part 1):
+ 2.1: Create VPC
+ 2.2: EC2 Security Group
+ 2.3: RDS Security Group
+ 2.4: DB Subnet Group		14/10/202514/10/2025AWS Study Group
3Perform RDS Deployment – Lab05 (Part 2):
+ 3: Launch EC2 instance
+ 4: Create RDS instance
+ 5: Deploy application
+ 6: Backup & Restore workflow
+ 7: Cleanup		15/10/202515/10/2025AWS Study Group
4Perform Migration Tools – Lab43 (Part 1):
+ 01: EC2 Connect RDP Client
+ 02: Fleet Manager
+ 03: Config SQL Server source
+ 04–05: Config Oracle source DB
+ 06: Drop constraint
+ 07–09: MSSQL → Aurora MySQL (target setup + project + schema conversion)		16/10/202516/10/2025AWS Study Group
5Perform Migration Tools – Lab43 (Part 2):
+ 10: Oracle → MySQL schema conversion
+ 11: Create migration task & endpoints
+ 12: Inspect S3 intermediate files
+ 13: Serverless migration
+ 14: Event notifications
+ 15: Logs
+ 16–17: Troubleshoot scenarios (Memory pressure, table structure errors)		17/10/202517/10/2025AWS Study Group

Week 6 Achievements:

  • Rebuilt core understanding of database principles and the rationale behind AWS managed DB services.
  • Successfully deployed a secure VPC-based application using RDS and EC2.
  • Practiced backup & restore workflows and learned Multi-AZ and storage autoscaling implications.
  • Gained hands-on experience using DMS + SCT for MSSQL and Oracle migrations to Aurora MySQL.
  • Configured migration tasks, endpoints, schema conversion, and serverless pipelines.
  • Investigated S3 migration artifacts and resolved migration errors including memory pressure and table incompatibilities.
  • Strengthened knowledge of analytical workloads with Redshift and caching with ElastiCache.