WHO?

Freshers and Lateral Hires

* Installing SQL Server on EC2

* Licensing / Cost Optimisation
* Security Hardening
* Backup/Restore, HA/DR
Strategies
* Performance Tuning & Storage
SQL Server on EC2 Choices

* Introduction to RDS & Use

Cases
* Supported Database Engines
* Launching an RDS Instance
* Security (IAM, VPC,
Encryption)
* Backups, Snapshots, and
Restore
* Monitoring & Performance
Tuning
* Multi-AZ vs Read Replicas
* Cost Management & Reserved
RDS (Relational DB Service) Instances

* Aurora vs RDS: Architecture &

Performance
* Aurora MySQL vs Aurora
PostgreSQL
* Scaling & Auto-scaling (Aurora
Serverless v1 vs v2)
* High Availability & Failover
* Global Databases
AWS
Aurora / Aurora Serverless * Migration Strategies to Aurora

* NoSQL Basics and Use Cases

* Table Design: Partition Keys,
Sort Keys
* Capacity Modes: On-Demand
vs Provisioned
* Indexes: GSI, LSI
* Querying & Filtering Data
* Streams and DynamoDB
Triggers (Lambda)
* Security & Access Control
(IAM)
* Performance Optimization
DynamoDB Patterns

* Overview & MongoDB

Compatibility
* Architecture & Use Cases
* Launching and Managing
Clusters
* Security and Encryption
* Backup and Restore
DocumentDB * Monitoring & Alerts

* Supported Engines (MySQL,

PostgreSQL, SQL Server)
* Instance Configuration &
Storage
* HA and Replication
* Backups and Maintenance
Windows
* IAM and VPC Integration
* Performance Monitoring
CloudSQL (Query Insights)

* Horizontal Scaling & Global

Distribution
Multi Cloud Database * Schema Design in Spanner
Administration * Querying with SQL
Data Engineering * Use Cases & Best Practices
Spanner * Dataflow Integration

* Architecture Overview
(Serverless DWH)
* Datasets, Tables, and
Partitions
WHAT? * Query Optimization & Cost
Control
* Integrations (Looker, Data
Studio)
* Security (IAM, Row-Level
Permissions)
* Scheduled Queries & BI
GCP BigQuery Engine

* NoSQL Concepts & Design

Patterns
* Row Key Design and Schema
Modeling
* Integration with HBase API
* Performance Tuning
* Monitoring and
BigTable Troubleshooting

* What is AlloyDB & Key

Features
* Use Cases vs Cloud SQL/
Spanner
* Storage & Compute
Separation
* Migration Tools (pg_dump,
DMS)
* Performance Features
AlloyDB (Columnar cache, ML Optimizer)

* Overview of Deployment
Models
* Elastic Pools & DTU vs vCore
Model
* Scaling and Performance Tiers
* Security (AAD, TDE, VNet)
* Backup, Restore, Geo-
Replication
* Tools (SSMS, Data Studio,
Azure SQL Database Azure Portal)

* MI vs Single Database
* Network Configuration (Private
Endpoints)
* Migration Tools: DMS,
BACPAC, etc.
* Security & Compliance
* Monitoring and
Azure Managed Instances Troubleshooting

* Introduction to ETL and ADF

* Pipelines, Activities, and
Datasets
* Linked Services & Triggers
* Data Flow vs Copy Activity
* Parameterization and CI/CD
* Monitoring and Debugging
Azure Data Factory Pipelines

Cloud-Agnostic Fundamentals

DB Fundamentals

RDBMS vs Big Data

HOW? DB Stack Classification of all 3

major CSPs - Cloud Service
Providers

Security & Compliance

Hands On Labs