SkillSoft Explore Course – Lambers, Inc.

Certification Amazon AWS Certified Developer - Associate AWS Certified Developer - Associate 2020

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.

Asset ID	it_clawsda2020_05_enus
Course Type	Video Course
Course Category	Amazon

Objectives
AWS Developer Associate: AWS Database Services 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

Objectives

AWS Developer Associate: AWS Database Services

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