AWS Professional Solutions Architect 2020: Database Solutions
Amazon Web Services 2020
| Intermediate
- 16 videos | 1h 18m 55s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this course
differentiate between SQL and NoSQL
determine which RDS database engine best suits a given need
deploy and configure Amazon Aurora in AWS
deploy and configure MySQL in AWS
deploy and configure MariaDB in AWS
deploy and configure PostgreSQL in AWS
deploy and configure Microsoft SQL Server in AWS -
deploy and configure Oracle in AWS
recognize how to use RedShift data warehousing options
deploy and configure a RedShift cluster
import and query data stored in RedShift
determine when NoSQL DocumentDB and DynamoDB should be used
deploy DocumentDB
deploy DynamoDB
summarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 25sUP NEXT
-
2.SQL and NoSQL3m 26s
-
3.Relational Database Service5m 18s
-
4.Amazon Aurora9m 43s
-
5.MySQL7m 56s
-
6.MariaDB5m 47s
-
7.PostgreSQL7m 53s
-
8.Microsoft SQL Server5m 36s
-
9.Oracle Database4m 30s
-
10.Amazon RedShift4m 20s
-
11.Amazon RedShift Deployment5m 40s
-
12.Amazon RedShift Querying4m 26s
-
13.DocumentDB and DynamoDB4m 53s
-
14.DocumentDB Deployment3m 29s
-
15.DynamoDB Deployment2m 8s
-
16.Course Summary1m 26s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
