Introduction
- Course Introduction + Exam Breakdown
- About your instructors
- Purpose Built Databases
Code & Slides Download
- Code & Slides Download
Quick refresher on the basics
- Types of data
- Relational databases
- Non-relational databases
- Database basics quiz
Amazon RDS and Aurora
- Amazon RDS overview
- RDS pricing model
- Instance type, storage type and storage auto scaling for RDS
- RDS parameter groups
- RDS option groups
- RDS - Hands on
- RDS security - Network
- RDS security - IAM
- Rotating RDS DB credentials
- Windows authentication in RDS for SQL Server
- RDS encryption in transit and at rest
- RDS backups
- Copying and sharing RDS snapshots
- How to encrypt an unencrypted RDS database
- DB restore options in RDS
- Exporting RDS DB snapshot to S3
- RDS backup and restore - Hands on
- RDS Multi-AZ deployments and read replicas
- Read replica use cases
- Promoting a read replica to a standalone DB instance
- RDS Multi-AZ failover and replica promotion - Demo
- Enabling writes on a read replica
- RDS read replica capabilities
- RDS Second-tier replicas and replica promotion - Demo
- Cross-region read replicas in RDS
- RDS replicas with an external database
- RDS disaster recovery strategies
- Troubleshooting replica issues in RDS
- Performance hit on new read replicas
- Scaling and sharding in RDS
- RDS monitoring
- RDS event subscriptions, recommendations and logs
- Exporting RDS logs to S3
- RDS Enhanced Monitoring
- RDS Performance Insights
- CloudWatch Application Insights
- RDS on VMware
- RDS - Good things to know
- RDS quiz
- Aurora overview
- Aurora architecture
- Aurora Parallel Query
- Aurora Serverless
- Data API for Aurora Serverless
- Aurora multi-master
- Aurora cross region replicas and Aurora Global database
- Reliability features in Aurora
- Aurora pricing model
- Aurora security - Network, IAM and encryption
- Parameter groups in Aurora and Aurora Serverless
- Creating an Aurora database - Hands on
- Creating an Aurora Serverless database - Hands on
- Using Data API with Aurora Serverless database - Hands on
- Scaling options in Aurora
- Aurora monitoring and advanced auditing
- Monitoring in RDS and Aurora - Demo
- Exporting Aurora logs
- Database activity streams in Aurora
- Troubleshooting storage issues in Aurora
- Aurora benchmarking
- Exporting data from Aurora into S3
- Aurora backups and backtracking
- Aurora backups vs snapshots vs backtrack
- Aurora backup, restore, PITR and backtrack - Demo
- Cloning databases in Aurora
- Aurora failovers
- Cluster Cache Management (CCM) in Aurora PostgreSQL
- Simulating fault tolerance or resiliency in Aurora
- Simulating failovers in Aurora - Demo
- Aurora failover priorities in action - Demo
- Fast failover in Aurora PostgreSQL
- Cluster replication options for Aurora MySQL
- Aurora replicas vs RDS MySQL replicas
- Comparison of RDS deployments
- How to invoke Lambda functions from Aurora MySQL
- How to load data from S3 into Aurora MySQL
- RDS / Aurora – Good things to know
- Aurora quiz
Amazon DynamoDB and DAX
- DynamoDB overview
- Working with DynamoDB - Hands on
- DynamoDB basics
- DynamoDB consistency
- DynamoDB pricing model
- DynamoDB throughput
- Calculating capacity units
- DynamoDB burst capacity and adaptive capacity
- DynamoDB local secondary index (LSI)
