AWS Professional Solutions Architect 2020: Database Solutions

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

YOU MIGHT ALSO LIKE

COURSE Microsoft Azure Fundamentals: Databases & Data Analytics
COURSE Developing Serverless Applications: AWS Serverless Essentials for Developers
COURSE AWS Certified Machine Learning: Athena, QuickSight, & EMR

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE AWS Professional Solutions Architect 2020: AWS Management
Likes 100 Likes 100  
COURSE AWS Professional Solutions Architect 2020: S3 Security
Likes 32 Likes 32  
COURSE Objects & Retrieving Data
Likes 72 Likes 72