AWS Developer Associate: AWS Database Services

Amazon Web Services 2020
  • 22 Videos | 1h 36m 59s
  • Includes Assessment
  • Earns a Badge
Likes 32 Likes 32
Data storage and management is central to any application. AWS offers several different types of databases and database services for virtually any type of application and as a developer, it's important to recognize the various database offerings on AWS Cloud. In this course, you'll learn about the various database services offered on the AWS platform. You'll explore relational and nonrelational database options available on AWS, Amazon Relational Database Service, and Amazon DynamoDB. You'll examine in-memory data stores on AWS and options available for migrating data and databases to AWS. Next, you'll learn how to install the AWS SDK for Python and the PyMySQL client library on a development machine and use them to create a security group for RDS in Python code. You'll then see how to create an RDS database instance using the MySQL database engine on AWS and how to install and configure MySQL Workbench to talk to the RDS database instance. Next, you'll learn how to create tables and add records the RDS instance, query that table, and delete it and the security group, all within Python code. You'll see how to create a table in Amazon DynamoDB, add items to the table, and use both the scan and query operations to retrieve data from the table using Python code. Finally, you'll see how to clean things up by deleting the DynamoDB table using Python code. This course is one of a collection of courses that prepares learners for the AWS Certified Developer - Associate 2020 certification exam.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    recognize the different types of database offerings on AWS platform and what they are used for
    recognize the various relational databases available on the AWS platform
    recognize key characteristics of the fully managed Amazon Relational Database Service
    recognize the various nonrelational databases available on the AWS platform
    recognize key aspects of the fully managed Amazon DynamoDB nonrelational database service
    recognize in-memory data stores on AWS
    recognize the options available for migrating data and databases to AWS
    install the AWS SDK for Python boto3 and the PyMySQL client library
    generate a security group for communicating with and securing RDS databases on AWS using the AWS SDK for Python
    create a MySQL database instance using Amazon RDS
  • install MySQL Workbench and configure it to connect to an RDS-managed MySQL database
    use the Python SDK to create a SQL table and add records in an Amazon RDS MySQL database
    run a query against a SQL table in Amazon RDS using the execute() method from the AWS SDK for Python
    delete a database instance and associated security group with the delete_db_instance() and delete_security_groups() methods using the AWS SDK for Python
    create a table in an Amazon DynamoDB database using the create_table() method from the AWS SDK for Python
    add items to a NoSQL DynamoDB table with the put_item() method from the AWS SDK for Python
    run a query against a NoSQL DynamoDB table using the query() method from AWS SDK for Python
    call the batch_writer() method using the AWS SDK for Python to write data in a batch process to a NoSQL DynamoDB table
    scan an Amazon DynamoDB table in code using the scan() method from the AWS SDK for Python
    delete an Amazon DynamoDB table using the delete_table() method from the AWS SDK for Python
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 17s
    UP NEXT
  • Playable
    2. 
    AWS Cloud Database Offerings
    3m 34s
  • Locked
    3. 
    Relational Databases
    3m 47s
  • Locked
    4. 
    Amazon Relational Database Service
    6m 31s
  • Locked
    5. 
    Nonrelational Databases
    3m 55s
  • Locked
    6. 
    Amazon DynamoDB
    3m 12s
  • Locked
    7. 
    In-memory Data Stores
    5m 5s
  • Locked
    8. 
    Cloud Database Migration
    2m 20s
  • Locked
    9. 
    Installing the Python SDK and PyMySQL
    3m 24s
  • Locked
    10. 
    Generating Security Groups for Amazon RDS
    4m 14s
  • Locked
    11. 
    Creating an Amazon RDS Database Instance
    6m 25s
  • Locked
    12. 
    Connecting to a Database Using MySQL Workbench
    4m 24s
  • Locked
    13. 
    Creating Tables in an Amazon RDS MySQL Database
    5m 20s
  • Locked
    14. 
    Querying Tables in an Amazon RDS MySQL Database
    2m 47s
  • Locked
    15. 
    Deleting Databases and Security Groups
    5m 52s
  • Locked
    16. 
    Creating a Table in Amazon DynamoDB
    5m 18s
  • Locked
    17. 
    Adding Data to a DynamoDB Table
    3m 10s
  • Locked
    18. 
    Querying a DynamoDB Table
    2m 52s
  • Locked
    19. 
    Using a Batch Writer against a DynamoDB Table
    4m 10s
  • Locked
    20. 
    Scanning a DynamoDB Table
    3m 25s
  • Locked
    21. 
    Deleting a DynamoDB Table
    3m 15s
  • Locked
    22. 
    Course Summary
    1m 42s