Work with RDS and DynamoDB: AWS with Python and Boto3 Series

Work with RDS and DynamoDB: AWS with Python and Boto3 Series

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 3h 14m | 944 MB

Learn how to implement RDS and DynamoDB on AWS using Python API – Boto3! Implement your infrastructure with code!

In this course, we’ll start by looking at the tools and the environment that is needed to work with AWS resources. We’ll be using Python, 3 and as per the IDE, we recommend you to use PyCharm from Jetbrains. It has a free community edition.

After setting up your environment on both MacOS and Windows, we’ll create our credentials for AWS as being the AWS Access Key and AWS Secret Access Key for programmatic access to AWS resources. You’ll learn how you can set your AWS credentials globally on your computers using AWS CLI. Before jumping into the implementation, for one last tip, we’ll show you how you can have auto-complete capabilities on your PyCharm IDE with PyBoto3! Once we’re ready with our environment setup, we’ll start implementing our solution on AWS! And remember, we’ll do everything with Python code. Nothing will be done manually.

We’ll start off with RDS or Relational Database Service from AWS. I’ll teach you how to launch your own Amazon RDS Instances purely with your Python code! Then, we’ll learn how to take a snapshot or namely backup our complete database instance. Later, I’ll teach you how to restore that snapshot that you have created earlier so that you can recover your database from failures!

Next up is DynamoDB! With this very-popular NoSQL service from AWS, I’ll teach you how to create your own DynamoDB Tables on AWS with Python! You’ll learn how to provide a key schema, attribute definitions, and apply throughout to your tables.

This course starts by taking a look at the tools and the environment that you need to work with AWS resources. Lots of information, hands-on practice and experience is waiting for you in this course on AWS.

What You Will Learn

  • You’ll be able to implement any sort of infrastructure on AWS with Python using RDS and DynamoDB!
  • You’ll learn how to code against AWS API using Python and Boto3!
  • You’ll learn how to launch Relational Database Instances (RDS) on AWS using Python and Boto3!
  • You’ll learn how to launch NoSQL DynamoDB Tables on AWS using Python and Boto3!
  • You’ll be confident to work with AWS APIs using Python for any kind of AWS Resource on RDS and DynamoDB!
Table of Contents

01 Welcome
02 About This Course
03 What We Will Build in This Course
04 What Do You Need For This Course
05 Section Overview
06 About Tools and Environment
07 Create an AWS Account If You Don’t Already Have It!
08 Logging in to AWS Console and A Walkthrough
09 Let’s Create Our AWS Credentials!
10 Installing Python 3 and Pip
11 Installing AWS SDK (CLI)
12 Preparing CLI with AWS Credentials
13 Installing Boto3
14 Verifying The Setup
15 Installing Python 3 and Pip
16 Installing AWS SDK (CLI)
17 Preparing CLI with AWS Credentials
18 Installing Boto3
19 Verifying The Setup
20 Section Overview
21 Scenario – AWS Console Perspective of What We’ll Build
22 Setting Up Our Project with PyCharm IDE
23 Let’s Check Out Boto3 API Docs!
24 [Tip] Auto-Complete Magic with Pyboto on PyCharm IDE!
25 Creating an RDS PostgreSQL DB Instance – Part 1
26 Creating an RDS MySQL PostgreSQL DB Instance – Part 2
27 AWS Console Checkpoint – RDS Instanc
28 Connecting to PostgreSQL RDS Instance with Postico
29 Describing RDS Instance
30 Modifying RDS Instance
31 Backing Up RDS Instance
32 Restoring RDS Instance
33 Deleting RDS Instance
34 Section Summary
35 Section Overview
36 Scenario – AWS Console Perspective of What We’ll Build
37 Setting Up Our Project with PyCharm IDE
38 Let’s Check Out Boto3 API Docs!
39 Creating Table
40 AWS Console Checkpoint – DynamoDB Table
41 Describing Table
42 Updating Table
43 Deleting Table
44 Section Summary
45 What Have We Learned
46 Thank You!