INFRASTRUCTURE LEARNINGINFRASTRUCTURE LEARNING
インフラ大全インフラ大全IT INFRASTRUCTURE / LEARNING
Infrastructure learning guide
Find a lesson or lab/

Esc to close · Search terms stay on your device

LEARNING日本語
CLOUD / AWS

AWS applied topics

Work through design, recovery and delivery scenarios in topic order.

Back to the main AWS lesson list

Filter applied lessons

Core lessons, further reading, exercises and troubleshooting are grouped by topic.

87 lessons and tools

Designing event-driven processing

Follow responsibility from event routing through consumer processing.

5 lessons
  1. Amazon EventBridge: how rule matching and target delivery workFurther study
  2. Idempotency: prevent duplicate effects on retryFurther study
  3. Backpressure: manage SQS backlog and downstream overloadFurther study
  4. Lambda execution environments: initialization, reuse, and concurrencyFurther study
  5. Trace serverless operating costs across Lambda, SQS, and CloudWatch LogsFurther study

Monitoring and recovering event processing

Read metrics, check alarm evidence, and reconstruct an incident timeline.

6 lessons
  1. Read CloudWatch metrics with matching periods and statisticsFurther study
  2. Read CloudWatch alarm states when data is missingFurther study
  3. Build an incident timeline from evidence, mitigation, and recoveryFurther study
  4. Design CloudWatch Logs for investigation, retention, and sensitive dataFurther study
  5. Read distributed traces to separate queue wait from execution timeFurther study
  6. Calculate an SLO and error budget from completed workFurther study

SQL Server failover and recovery

Check outcomes after reconnecting and recovery conditions after schema changes.

1 lesson
  1. What to verify after an RDS for SQL Server failoverFurther study

3 additional lessons are available in Japanese only. View Japanese lessons →

Audit coverage and recovery design

Capture audit evidence and check failure scope, recovery points and business readiness.

6 lessons
  1. CloudTrail event selection for S3 object activityFurther study
  2. AWS fault domains: choosing between Multi-AZ and Multi-RegionFurther study
  3. SQL Server RTO and RPO across a database and external recordsFurther study
  4. Route 53 health checks and DNS failover: from lookup to business recoveryFurther study
  5. AWS Regional outage recovery: keeping a single writerFurther study
  6. Designing an AWS recovery game day with measurable outcomesFurther study

Connecting VPCs and investigating traffic

Distinguish connection design, return paths, name resolution and traffic evidence.

6 lessons
  1. VPC peering design: routes in both directions and non-transitive connectionsFurther study
  2. Transit Gateway routing: associations and propagation across environmentsFurther study
  3. AWS PrivateLink service sharing: provider and consumer responsibilitiesFurther study
  4. Site-to-Site VPN and Direct Connect: choosing primary and backup pathsFurther study
  5. Route 53 VPC Resolver hybrid DNS: direction and conditional forwardingFurther study
  6. Reading VPC Flow Logs: interface, direction and observation windowFurther study

Multi-account guardrails and deployment checks

Separate organizational, permission and audit boundaries and check detection coverage.

5 lessons
  1. AWS Organizations design: accounts, OUs and administrative boundariesFurther study
  2. AWS SCP permissions ceilings: comparing IAM grants with organization denialsFurther study
  3. AWS RCP permissions ceilings for resources in member accountsFurther study
  4. AWS STS AssumeRole across accounts: trust, authorization and session scopeFurther study
  5. Verifying a CloudTrail organization trail by account, Region and deliveryFurther study

1 additional lesson is available in Japanese only. View Japanese lessons →

SQL Server recovery and analytics data

Compare recovery mechanisms and distinguish transaction records from analytics outputs.

5 lessons
  1. SQL Server backups, replicas and failover: choose a recovery mechanismFurther study
  2. SQL Server disaster recovery trade-offs: RTO, RPO, standby cost and residual risksFurther study
  3. Data lakes and warehouses: from SQL Server transactions to analyticsFurther study
  4. Athena scanned bytes and S3 costs: compare equivalent resultsFurther study
  5. AWS Glue Data Catalog and ETL: distinguish schema changes from transformed dataFurther study

1 additional lesson is available in Japanese only. View Japanese lessons →

SQL Server connectivity and AWS network operations

Investigate connectivity by client and tie transfer paths to costs.

2 lessons
  1. AWS network cost estimates: compare paths, directions and peak bandwidthFurther study
  2. Troubleshooting SQL Server across VPCs: DNS, network paths and database authenticationFurther study

5 additional lessons are available in Japanese only. View Japanese lessons →

AWS governance and GitHub Actions deployment operations

Separate governance from deployment permissions and verify controlled rollout and recovery.

3 lessons
  1. AWS Control Tower landing zones|Who operates, stores logs and auditsFurther study
  2. AWS IAM Identity Center assignments|Groups, accounts and permission setsFurther study
  3. Stage AWS organization controls|Pilot OU, stop criteria and rollbackFurther study

3 additional lessons are available in Japanese only. View Japanese lessons →

AWS data pipelines and SQL Server integration

Verify ingestion, metadata, analytics, access and lag against the same data.

3 lessons
  1. Kinesis ordering and checkpoints for SQL Server changesFurther study
  2. Redshift local tables and Spectrum for SQL Server extractsFurther study
  3. Lake Formation access paths across the Data Catalog, S3 and auditFurther study

