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

  • 2m 25s
  • 3m 26s
    Learn how to differentiate between SQL and NoSQL. FREE ACCESS
  • Locked
    3.  Relational Database Service
    5m 18s
    In this video, learn how to determine which RDS database engine best suits your needs. FREE ACCESS
  • Locked
    4.  Amazon Aurora
    9m 43s
    In this video, learn how to deploy and configure Amazon Aurora on AWS. FREE ACCESS
  • Locked
    5.  MySQL
    7m 56s
    In this video, you will learn how to deploy and configure MySQL in AWS. FREE ACCESS
  • Locked
    6.  MariaDB
    5m 47s
    Learn how to deploy and configure MariaDB in Amazon Web Services. FREE ACCESS
  • Locked
    7.  PostgreSQL
    7m 53s
    Learn how to deploy and configure PostgreSQL on AWS. FREE ACCESS
  • Locked
    8.  Microsoft SQL Server
    5m 36s
    In this video, learn how to deploy and configure Microsoft SQL Server on AWS. FREE ACCESS
  • Locked
    9.  Oracle Database
    4m 30s
    In this video, you will learn how to deploy and configure Oracle on AWS. FREE ACCESS
  • Locked
    10.  Amazon RedShift
    4m 20s
    After completing this video, you will be able to recognize how to use RedShift data warehousing options. FREE ACCESS
  • Locked
    11.  Amazon RedShift Deployment
    5m 40s
    In this video, you will learn how to deploy and configure a RedShift cluster. FREE ACCESS
  • Locked
    12.  Amazon RedShift Querying
    4m 26s
    In this video, learn how to import and query data stored in Amazon Redshift. FREE ACCESS
  • Locked
    13.  DocumentDB and DynamoDB
    4m 53s
    Learn how to determine when NoSQL DocumentDB and DynamoDB should be used. FREE ACCESS
  • Locked
    14.  DocumentDB Deployment
    3m 29s
    In this video, you will deploy a DocumentDB. FREE ACCESS
  • Locked
    15.  DynamoDB Deployment
    2m 8s
    In this video, you will deploy DynamoDB. FREE ACCESS
  • Locked
    16.  Course Summary
    1m 26s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

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.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course SQL Developer
Likes 285 Likes 285