AWS Developer Associate: AWS Database Services
Amazon Web Services 2020
| Intermediate
- 22 videos | 1h 26m 59s
- Includes Assessment
- Earns a Badge
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 34sUpon 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
-
3. Relational Databases3m 47sUpon completion of this video, you will be able to recognize the various relational databases available on the AWS platform. FREE ACCESS
-
4. Amazon Relational Database Service6m 31sAfter completing this video, you will be able to recognize key characteristics of Amazon Relational Database Service. FREE ACCESS
-
5. Nonrelational Databases3m 55sAfter completing this video, you will be able to recognize the various nonrelational databases available on the AWS platform. FREE ACCESS
-
6. Amazon DynamoDB3m 12sAfter completing this video, you will be able to recognize key aspects of the Amazon DynamoDB nonrelational database service. FREE ACCESS
-
7. In-memory Data Stores5m 5sAfter completing this video, you will be able to recognize in-memory data stores on AWS. FREE ACCESS
-
8. Cloud Database Migration2m 20sAfter completing this video, you will be able to recognize the options available for migrating data and databases to AWS. FREE ACCESS
-
9. Installing the Python SDK and PyMySQL3m 24sIn this video, you will install the AWS SDK for Python boto3 and the PyMySQL client library. FREE ACCESS
-
10. Generating Security Groups for Amazon RDS4m 14sFind out how to generate a security group for communicating with and securing RDS databases on AWS using the AWS SDK for Python. FREE ACCESS
-
11. Creating an Amazon RDS Database Instance6m 25sDuring this video, you will learn how to create an Amazon RDS MySQL database instance. FREE ACCESS
-
12. Connecting to a Database Using MySQL Workbench4m 24sIn this video, you will learn how to install MySQL Workbench and configure it to connect to an RDS-managed MySQL database. FREE ACCESS
-
13. Creating Tables in an Amazon RDS MySQL Database5m 20sLearn how to use the Python SDK to create a SQL table and add records in an Amazon RDS MySQL database. FREE ACCESS
-
14. Querying Tables in an Amazon RDS MySQL Database2m 47sIn 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
-
15. Deleting Databases and Security Groups5m 52sIn 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
-
16. Creating a Table in Amazon DynamoDB5m 18sDuring 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
-
17. Adding Data to a DynamoDB Table3m 10sDuring 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
-
18. Querying a DynamoDB Table2m 52sIn 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
-
19. Using a Batch Writer against a DynamoDB Table4m 10sDuring 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
-
20. Scanning a DynamoDB Table3m 25sIn this video, find out how to scan an Amazon DynamoDB table using the scan() method from the AWS SDK for Python. FREE ACCESS
-
21. Deleting a DynamoDB Table3m 15sIn this video, you will delete an Amazon DynamoDB table using the delete_table() method from the AWS SDK for Python. FREE ACCESS
-
22. Course Summary1m 42sIn 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.
