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 courserecognize the different types of database offerings on AWS platform and what they are used forrecognize the various relational databases available on the AWS platformrecognize key characteristics of the fully managed Amazon Relational Database Servicerecognize the various nonrelational databases available on the AWS platformrecognize key aspects of the fully managed Amazon DynamoDB nonrelational database servicerecognize in-memory data stores on AWSrecognize the options available for migrating data and databases to AWSinstall the AWS SDK for Python boto3 and the PyMySQL client librarygenerate a security group for communicating with and securing RDS databases on AWS using the AWS SDK for Pythoncreate a MySQL database instance using Amazon RDS
-
install MySQL Workbench and configure it to connect to an RDS-managed MySQL databaseuse the Python SDK to create a SQL table and add records in an Amazon RDS MySQL databaserun a query against a SQL table in Amazon RDS using the execute() method from the AWS SDK for Pythondelete a database instance and associated security group with the delete_db_instance() and delete_security_groups() methods using the AWS SDK for Pythoncreate a table in an Amazon DynamoDB database using the create_table() method from the AWS SDK for Pythonadd items to a NoSQL DynamoDB table with the put_item() method from the AWS SDK for Pythonrun a query against a NoSQL DynamoDB table using the query() method from AWS SDK for Pythoncall the batch_writer() method using the AWS SDK for Python to write data in a batch process to a NoSQL DynamoDB tablescan an Amazon DynamoDB table in code using the scan() method from the AWS SDK for Pythondelete an Amazon DynamoDB table using the delete_table() method from the AWS SDK for Pythonsummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview2m 17sUP NEXT
-
2.AWS Cloud Database Offerings3m 34s
-
3.Relational Databases3m 47s
-
4.Amazon Relational Database Service6m 31s
-
5.Nonrelational Databases3m 55s
-
6.Amazon DynamoDB3m 12s
-
7.In-memory Data Stores5m 5s
-
8.Cloud Database Migration2m 20s
-
9.Installing the Python SDK and PyMySQL3m 24s
-
10.Generating Security Groups for Amazon RDS4m 14s
-
11.Creating an Amazon RDS Database Instance6m 25s
-
12.Connecting to a Database Using MySQL Workbench4m 24s
-
13.Creating Tables in an Amazon RDS MySQL Database5m 20s
-
14.Querying Tables in an Amazon RDS MySQL Database2m 47s
-
15.Deleting Databases and Security Groups5m 52s
-
16.Creating a Table in Amazon DynamoDB5m 18s
-
17.Adding Data to a DynamoDB Table3m 10s
-
18.Querying a DynamoDB Table2m 52s
-
19.Using a Batch Writer against a DynamoDB Table4m 10s
-
20.Scanning a DynamoDB Table3m 25s
-
21.Deleting a DynamoDB Table3m 15s
-
22.Course Summary1m 42s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.