‫So let's summarize everything we know
‫about databases and analytics in AWS.
‫And you just need to know what database corresponds
‫to what use case going into the exam.
‫So if you have a Relational database, and you have OLTP,
‫Online Transaction Processing, you should think
‫RDS and Aurora and both these databases supports the SQL,
‫language, SQL language to query your data.
‫You also need to know for RDS the difference
‫between a Multi-AZ deployment, Read Replicas
‫and Multi-regions as well as their use cases.
‫If you need to find an in-memory database
‫or in-memory cache, think ElastiCache.
‫If you're looking for a key value database,
‫thing DynamoDB, which is a serverless database.
‫And if you need caching technology for DynamoDB,
‫then use the DAX, technology which is cache
‫made specifically for DynamoDB.
‫If you're looking for a word data warehousing, or OLAP,
‫online analytical processing, then you need to look
‫at Redshift, which is a warehousing technology.
‫And you can also use the SQL language
‫to query data on Redshift, if you're trying to build
‫a Hadoop Cluster to do big data analysis,
‫use the EMR service, if you want to query data on Amazon S3
‫in a serverless fashion with the SQL language,
‫then use Athena, QuickSight is a way to create dashboards
‫visually interactives, visuals and so on.
‫That can be interactive as well on your data
‫in a serverless fashion, then you will use Amazon
‫QuickSights also used for business intelligence.
‫DocumentDB is what I call the Aura of MongoDB.
‫So anytime you see MongoDB think DocumentDB,
‫which is also using the JSON type of data sets.
‫And this is a no SQL database.
‫So this is another no SQL database on top of DynamoDB.
‫Then we have Amazon QLDB, which is a financial
‫transaction ledger, anytime you would see financial
‫transaction, immutable journal something
‫that is cryptographically verifiable,
‫think Amazon QLDB, and this is a central
‫database which is opposed to a decentralized database,
‫which is Amazon Managed Blockchain, in which case,
‫we can have manage Hyperledger Fabric
‫and Ethereum blockchains on AWS.
‫Finally, if you want to have a managed extract,
‫transform and load tools ETL, we can use Glue,
‫which also has a data catalog service to discover datasets
‫into your various databases in AWS.
‫And finally, if you need to move data between databases,
‫then you would use the DMS service
‫for database migration service.
‫Oh, so I don't forget, there is Neptune
‫if you have a graph database, that's it.
‫I hope you liked it and I will see you in the next lecture.