This course explores AWS (Amazon Web Services) database solutions and configurations, including whether to use SQL (Structured Query Language) or NoSQL (not only Structured Query Language) databases. You will learn to configure and deploy Amazon Aurora, MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, and Oracle in AWS. This course examines the difference between SQL and NoSQL databases and explains which Amazon RDS (Relational Database Service) engine is most applicable for a client's needs. Learners explore Amazon's Redshift Database, a cloud-based, big-data warehouse solution that lets companies store petabytes of data in easy-to-access "clusters" that can be queried in parallel. You will learn how to deploy and configure a RedShift cluster. You will examine when to use the DocumentDB, Amazon's non-relational, scalable, and fully managed document database, DynamoDB, and NoSQL databases and you will learn how to deploy each. Finally, you will learn how to increase RDS availability with a multi-availability zone deployment. This course can be used in preparation for the AWS Certified Solutions Architect-Professional SAP-C01 certification exam.
AWS Professional Solutions Architect 2020: Database Solutions