Module 6: Database
Services
Unit notes:
“AWS Cloud Databases” https://aws.amazon.com/products/databases/.
“What is a Relational Database?” https://aws.amazon.com/relational-database/.
“What is NoSQL?” https://aws.amazon.com/nosql/.
“Purpose-built databases” in the Developer Center https://aws.amazon.com/getting-started/hands-on/purpose-built-databases/.
“Working with read replicas” in the Amazon Relational Database
Service User Guide https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.PostgreSQL.
“Amazon Aurora storage and reliability” in the Amazon Aurora User
Guide https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html.
“Amazon DynamoDB: Gaming use cases and design patterns” in the AWS
Database Blog https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/.
“Core Components of Amazon DynamoDB” in the Amazon DynamoDB
Developer Guide https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.CoreComponents.html.
“Amazon DynamoDB auto scaling: Performance and cost optimization
at any scale” in the AWS Database Blog https://aws.amazon.com/blogs/database/amazon-dynamodb-auto-scaling-performance-and-cost-optimization-at-any-scale/.
“Amazon DynamoDB global tables” https://aws.amazon.com/dynamodb/global-tables/.
“Configuring connections in Amazon Redshift” in the Amazon
Redshift Cluster Management Guide https://docs.aws.amazon.com/redshift/latest/mgmt/configuring-connections.html.
“Columnar storage” in the Amazon Redshift Database Developer Guide
https://docs.aws.amazon.com/redshift/latest/dg/c_columnar_storage_disk_mem_mgmnt.html.
“Working with concurrency scaling” in the Amazon Redshift Database
Developer Guide https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html.
“Amazon Redshift clusters” https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-clusters.html.
“Caching strategies” in Amazon ElastiCache for Redis User Guide https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/Strategies.html.
“Caching strategies” in Amazon ElastiCache for Memcached User
Guide https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html.
“Amazon ElastiCache” https://aws.amazon.com/elasticache/.
“Comparing Redis and Memcached” https://aws.amazon.com/elasticache/redis-vs-memcached/.
“Adding TTL” in Amazon ElastiCache for Redis User Guide https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/Strategies.html#Strategies.WithTTL.
“Adding TTL” in Amazon ElastiCache for Memcached User Guide https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html#Strategies.WithTTL.
“In-Memory Acceleration with DynamoDB Accelerator (DAX)” in the
Amazon DynamoDB Developer Guide https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DAX.html.
“What is AWS Database Migration Service?” in the AWS Database
Migration Service User Guide https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html.
“AWS Schema Conversion Tool” https://aws.amazon.com/dms/schema-conversion-tool/.
Limits & Quotas
RDS https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Limits.html
Aurora https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_Limits.html
DynamoDB https://docs.aws.amazon.com/general/latest/gr/ddb.html
DAX https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Limits.html#limits-dax
DynamoDB Service, Account, and Table https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ServiceQuotas.html
Redshift https://docs.aws.amazon.com/redshift/latest/mgmt/amazon-redshift-limits.html
ElastiCache https://docs.aws.amazon.com/general/latest/gr/elasticache-service.html
Databases on AWS https://aws.amazon.com/products/databases/
What is a Relational Database? https://aws.amazon.com/relational-database/
What is NoSQL? https://aws.amazon.com/nosql/
RDS https://aws.amazon.com/rds/
Documentation https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html
Working with read replicas https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html#USER_ReadRepl.PostgreSQL
Aurora https://aws.amazon.com/rds/aurora/?aurora-whats-new.sort-by=item.additionalFields.postDateTime&aurora-whats-new.sort-order=desc
Documentation https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_AuroraOverview.html
Amazon Aurora storage and reliability https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html
DynamoDB https://aws.amazon.com/dynamodb/
Documentation https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Introduction.html
Core Components https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.CoreComponents.html
In-Memory Acceleration with DynamoDB Accelerator (DAX) https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DAX.html
Redshift https://aws.amazon.com/redshift/
Documentation https://docs.aws.amazon.com/redshift/latest/dg/welcome.html
Columnar storage https://docs.aws.amazon.com/redshift/latest/dg/c_columnar_storage_disk_mem_mgmnt.html
Working with concurrency scaling https://docs.aws.amazon.com/redshift/latest/dg/concurrency-scaling.html
Redshift clusters https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-clusters.html
ElastiCache https://aws.amazon.com/elasticache/
ElastiCache for Redis https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/index.html
ElastiCache for Memcached https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/index.html
Caching strategies for Redis https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/Strategies.html
Caching strategies for Memcached https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html
Comparing Redis and Memcached https://aws.amazon.com/elasticache/redis-vs-memcached/
Adding TTL in Redis https://docs.aws.amazon.com/AmazonElastiCache/latest/red-ug/Strategies.html#Strategies.WithTTL
Adding TTL in Memcached https://docs.aws.amazon.com/AmazonElastiCache/latest/mem-ug/Strategies.html#Strategies.WithTTL
Eventually Consistent https://www.allthingsdistributed.com/2008/12/eventually_consistent.html
Mind Maps:
RDS https://www.awsgeek.com/Amazon-RDS/
Aurora Serverless https://www.awsgeek.com/Amazon-Aurora-Serverless/
DocumentDB https://www.awsgeek.com/Amazon-DocumentDB/
DynamoDB https://www.awsgeek.com/Amazon-DynamoDB/
ElastiCache https://www.awsgeek.com/Amazon-ElastiCache/
Neptune https://www.awsgeek.com/Amazon-Neptune/
QLDB https://www.awsgeek.com/Amazon-QLDB/
Timestream https://www.awsgeek.com/Amazon-Timestream/
MemoryDB https://www.awsgeek.com/AWS-Summit-Online-Americas-August-2021/Purpose-built-for-performance-Amazon-MemoryDB-for-Redis/
Whitepapers:
Performance at Scale with Amazon ElastiCache https://d0.awsstatic.com/whitepapers/performance-at-scale-with-amazon-elasticache.pdf
Optimizing MySQL Running on Amazon EC2 Using Amazon EBS https://d1.awsstatic.com/whitepapers/Database/optimizing-mysql-running-on-amazon-ec2-using-amazon-ebs.pdf?did=wp_card&trk=wp_card
Determining the IOPS Needs for Oracle Database on AWS https://d1.awsstatic.com/whitepapers/determining-iops-needs-for-oracle-database-on-aws.pdf?did=wp_card&trk=wp_card
Amazon Aurora MySQL Database Administrator's Handbook: Connection
Management https://d1.awsstatic.com/whitepapers/determining-iops-needs-for-oracle-database-on-aws.pdf?did=wp_card&trk=wp_card
Amazon Aurora MySQL Database Administrator's Handbook: Connection
Management https://docs.aws.amazon.com/whitepapers/latest/database-caching-strategies-using-redis/welcome.html?did=wp_card&trk=wp_card
Migrating Oracle Database Workloads to Oracle Linux on AWS https://d1.awsstatic.com/whitepapers/migrating-oracle-database-workloads-to-oracle-linux-on-aws.pdf?did=wp_card&trk=wp_card
Blogs:
Amazon DynamoDB: Gaming use cases and design patterns https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/
Amazon DynamoDB auto scaling: Performance and cost optimization at
any scale https://aws.amazon.com/blogs/database/amazon-dynamodb-auto-scaling-performance-and-cost-optimization-at-any-scale/
Implementing a disaster recovery strategy with Amazon RDS https://aws.amazon.com/blogs/database/implementing-a-disaster-recovery-strategy-with-amazon-rds/
Top 10 performance tuning techniques for Amazon Redshift https://aws.amazon.com/blogs/big-data/top-10-performance-tuning-techniques-for-amazon-redshift/
Automate Amazon Redshift cluster creation using AWS CloudFormation
https://aws.amazon.com/blogs/big-data/automate-amazon-redshift-cluster-creation-using-aws-cloudformation/
Automated query caching into Amazon ElastiCache for Amazon RDS,
Amazon Aurora and Amazon Redshift https://aws.amazon.com/blogs/database/automating-sql-caching-for-amazon-elasticache-and-amazon-rds/
Caching for performance with Amazon DocumentDB and Amazon
ElastiCache https://aws.amazon.com/blogs/database/caching-for-performance-with-amazon-documentdb-and-amazon-elasticache/
Standardizing Database Migrations with AWS DMS and AWS Service
Catalog https://aws.amazon.com/blogs/mt/standardizing-database-migrations-with-aws-database-migration-service-and-aws-service-catalog/
Tutorials:
Create and Connect to a MySQL Database https://aws.amazon.com/getting-started/tutorials/create-mysql-db/?trk=gs_card
Create and Connect to a PostgreSQL Database https://aws.amazon.com/getting-started/tutorials/create-connect-postgresql-db/?trk=gs_card
Migrate from RDS MySQL to Aurora MySQL in near zero downtime https://aws.amazon.com/getting-started/hands-on/migrate-rdsmysql-to-auroramysql/?trk=gs_card
Create and Connect to a MariaDB Database https://aws.amazon.com/getting-started/tutorials/create-mariadb-db/?trk=gs_card
Create and Connect to a Microsoft SQL Server Database https://aws.amazon.com/getting-started/tutorials/create-microsoft-sql-db/?trk=gs_card
Videos:
Amazon Relational Database Service (Amazon RDS) https://youtu.be/igRfulrrYCo
AWS re:Invent 2019: Data modeling with Amazon DynamoDB https://youtu.be/DIQVJqiSUkE
Getting Started with Amazon Redshift https://youtu.be/dfo4J5ZhlKI
AWS Database Migration Service (DMS) https://youtu.be/zb4GcjEdl8U
Build with DynamoDB | S1 E1 – Intro to Amazon DynamoDB https://youtu.be/W3S1OnDqWl4
AWS re:Invent 2019: Deep dive and best practices for Amazon
Redshift https://youtu.be/lj8oaSpCFTc
Top 10 Data Migration Best Practices https://youtu.be/i0-pSHQJ7pA
AWS re:Invent 2019: Amazon Aurora storage demystified: How it
all works - HIGHLY RECOMMENDED https://youtu.be/DrtwAOND1Pc
Trainings:
Database Learning Plan: Database Fundamentals https://explore.skillbuilder.aws/learn/learning_plan/view/14/database-learning-plan-database-fundamentals -
2 courses
Database Learning Plan: AWS NoSQL Database Services https://explore.skillbuilder.aws/learn/learning_plan/view/80/database-learning-plan-aws-nosql-database-services -
13 courses
Database Learning Plan: AWS Relational Database Services https://explore.skillbuilder.aws/learn/learning_plan/view/81/database-learning-plan-aws-relational-database-services -
13 courses
Storage Learning Plan: Data Migration https://explore.skillbuilder.aws/learn/learning_plan/view/94/storage-learning-plan-data-migration -
3 courses
Labs:
AWS Purpose Built Databases Workshop https://amazon-rds-purpose-built.workshop.aws/
Note: While this lab is free, you will need to use
your own AWS account, which means you may incur some charges for
running resources used by the labs.
Amazon Aurora PostgreSQL Immersion Day https://aurora-pg-lab.workshop.aws/
Note: While this lab is free, you will need to use
your own AWS account, which means you may incur some charges for
running resources used by the labs.
Amazon RDS for PostgreSQL - Workshop https://rdspg.workshop.aws/
Note: While this lab is free, you will need to use
your own AWS account, which means you may incur some charges for
running resources used by the labs.
Amazon RDS for Oracle Immersion Day https://rdsora.workshop.aws/
Note: While this lab is free, you will need to use
your own AWS account, which means you may incur some charges for
running resources used by the labs.
Amazon RDS for SQL Server Workshop https://rdssms.workshop.aws/
Note: While this lab is free, you will need to use
your own AWS account, which means you may incur some charges for
running resources used by the labs.
Qwiklabs - Databases https://amazon.qwiklabs.com/catalog?keywords=database
Note: While this lab is free, you will need to use
your own AWS account, which means you may incur some charges for
running resources used by the labs.
Previous Top
Next