AWS Professional Solutions Architect 2020: Database Solutions

Amazon Web Services 2020    |    Intermediate
  • 16 Videos | 1h 25m 55s
  • Includes Assessment
  • Earns a Badge
Likes 28 Likes 28
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

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE