Learning Area / Topic AWS SQL DBA Azure SQL DBA
Day 1: Introduction & Setup Create RDS (SQL Server, MySQL, PostgreSQL),
Create
Redshift
Azure SQL DB, SQL MI, Set up SSMS & A
Day 2: Architecture & DeploymentRDS & Redshift architecture, Multi-AZ PaaS architecture, DTU vs vCore models
Day 3: Connectivity & Networking VPC, Security Groups, Parameter Groups VNet, Private Link, Firewalls, NSGs
Day 4: Security & Identity IAM roles, KMS, Authentication Azure AD, RBAC, TDE, AAD
Day 5: Backup & Restore Snapshots, PITR, Manual Backups Geo-Restore, Auto Backups, LTR
Day 6: High Availability & DR Multi-AZ, Read Replicas, Redshift Clusters Auto-failover, Geo-replication, Zone redundancy
Day 7: Monitoring & Alerts CloudWatch, Enhanced Monitoring, Perf Insights
Azure Monitor, Log Analytics, Query Store
Day 8: Maintenance & Patching Maintenance windows, Parameter tuning Schedules, Tier upgrades
Day 9: Performance Tuning RDS Perf Insights, Redshift WLM, Query Plans
Index tuning, Query Store, Insights
Day 10: Automation & DevOps AWS CLI, CloudFormation, Systems ManagerAzure CLI, ARM Templates, Automation, PS
Day 11: Migration Tools AWS DMS, SCT, S3 Import/Export DMA, DMS, BACPAC, SSMS
Day 12: Cost Management Pricing Calculator, Reserved Instances Cost Management, Advisor, Reservations
Day 13: Auditing & Compliance CloudTrail, Audit Logs, Security Hub Defender for SQL, Data Security, Audit Logs
Day 14: Advanced Topics Aurora, Redshift Spectrum, RDS Proxy Hyperscale, Serverless, Elastic Pools