3 additional lessons are available in Japanese only. View Japanese lessons →

AWS billing analysis and cost optimization

Reproduce billed usage, compare changes safely and measure realized savings.

6 lessons
  1. Break down AWS cost by usage type, account and periodFurther study
  2. Close an AWS Data Exports monthly report with a reproducible input versionFurther study
  3. AWS Savings Plans and EC2 Reserved Instances|Discount and capacity decisionsFurther study
  4. Verify Compute Optimizer recommendations against SQL Server peak workloadsFurther study
  5. Trace AWS network costs through NAT processing, transfer and running hoursFurther study
  6. Review Cost Optimization Hub recommendations and realized savingsFurther study

AWS authorization, encryption, audit and response

Use authorization and evidence to protect AWS and SQL Server workloads.

8 lessons
  1. Trace AWS IAM permissions for a GitHub Actions deploymentFurther study
  2. AWS KMS authorization for reading SQL Server backup copiesFurther study
  3. Triage GuardDuty findings using severity and independent evidenceFurther study
  4. Triage Security Hub findings and verify resolutionFurther study
  5. AWS Config evaluations and remediation|Handle stale findingsFurther study
  6. Respond to a credential incident in GitHub Actions and AWSFurther study
  7. Preserve AWS and SQL Server forensic evidence for handoffFurther study
  8. Threat-model AWS deployment approval and SQL Server restore boundariesFurther study

AWS and SQL Server telemetry and audit

Use metrics, logs, traces and audit records to distinguish evidence from gaps.

1 lesson
  1. Choose metrics, logs and traces for AWS and SQL Server monitoringFurther study

4 additional lessons are available in Japanese only. View Japanese lessons →

DynamoDB key design and workload skew

Start with SQL Server business requirements and evaluate access patterns and skew.

2 lessons
  1. Design DynamoDB keys around access patterns|Compare with SQL ServerFurther study
  2. Investigate hot keys in DynamoDB|Compare volume and skewFurther study

1 additional lesson is available in Japanese only. View Japanese lessons →

AWS budgets, cost improvement and billing differences

Distinguish alerts from spending and compare outcomes on the same basis.

2 lessons
  1. Use AWS Budgets alerts for spending decisions|Actuals, forecasts and delaysFurther study
  2. Measure AWS FinOps improvements per successful SQL Server jobFurther study

5 additional lessons are available in Japanese only. View Japanese lessons →

Amazon Bedrock readiness, privacy and evaluation

Match model access, logging and evaluation to workload requirements.

3 lessons
  1. Check Amazon Bedrock model IDs, Regions and invocation conditionsFurther study
  2. Protect Amazon Bedrock prompts and invocation logsFurther study
  3. Evaluate Amazon Bedrock changes with fixed cases and severe failure limitsFurther study

Applied GitHub Actions and SQL Server recovery labs

Check proposed changes, authorization and recovery objectives on synthetic data.

8 lessons
  1. Review Terraform plans and state before a GitHub Actions releaseFurther study
  2. Practice CloudFormation drift review|Unknown versus matchedFurther study
  3. Exercise SCP, RCP and IAM on one synthetic API requestFurther study
  4. GitHub Actions cross-account role exercise|Issuer, trust and permissionsFurther study
  5. SQL Server recovery exercise|Compare RTO and RPOFurther study
  6. Regional failover exercise|SQL Server write ownership and DNSFurther study
  7. Distributed trace exercise|Parallel SQL Server waitsFurther study
  8. CloudWatch alarm exercise|Threshold and missing dataFurther study

Applied container, data, cost and AI labs

Change evidence and compare operating outcomes.

8 lessons
  1. Exercise ECS deployment health|Startup, ALB and the new revisionFurther study
  2. Model an EKS upgrade window|Version support and compatibilityFurther study
  3. Practice DynamoDB workload skew|Total versus the busiest keyFurther study
  4. Exercise hourly Savings Plans commitments|Unused and uncoveredFurther study
  5. Exercise network cost components|Hours, GB and cross-AZ pathsFurther study
  6. Exercise retries and idempotency|Avoid duplicate writesFurther study
  7. Exercise Bedrock input classification and log accessFurther study
  8. Exercise RAG evaluation|Citation, version and supportFurther study

Bedrock inference, retrieval and operating decisions

Verify outputs, evidence, cost and access against operating requirements.

5 lessons
  1. Compare Amazon Bedrock inference settings and variationFurther study
  2. Estimate Amazon Bedrock cost from input, output and add-onsFurther study
  3. Verify retrieved evidence and answers in Bedrock Knowledge BasesFurther study
  4. Test Amazon Bedrock Guardrails coverage and false decisionsFurther study
  5. Set approval and permission boundaries for Bedrock AgentsFurther study

5 additional lessons are available in Japanese only. View Japanese lessons →

AWS architecture choices and certification practice

Practice connectivity, delivery, recovery and certification concepts with original cases.

2 lessons
  1. Study for AWS Certified Cloud Practitioner with original practice casesFurther study
  2. Study AWS Solutions Architect Associate with architecture casesFurther study

5 additional lessons are available in Japanese only. View Japanese lessons →