AWS Developer Associate: AWS Database Services

Amazon Web Services    |    Intermediate
  • 22 videos | 1h 26m 59s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 49 users Rating 4.6 of 49 users (49)
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

  • 2m 17s
  • 3m 34s
    Upon completion of this video, you will be able to recognize the different types of database offerings on the AWS platform and what they are used for. FREE ACCESS
  • Locked
    3.  Relational Databases
    3m 47s
    Upon completion of this video, you will be able to recognize the various relational databases available on the AWS platform. FREE ACCESS
  • Locked
    4.  Amazon Relational Database Service
    6m 31s
    After completing this video, you will be able to recognize key characteristics of Amazon Relational Database Service. FREE ACCESS
  • Locked
    5.  Nonrelational Databases
    3m 55s
    After completing this video, you will be able to recognize the various nonrelational databases available on the AWS platform. FREE ACCESS
  • Locked
    6.  Amazon DynamoDB
    3m 12s
    After completing this video, you will be able to recognize key aspects of the Amazon DynamoDB nonrelational database service. FREE ACCESS
  • Locked
    7.  In-memory Data Stores
    5m 5s
    After completing this video, you will be able to recognize in-memory data stores on AWS. FREE ACCESS
  • Locked
    8.  Cloud Database Migration
    2m 20s
    After completing this video, you will be able to recognize the options available for migrating data and databases to AWS. FREE ACCESS
  • Locked
    9.  Installing the Python SDK and PyMySQL
    3m 24s
    In this video, you will install the AWS SDK for Python boto3 and the PyMySQL client library. FREE ACCESS
  • Locked
    10.  Generating Security Groups for Amazon RDS
    4m 14s
    Find out how to generate a security group for communicating with and securing RDS databases on AWS using the AWS SDK for Python. FREE ACCESS
  • Locked
    11.  Creating an Amazon RDS Database Instance
    6m 25s
    During this video, you will learn how to create an Amazon RDS MySQL database instance. FREE ACCESS
  • Locked
    12.  Connecting to a Database Using MySQL Workbench
    4m 24s
    In this video, you will learn how to install MySQL Workbench and configure it to connect to an RDS-managed MySQL database. FREE ACCESS
  • Locked
    13.  Creating Tables in an Amazon RDS MySQL Database
    5m 20s
    Learn how to use the Python SDK to create a SQL table and add records in an Amazon RDS MySQL database. FREE ACCESS
  • Locked
    14.  Querying Tables in an Amazon RDS MySQL Database
    2m 47s
    In this video, find out how to run a query against a SQL table in Amazon RDS using the execute() method from the AWS SDK for Python. FREE ACCESS
  • Locked
    15.  Deleting Databases and Security Groups
    5m 52s
    In this video, you will delete a database instance and associated security group with the delete_db_instance() and delete_security_groups() methods using the AWS SDK for Python. FREE ACCESS
  • Locked
    16.  Creating a Table in Amazon DynamoDB
    5m 18s
    During this video, you will learn how to create a table in an Amazon DynamoDB database using the create_table() method from the AWS SDK for Python. FREE ACCESS
  • Locked
    17.  Adding Data to a DynamoDB Table
    3m 10s
    During this video, you will learn how to add items to a DynamoDB table using the put_item() method from the AWS SDK for Python. FREE ACCESS
  • Locked
    18.  Querying a DynamoDB Table
    2m 52s
    In this video, find out how to run a query against a NoSQL DynamoDB table using the query() method from the AWS SDK for Python. FREE ACCESS
  • Locked
    19.  Using a Batch Writer against a DynamoDB Table
    4m 10s
    During this video, you will learn how to call the batch_writer() method using the AWS SDK for Python to write data in a batch process to a DynamoDB table. FREE ACCESS
  • Locked
    20.  Scanning a DynamoDB Table
    3m 25s
    In this video, find out how to scan an Amazon DynamoDB table using the scan() method from the AWS SDK for Python. FREE ACCESS
  • Locked
    21.  Deleting a DynamoDB Table
    3m 15s
    In this video, you will delete an Amazon DynamoDB table using the delete_table() method from the AWS SDK for Python. FREE ACCESS
  • Locked
    22.  Course Summary
    1m 42s
    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

Course AWS Cloud Practitioner 2023: Automation & Managed Services
Rating 5.0 of 5 users Rating 5.0 of 5 users (5)
Course AWS Developer Associate 2021: Database Services
Rating 4.5 of 102 users Rating 4.5 of 102 users (102)
Course AWS Developer Associate 2022: Database Services
Rating 4.6 of 66 users Rating 4.6 of 66 users (66)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Python Development: Getting Started with Programming in Python
Rating 4.6 of 2165 users Rating 4.6 of 2165 users (2165)
Course AWS Cloud Practitioner 2022: Technology Support Resources
Rating 4.6 of 434 users Rating 4.6 of 434 users (434)
Course Generative AI and Its Impact to Everyday Business
Rating 4.6 of 893 users Rating 4.6 of 893 users (893)